Question

62 views5 hours ago

1

Apurva Tandon [DevOps Advocate]1.33K 6 hours ago 3 Comments

How to get in all rows with values for a table paramater via automation script?

Felix Wesemeier [DevOps Catalyst] Posted new comment 5 hours ago

Felix Wesemeier [DevOps Catalyst] commented 5 hours ago

Hi Apurva,
can you check if you can use GetTable:
https://docs.dataminer.services/develop/api/types/Skyline.DataMiner.Core.DataMinerSystem.Common.IDmsElement.GetTable.html
and then some method of your choice from here: https://docs.dataminer.services/develop/api/types/Skyline.DataMiner.Core.DataMinerSystem.Common.IDmsTable.html

Apurva Tandon [DevOps Advocate] commented 5 hours ago

How to use this method? any code sample
In my code I want to get like a table data for specific column in table

Felix Wesemeier [DevOps Catalyst] commented 5 hours ago

Thanks to Samuel you already have a sample

1 Answer

Hi Apurva,
can you check if you can use GetTable:
https://docs.dataminer.services/develop/api/types/Skyline.DataMiner.Core.DataMinerSystem.Common.IDmsElement.GetTable.html
and then some method of your choice from here: https://docs.dataminer.services/develop/api/types/Skyline.DataMiner.Core.DataMinerSystem.Common.IDmsTable.html
How to use this method? any code sample
In my code I want to get like a table data for specific column in table

score 0 · Answer 1 · 2025-02-27T14:55:30+00:00

Hi Apurva,
One possible solution is to use the QueryData method with a ColumnFilter from the IDmsTable interface.

Below is a small snippet demonstrating how to use this method.

IDms dms = engine.GetDms();
IDmsElement element = dms.GetElement(/*Element Name*/);
IDmsTable table = element.GetTable(/*Table PID*/);

ColumnFilter[] columnFilters = new[] {
new ColumnFilter{ Pid = /*Column PID*/, Value = /*value to compare*/, ComparisonOperator = ComparisonOperator.Equal},
};

List<object[]> rows = table.QueryData(columnFilters);