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.