I know there have been many requests for nested any/all logic on interactive table filtering. Today I came across a compounding issue which is a serious blocker for us. Its a small detail but this puts our entire architecture in a bind. Unsure how to proceed.
Filtering for Work Orders with no open NCRs is impossible because Tulip’s less than function excludes null values.
What is the data-source?
I know this kind of issue and unfortunately you can not filter an and or combination.
As a workaround:
Could you call the data with one of the filters already applied?
e.g.
current app is in InspectionsFilterArray < 1 or null with “any”or
2. you call with <1or null and only use the filer current app is in InspectionsFilterArray for the interactive Table.
If its on a Tulip Table, you unfortunately cant query, because these are not filterable but you could use the API.
The downside is, you can not select for a Record Placeholder directly (only with additional trigger logic).
Can you use successive queries/aggregations to generate a list of record IDs and display only those records where the ID “IS IN” your ultimate list?