I have noticed a few use cases where I could use a combination of the All (And) and Any (Or) filtering for a table. For example say you want all work order ID Numbers > 5 that are in manufacturing area 1 or area 3. Tulip currently only allows for all three of these to be either all or any. To be more clear I mean to do things in this format (BooleanExpression1 And (BooleanExpression2 OR BooleanExpression3)) as an option where the final query would pull records where 1 is true and either 2 or 3 are true. This would allow us to have more control over our filters and queries.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Table Quires: Combination of 'Any' and 'All' conditions | 1 | 40 | August 26, 2024 | |
| Tulip table filter: add expressions | 5 | 179 | February 2, 2024 | |
| Combined filter of Interactive Table | 3 | 709 | November 25, 2022 | |
| Table API - How to filter by combination of two or more fields? | 4 | 687 | March 3, 2021 | |
| Multiselect Input for Dynamic Table Filtering on Boolean Values | 0 | 198 | July 21, 2023 |