I would like to filter data in Interactive table by two fields like this:
This kind of filtering is working well. But this table contains different types of (in this case) tools and only one type of tools should be visible in this step.
So Interactive table would require filter with any (or) and at the same time all (and) condition. Something like this
in sql way (pseudo code) where (Description like [filterText] or ID like [filterText]) and ToolKitId is not null
I tried to solve this using Table Query as datasource in Interactive table but unfortunately filter isn’t available if query is selected as datasource.
Is something like that available in Tulip?