I have to fetch data from two separate queries within the same API action.
Is there a trick to have both queries taken into account in my repeat expression? This && condition below does not work.
Hi Fred,
You would do it with one query using a join. Simply add both data tables to the same query in server connect.
Thanks but this is what I had before.
My first query fetches simple fields whereas the second has aggregates and aliases. Making one single join query fails: returns empty […].
So I resorted to splitting the queries. Now I need my repeat to take both queries into account somehow.
More details on what I try to accomplish…
When I do a repeat (due to multiple keywords search), I find both separate queries and can build my bindings using data from both queries:
But I am making a single word search with no repeat, so my expression is as follows where I need to select either one query. By picking the DataSearchedKeywords query, I lose the RatingSearch query in the data picker. How can I combine both so they are available in the data picker?
This looks wrong. You need to restructure the server action data to return the complete data set as a single entity (JSON).
Like Brad has suggested, use join to merge the data sets. Or you can use custom query if a simple join is not possible.
Yes Sid, thanks for your input.
I previously used JOIN to merge a few tables but noticed that the query returned nothing […] when I mixed in aggregates and aliases to “regular” fields, see below.
That’s my query with aggregates and aliases at the bottom.
Why do I get an empty result? My query returns a result when I remove the tables that needs aggregates/aliases.
Open this SA in editor and copy the query.
Run the query directly on the DB and try to find what the error is with the join.
Maybe you need left join, instead of inner join.
Try LEFT JOIN instead of INNER.
1 Like
Great, works!
I added the last table with the aggregates and aliases with a LEFT join method 
1 Like