{"id":41513,"date":"2023-08-09T16:49:51","date_gmt":"2023-08-09T16:49:51","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=41513"},"modified":"2024-06-21T09:15:29","modified_gmt":"2024-06-21T09:15:29","slug":"combining-results-of-multiple-custom-queries","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/","title":{"rendered":"How to Combine Results of Multiple Custom Queries into One Custom Query"},"content":{"rendered":"\n

Let us clarify which results you can get via this approach.<\/p>\n\n\n\n

There is a case when you need to show, e.g., Bestseller Woocommerce products first, and then other products by certain product categories in just one Listing Grid<\/strong> widget.<\/p>\n\n\n\n

Another use case is when the posts from different JetEngine<\/em> Data Stores<\/strong><\/a> need to be displayed in one Listing Grid<\/strong>.<\/p>\n\n\n\n

There is also a case when the posts or users need to be queried by the Switcher<\/strong> meta field. Firstly you may need to show the items that have the Switcher <\/strong>in the enabled state and, after them, the items that have the Switcher <\/strong>in the deactivated state. We will see how this case can be implemented in the instructions below.<\/p>\n\n\n\n

To sum up, the general idea is to provide different orders\/queries for different parts of the Listing Grid<\/strong> since such a request exceeds the opportunities of just one custom query.<\/p>\n\n\n\n

Add a Meta Field into the Meta Box Used in the Query<\/h2>\n\n\n\n
\n

Before you start, ensure to create a Meta Box for users in the JetEngine > Meta Boxes <\/em><\/strong>tab. More details can be found in the How to Apply Meta Boxes to Users<\/strong><\/a> tutorial.<\/p>\n\n\n\n

Let us add the Switcher<\/strong> meta field to the Meta Box to query the users by this field later. Save the changes by clicking the \u201cUpdate Meta Box\u201d <\/strong>button afterward.\u00a0<\/p>\n\n\n\n

\"switcher<\/div>\n\n\n\n

Also, make sure to go to the Users <\/em><\/strong>tab in the admin panel, enable the Switcher<\/strong> for needed users on the user editing page, and save<\/strong> it.<\/p>\n\n\n\n

\"enable<\/div>\n<\/div><\/div>\n\n\n\n

Create a Custom Query with One Set of Query Clauses<\/h2>\n\n\n\n
\n

Next, we need to go to JetEngine > Query Builder<\/em><\/strong> and hit the \u201cAdd New\u201d<\/strong> button.\u00a0<\/p>\n\n\n\n

Type the Name<\/strong>. The Query Type <\/strong>should be \u201cUsers Query\u201d since the Switcher<\/strong> meta field has been created for users.<\/p>\n\n\n\n

\"user<\/div>\n\n\n\n

Next, open the Meta Query<\/strong> tab, and press the \u201cAdd New\u201d <\/strong>button to add a Meta Query Clause<\/strong>.\u00a0<\/p>\n\n\n\n

Enter the Switcher Field key\/name<\/strong>, select the \u201cEqual (=)\u201d option in the Compare <\/strong>field, enter the \u201ctrue\u201d Value<\/strong>, and pick the \u201cChar\u201d Type<\/strong>.\u00a0<\/p>\n\n\n\n

The Switcher has a \u201ctrue\u201d Value<\/strong> when enabled and a \u201cfalse\u201d Value<\/strong> when disabled. This clause means that the users with enabled switcher are pulled.<\/p>\n\n\n\n

\"meta<\/div>\n\n\n\n

Now, you can click the \u201cAdd Query\u201d<\/strong> button to save this custom query.<\/p>\n<\/div><\/div>\n\n\n\n

Create a Custom Query with Another Set of Query Clauses<\/h2>\n\n\n\n
\n

The next custom query is for pulling users with the disabled state of the Switcher<\/strong> meta field. You can copy<\/strong> the custom query created in the previous step and add the needed changes to the duplicated query.<\/p>\n\n\n\n

\"copy<\/div>\n\n\n\n

We renamed the new custom query, went to the Meta Query <\/strong>tab, and edited the Value<\/strong> for the Meta Query Clause <\/strong>by Switcher to \u201cfalse.\u201d After that, the custom query can be saved.<\/p>\n\n\n\n

\"set<\/div>\n<\/div><\/div>\n\n\n\n

Create a SQL Query to Combine Two Custom Queries<\/h2>\n\n\n\n
\n

The next custom query will combine the previous two queries. Create a new query, Name<\/strong> it, and select the \u201cSQL\/AI Query\u201d Type<\/strong>. Then, enable the Advanced\/AI mode <\/strong>toggle.<\/p>\n\n\n\n

\"SQL\/AI<\/div>\n\n\n\n

In the SQL Query<\/strong> field, add the SQL snippet provided below. This SQL query combines items from two other queries. This way, users with the enabled Switcher are displayed first, and users with the disabled Switcher are shown second.<\/p>\n\n\n\n

SELECT ID\n\nFROM {prefix}users\n\nWHERE ID IN (\n\n%query_results|135%{\"fallback\":\"'999999999'\"},\n\n%query_results|136%{\"fallback\":\"999999999\"}\n\n)\nORDER BY FIELD( \n   ID,\n %query_results|135%{\"fallback\":\"'999999999'\"},\n \n %query_results|136%{\"fallback\":\"999999999\"}\n)<\/code><\/pre>\n\n\n
<\/svg><\/div>
Warning<\/div>
Note that \u201c135\u201d and \u201c136\u201d are IDs of the custom queries from which the results are pulled. These numbers need to be substituted with the IDs of the custom queries from your website.<\/p><\/div><\/div>\n\n\n\n
\"SQL<\/div>\n\n\n\n
The custom query ID can be found in the URL of the Edit Query<\/strong> page.<\/p>\n\n\n\n
\"query<\/div>\n\n\n\n
The fallback<\/strong> has the \u2018999999999\u2019 number because it must be a unique number that is not reserved by some instance, like post ID. If you want to use a fallback<\/strong> with a string value, you also need to add single quotes.<\/p>\n\n\n\n
Now the SQL query is completed, and you can hit the \u201cAdd\/Update Query\u201d <\/strong>button.<\/p>\n\n\n\n
SQL query for posts<\/h3>\n\n\n\n
Let us provide an example of the SQL snippet in case the posts are queried instead of users.<\/p>\n\n\n\n
In this case, you need to write the \u201cposts\u201d table in the custom query instead of \u201cusers.\u201d<\/p>\n\n\n\n
SELECT ID\r\n\r\nFROM {prefix}posts\r\n\r\nWHERE ID IN (\r\n\r\n%query_results|135%{\"fallback\":\"'999999999'\"},\r\n\r\n%query_results|136%{\"fallback\":\"999999999\"}\r\n\r\n)\r\nORDER BY FIELD( \r\n   ID,\r\n %query_results|135%{\"fallback\":\"'999999999'\"},\r\n \r\n%query_results|136%{\"fallback\":\"999999999\"}\r\n)\r<\/code><\/pre>\n<\/div><\/div>\n\n\n\n
Create a Custom Query to Pull Combined Results from the SQL Query<\/h2>\n\n\n\n
<\/svg><\/div>
Warning<\/div>
This step is required if the Listing Grid<\/strong> that uses this custom query needs to be filtered by the JetSmartFilters<\/em> plugin.<\/p><\/div><\/div>\n\n\n\n
At this stage, we need to create another custom query in the Query Builder<\/strong>.<\/p>\n\n\n\n
A Listing Grid<\/strong> that uses the Advanced SQL custom query can not be filtered, so it is important to create another user, posts, etc. query which pulls all combined items from the Advanced SQL query.<\/p>\n\n\n\n
Therefore, add a new query, name it and select the \u201cUsers Query\u201d Type<\/strong>.<\/p>\n\n\n\n
\"custom<\/div>\n\n\n\n
Then, proceed to the Include\/Exclude<\/strong> tab, click the coin-stack icon<\/strong>, and add the \u201cQuery Results\u201d macro into the Include<\/strong> field.<\/p>\n\n\n\n
For the \u201cQuery Results\u201d macro, select the Advanced SQL Query<\/strong> built in the previous step. Then pick the \u201cList of selected fields from item object\u201d option in the Return<\/strong> field, and write \u201cID\u201d into the Comma-separated fields list<\/strong>. Then, push the \u201cApply\u201d <\/strong>button.<\/p>\n\n\n\n
Now, this user query has a list of users combined in the SQL query.\u00a0<\/p>\n\n\n\n
\"Query<\/div>\n\n\n\n
Next, go to the Misc<\/strong> tab, and pick the \u201cBy the included list of user IDs (requires the Include parameter)\u201d option in the Order by <\/strong>field. This order will ensure the users with enabled Switcher meta field are displayed first, and users with disabled Switcher are shown afterward.<\/p>\n\n\n\n
\"order<\/div>\n\n\n\n
Now, you can hit the \u201cAdd\/Update Query\u201d <\/strong>button.<\/p>\n\n\n\n
Create a Listing for Users<\/h2>\n\n\n\n
Go to JetEngine > Listings<\/em><\/strong> and click the \u201cAdd New\u201d<\/strong> button. Select \u201cUsers\u201d as the Listing source<\/strong>, enter the Listing item name<\/strong>, and pick the \u201cElementor\u201d or \u201cBlocks (Gutenberg)\u201d Listing view<\/strong>. Then, click the \u201cCreate Listing Item\u201d <\/strong>button.<\/p>\n\n\n\n
\"setup<\/div>\n\n\n\n
In the Listing template editing page, you can add the Dynamic Field<\/strong><\/a> widget or block to show the user data. We added the Dynamic Field<\/strong> to display some text based on the state of the Switcher<\/strong> meta field. Select the \u201cMeta Data\u201d as the Source<\/strong>, and pick the switcher Meta Field<\/strong> from the user Meta Box.<\/p>\n\n\n\n
To show the different text based on the value of the Switcher<\/strong> meta field, enable the Filter field output <\/strong>toggle. Select the \u201cSwitcher field values\u201d as the Callback<\/strong>.\u00a0<\/p>\n\n\n\n
\"switcher<\/div>\n\n\n\n
Then, add a needed text for each state into the Text if enabled <\/strong>and Text is disabled <\/strong>fields. In our case, the \u201cThis user is verified!\u201d text will appear when the user has the switcher in the enabled state, and the \u2019This user is unverified.\u2019 text will be shown when the user has the switcher in the disabled state.<\/p>\n\n\n\n
\"text<\/div>\n\n\n\n
At this point, the Listing template can be saved by clicking the \u201cUpdate\u201d <\/strong>button.<\/p>\n<\/div><\/div>\n\n\n\n
Output the Listing on the Front End<\/h2>\n\n\n\n
\n
Now, you can add the Listing Grid<\/strong> widget or block to the needed page and select the Listing<\/strong> template for Users that has just been created in the General <\/strong>settings tab.<\/p>\n\n\n\n
\"Listing<\/div>\n\n\n\n
Open the Custom Query <\/strong>tab, enable the Use Custom Query <\/strong>toggle, and select the lastly created Custom Query <\/strong>to keep the Users in the desired order.<\/p>\n\n\n\n
\"enable<\/div>\n\n\n\n
Let us save the page by clicking the \u201cUpdate\u201d <\/strong>button and check the result on the front end.<\/p>\n\n\n\n
We can see the desired result is achieved. Firstly, the users with the enabled switcher are displayed, and then the users with the disabled switcher.<\/p>\n\n\n\n
\"listing<\/div>\n<\/div><\/div>\n\n\n\n
That is all. Now you know how to combine multiple custom queries into one to arrange an advanced order in the Listing Grid<\/strong> widget or block with the JetEngine <\/em>WordPress plugin.<\/p>\n","protected":false},"excerpt":{"rendered":"
This tutorial covers the topic of using Query Builder to show results from more than one query in just one Listing Grid.<\/p>\n","protected":false},"author":8,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[405],"yoast_head":"\nHow to Combine Results of Multiple Custom Queries into One Custom Query | Crocoblock<\/title>\n<meta name=\"description\" content=\"This tutorial describes how to use Query Builder to show results from more than one query in one JetEngine Listing Grid.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Combine Results of Multiple Custom Queries into One Custom Query | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"This tutorial describes how to use Query Builder to show results from more than one query in one JetEngine Listing Grid.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-21T09:15:29+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/08\/Screenshot_120.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/\",\"name\":\"How to Combine Results of Multiple Custom Queries into One Custom Query | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2023-08-09T16:49:51+00:00\",\"dateModified\":\"2024-06-21T09:15:29+00:00\",\"description\":\"This tutorial describes how to use Query Builder to show results from more than one query in one JetEngine Listing Grid.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Articles\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/articles\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Combine Results of Multiple Custom Queries into One Custom Query\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"name\":\"Help Center\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#organization\",\"name\":\"Help Center\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"contentUrl\":\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg\",\"caption\":\"Help Center\"},\"image\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Combine Results of Multiple Custom Queries into One Custom Query | Crocoblock","description":"This tutorial describes how to use Query Builder to show results from more than one query in one JetEngine Listing Grid.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/","og_locale":"en_US","og_type":"article","og_title":"How to Combine Results of Multiple Custom Queries into One Custom Query | Crocoblock","og_description":"This tutorial describes how to use Query Builder to show results from more than one query in one JetEngine Listing Grid.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/","og_site_name":"Help Center","article_modified_time":"2024-06-21T09:15:29+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/08\/Screenshot_120.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/","name":"How to Combine Results of Multiple Custom Queries into One Custom Query | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2023-08-09T16:49:51+00:00","dateModified":"2024-06-21T09:15:29+00:00","description":"This tutorial describes how to use Query Builder to show results from more than one query in one JetEngine Listing Grid.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/combining-results-of-multiple-custom-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crocoblock.com\/knowledge-base\/"},{"@type":"ListItem","position":2,"name":"Articles","item":"https:\/\/crocoblock.com\/knowledge-base\/articles\/"},{"@type":"ListItem","position":3,"name":"How to Combine Results of Multiple Custom Queries into One Custom Query"}]},{"@type":"WebSite","@id":"https:\/\/crocoblock.com\/knowledge-base\/#website","url":"https:\/\/crocoblock.com\/knowledge-base\/","name":"Help Center","description":"","publisher":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/crocoblock.com\/knowledge-base\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/crocoblock.com\/knowledge-base\/#organization","name":"Help Center","url":"https:\/\/crocoblock.com\/knowledge-base\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/","url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","contentUrl":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/04\/invert-crocoblock-logo.svg","caption":"Help Center"},"image":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article\/41513"}],"collection":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article"}],"about":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/types\/article"}],"author":[{"embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/users\/8"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=41513"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=41513"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=41513"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}