A table can be filtered on a column that has a certain value e.g. value=2003 == 1
Is it possible to have a similar filter to return rows where values are not “Not Initialized” or doesn’t contain an empty string value? Something similar like !String.IsNullOrEmpty(columnValue);
I currently need to add an extra column as a helper to indicate if the column I originally want to filter on has a value or not and then execute the filter on that helper column, but that seems a bit cumbersome and a waste of memory if we could simply filter out empty string values.
As far as I know, there’s no magic keyword to exclude values that are ‘Not Initialized’ (empty).
You could use a trick with wildcards:
value=2003 == ?*
Be aware that this might cause an extra performance hit to evaluate the filter, as the wildcard needs to checked against the values.
Depending on where you want to use the query result, the other alternative is to still include the ‘Not Initialized’ values in the query and filter out those rows afterwards.
This is possible by specifying a full filter:
fullFilter=(2003 != ”) AND (2003 != ‘Not Initialized’)
It works to filter out empty string values, but not for the ‘Not Initialized’ ones
The filter indeed works to give the desired result. As this is a filter being used in a tag of an EPM (CPE) manager driver, I can’t filter it out afterwards. I’ll take the warning about the performance hit into account as my setup contains then-thousands of rows and will fill in the not initialized cells with empty strings and then use the first part of the fullFilter that Wim suggested