Hi Dojo community,
I am working with a script that retrieves data from a table using the GetColumns method. However, the table spans multiple pages and GetColumns only retrieves data from the first page. What method or approach could be used instead to extract specified columns across all pages?
Hi Andrea, the QueryData method can be used for this:
IDms myDms = protocol.GetDms();
var element = myDms.GetElement("element name");
var table = element.GetTable(96);
var filters = new List<ColumnReturnFilter>
{
new ColumnReturnFilter { Pid = 97},
new ColumnReturnFilter { Pid = 103 },
new ColumnReturnFilter { Pid = 109 },
};
IEnumerable<object[]> result = table.QueryData(filters);
The return value is an IEnumerable where each item respresents a row with the selected column values (the result will have an additional column entry for the key).