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.
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