portal entry

select a category, or use search below
(searches all categories and all time range)
Title:

Unioning queries using query of query

| View in Portal
October 17, 2017 05:14:02 PM GMT
2 Comments 
Here is how you can union together two queries using query of query. This function would take two queries and use query of query to combine them into a single query. The code below assumes the columns from the two source queries are identical. You would need to modify if that isn’t the case. private any function combineQuery(qA, qB) { var qry1Result = arguments.qA; var qry2Result = arguments.qB; var qoqResult = ''; // create new query object var qoq = […]
Labels: Blog, FAQ, functions, query, query of queries, script

Comments:

First of all: Do not use qoq. Every SQL statement can be solved by a sub selection or joins. The database is build for and could it better.
Comment by Norbert Liedert
1227 | August 21, 2018 07:12:49 AM GMT
QoQ needs to be used when you have to union results of a query with the data from an API. There is no join for that.
Comment by LrdJester
1989 | April 11, 2019 03:11:59 PM GMT