Hi All
I am trying to check a table and if a row has a specific value in a parameter such as "Not Processed" then this will trigger another method.
Is there a way to check a table for a value and then return the index?
Thanks
Ryan
Hi Ryan,
I think what you are looking for are the GetKeysForIndex() and GetKeysForValues() methods. See this page for more information: https://docs.dataminer.services/develop/schemadoc/Protocol/ColumnOptionOptionsOverview.html#requesting-index-values-from-index-columns.
The GetKeysForValue method can be used as follows, to search for 'my value' in column with idx 2 of table 1000.
var foundKeys = protocol.GetKeysForValue(1000, 0, 2, "my value");
if (foundKeys.Any())
{
ExecuteSomeMethod(protocol, foundKeys);
}
Hello Ryan,
Can you give more context as to how you want to check your table, like if any cell in a column has that specific value?