Table Queries functionality "in" and "not in"

Support, Troubleshooting, & Help
1

While table queries are very useful they provide only basic functionality. Coming from SQL databases I expected that at least basic query functionalities would be available thru Queries - I’m greatly missing two tables in query or at least query for data filtering based on data from another table.

My use case:
I have two tables. One is Code list table - table contains all available production machines (Line1, Line2, Line3 …) . The other table contains selected production machines for SKU. This is configurable thru application. So second table will have multiple production lines for SKU. EG:

SKU - ProductionLineId
10001 - Line1
10001 - Line2
10001 - Line4
10002 - Line1
10003 - Line3
etc…

If query would allow filtering based on values in another table Code list table can be automatically queried based on ProductionLineId values from another table (like equivalent “not in” functionality from SQL). User would not be able to select same production line and create table record that already exist in other table.

So I have no simple way to prevent multiple identical records.

Also unique index definition in SKU - ProductionLineId would prevent creation of identical records but this is another very useful functionality which would help to maintain table data integrity.

Are above functionalities planed for Tulip or is there any other way to implement query functionality described above.

Regards.

2

hello @ermingut, based on what I’m understanding, you’d like to filter the Query by an Array correct?? if so, we are releasing functionality to achieve this in Release 205 (going live on 2021-04-11T23:00:00Z). as you can see here, you can filter can be of type Array:

Screen Shot 11
Screen Shot 113104×1910 462 KB

Screen Shot 12
Screen Shot 123104×1910 414 KB

would this help in what you’re trying to achieve?? let us know!!

3

Hi.

Yes, this functionality is exactly what I need - I can fill array thru app. But my array is actually from filtered table (query) where I need to put one column data into array (let’s say that filtered query has 5 rows and one column from this rows is my array).How to fill array from table field is another topic that I opened.

Ermin

4

I will use this feature in my tulip apps in the future

5

great to hear @mcc6025, looking forward to seeing what you build with Table Queries and Aggregations!!