I have a question similar to other posts but it is slightly different.
I have a Epicor connector that returns an array based on a truck number. The array contains a list of values (Kit ID) that correspond to a Tulip table with that same value (Kit ID). I believe I can use the new query function to filter the table in the app. Since it is an interactive table the operator can then select the record and be directed to the appropriate app.
The problem I run into is getting the connector array data translated into something I can use in the query. The array returns 1600-1700 Kit ID’s (many of them repeating) I just need a list/string/etc that can be stored as a variable(or maybe an expression?) that the query can use.
Any help would be greatly appreciated.