Filter interactive table by "NOT IN"

Support, Troubleshooting, & Help
1

I have table of all tools and tool id is used to identify diferent tools (Id is like unique tool code. Eg: BH1B5_3, BH123_1, BF324 etc…)

Each tool can be part of another group which is another table (ToolGroup) and contains ToolIDs that are part of this group. When selecting tool for group only “free” tools can be selected as candidates for tool group. So I somehow had to filter out “used” tools that already exists in ToolGroup table.

Filter should use something like “not in” operator on array of ToolIDs. I can extract array from ToolGrop table using TableApi.

But unfortunately I have no option to use “is not in” interactive table filter.

image
image1100×569 34.9 KB

“Is in” is available but not in option is missing.

image
image1027×738 37.7 KB

Any suggestion how to filter interactive table with “is not in” option - or any other option to achieve functionality needed.

Thanks.

1 Like