Apply "exclude" filter on a string using DataManager
Hi,
we have users who need to load data via the DataManager without scripting. That works fine, but the filter capabilities that create a "where(...)" clause in the locked script seems problematic.
How can we exclude rows with a specific string in a data field? Specifically we want to exclude "-" in the field ID from being loaded. Usually, I would use something like
load * from xyz where(ID<>'-')
Unfortunately the DataManager offers only <, >, =, >= and <= but not <> as criteria.
