I am trying to query multiple product tables, and return one result based on the airdata table “__id”.
If I query a single table, I transform the result and use the data to form a container list.
When searching multiple tables, would I merge the results, or is there a better way to combine the results?
Hey @Chris_Phillips, just to make sure i understand, you have multiple tables and you’re doing a lookup against those tables and searching for a single product based off of an
If you can provide some more information on the structure of the tables and what you want as an output, that would be helpful!
Correct, we don’t want the user to have to select which product. So the search feature will find the correct data from any table.
Please let me know if you need additional information.