{"id":30180,"date":"2022-11-04T21:16:04","date_gmt":"2022-11-04T21:16:04","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/articles\/how-to-set-up-order-offset-query-by-two-meta-fields\/"},"modified":"2024-05-13T07:22:26","modified_gmt":"2024-05-13T07:22:26","slug":"how-to-set-up-order-offset-query-by-two-meta-fields","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/","title":{"rendered":"How to Order Posts by Custom Meta Fields"},"content":{"rendered":"\n

In this tutorial, we will learn how to set the query depending on the two JetEngine <\/em>meta fields data entered in the posts. We will achieve posts queried depending on the numeric data of the team member\u2019s experience and text value \u2014 the team member\u2019s name. <\/p>\n\n\n\n

The number value will have priority over the text one. However, the text field parameter will work if the team member\u2019s years of experience are the same as the other\u2019s team member.<\/p>\n\n\n\n

Add New Query<\/h2>\n\n\n\n
\n

Begin by proceeding to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong>. Press the \u201cAdd New<\/strong>\u201d button to create a new query.<\/p>\n\n\n\n\"queries\n\n\n\n

In the General Settings<\/strong> tab, give a Name <\/strong>to the query and select the \u201cPosts Query\u201d option as Query Type<\/strong>.<\/p>\n\n\n\n\"new\n\n\n\n

In the proceeding Meta Query <\/strong>tab, click the \u201cAdd new<\/strong>\u201d button to adjust a new meta clause.<\/p>\n\n\n\n\"add\n\n\n\n

Let\u2019s look at the values you should put in the fields.<\/p>\n\n\n\n

In the Field key\/name <\/strong>field, complete the meta field key, you created earlier for the post type items. For instance, we complete this field with the \u201cname\u201d value which is the meta field of the \u201cTeam\u201d post type. That means we will query the listing depending on the team member\u2019s name.<\/p>\n\n\n\n

Select the \u201cExists\u201d option as the Compare <\/strong>operator. It displays all posts that contain the Field key\/name<\/strong>, so we don\u2019t need to put the following Value<\/strong>; we\u2019ll leave the field empty.<\/p>\n\n\n\n

As the member\u2019s name contains only characters, we pick the \u201cChar\u201d Type<\/strong>, <\/strong>and don\u2019t forget to type in the Clause name <\/strong>that will be used later in the Order by <\/strong>section.<\/p>\n\n\n\n\"meta\n\n\n\n

Then let\u2019s adjust one more clause by pushing the \u201cAdd new<\/strong>\u201d button again. This one will include years of experience.<\/p>\n\n\n\n

Mind that now we select the \u201cNumeric\u201d Type<\/strong>, <\/strong>as the \u201cexperience\u201d meta field is set to be the \u201cNumber\u201d Field<\/strong>.<\/p>\n\n\n\n\"meta\n\n\n\n

You can add more clauses if needed. Now we move on to the General <\/strong>tab and select the required Post Type<\/strong>.<\/p>\n\n\n\n

Then proceed to Order & Order By <\/strong>section. Hit the \u201cAdd new sorting parameter<\/strong>\u201d button.<\/p>\n\n\n\n\"general\n\n\n\n

Once clicked, you will see fields for further customizations. Choose the \u201cOrder by meta clause\u201d Order By <\/strong>parameter and define the needed Meta Clause<\/strong> \u2014 right here, we need to select one of the clause names you came up with earlier. We begin with the \u201cteam member experience\u201d one to make it a bigger priority.<\/p>\n\n\n

<\/svg><\/div>
Warning<\/div>

Mind that the first clause created will have more priority, then comes the second, the third, etc.<\/p><\/div><\/div>\n\n\n\n

Then we pick whether we went the order to be descending or ascending. In the exact case, we will query by descending years of experience (\u201cFrom highest to lowest\u201d).<\/p>\n\n\n\n

Click the \u201cAdd new sorting parameter<\/strong>\u201d button to create one more order by team member name.<\/p>\n\n\n\n\"order\n\n\n\n

We repeat the same steps with the \u201cteam members name\u201d clause; however, this time, selecting \u201cFrom lowest to highest\u201d Order<\/strong>.<\/p>\n\n\n\n

That\u2019s it for the query customization; press the \u201cAdd Query<\/strong>\u201d button.<\/p>\n\n\n\n\"order\n<\/div><\/div>\n\n\n\n

Set Order for Listing<\/h2>\n\n\n\n
\n

Head to the page where you want to place the Listing Grid<\/strong>. It can be any page you need; now, we will proceed to WordPress Dashboard > Pages <\/em><\/strong>and edit the existing one.<\/p>\n\n\n\n

Place listing In Elementor<\/h3>\n\n\n\n

Place the Listing Grid <\/strong>widget on the page. Select the needed Listing <\/strong>you have created beforehand. Sett all the parameters in the General <\/strong>tab to get the desired result.<\/p>\n\n\n\n\"team\n\n\n

<\/svg><\/div>
Warning<\/div>

As you can see, the \u201cExperience\u201d Meta Field<\/strong> is displayed not only with a number but also with a \u201cyears\u201d value. It refers to the Customize field output<\/strong> setting available during Listing<\/strong> editing. You can configure an additional custom output here if needed.<\/p><\/div><\/div>\n\n\n\n\"customize\n\n\n\n

The next step is to go to the Custom Query <\/strong>tab. Here enable the Use Custom Query<\/strong> toggle and specify the Custom Query <\/strong>by selecting the one you have just created.<\/p>\n\n\n\n

As you can see, all team members are now located depending on their experience. And, not less important, if several members have the same \u201cExperience\u201d values, they are placed depending on their names (ascending character order).<\/p>\n\n\n

<\/svg><\/div>
Warning<\/div>

Also, mind that the following tabs (Posts Query<\/strong>, Terms Query<\/strong>, Users Query<\/strong>, Content Types Query<\/strong>) concerning query settings are legacy. We recommend using the Query Builder<\/a> functionality and Custom Query<\/strong> functionality and Custom Query<\/strong> tab, respectively.<\/p><\/div><\/div>\n\n\n\n\"team\n\n\n\n

Adjust listing In Gutenberg<\/h3>\n\n\n\n

You can repeat the same steps if you work with the Block Editor. Proceed to the page you want to edit and add the Listing Grid <\/strong>block. <\/p>\n\n\n\n

Pick the needed Listing <\/strong>and adjust the following General <\/strong>settings fields.<\/p>\n\n\n\n\"team\n\n\n\n

Moving to the Custom Query <\/strong>tab, activate the Use Custom Query <\/strong>toggle and pick the needed item in the Custom Query <\/strong>filter to achieve the result.<\/p>\n\n\n\n\"team\n<\/div><\/div>\n\n\n\n

Other Meta Clause Order<\/h2>\n\n\n\n
\n

Let\u2019s check what will happen if the meta clause order is changed. Now we will use the \u201cname\u201d, \u201cexperience\u201d, and \u201crating\u201d meta fields to see the difference.<\/p>\n\n\n\n

The result you observe in the following picture is two options you can set.<\/p>\n\n\n\n

The first table is set to be filtered initially by ascending \u201cexperience\u201d and the second one by descending \u201crating\u201d; now, look at the result.<\/p>\n\n\n

<\/svg><\/div>
Warning<\/div>

To achieve the desired view, make sure you set the right order of the fields (i.e. from the first table Meta Clause #1 \u2014 is \"Experience\" field, then follows Meta Clause #2 \u2014 \"Rating\" field in the Query Builder settings) in the Order & Order<\/strong> By section.<\/p><\/div><\/div>\n\n\n\n\"order\n<\/div><\/div>\n\n\n\n

Now everything is set up. Mind altering some values to get the exact result you need with the Query Builder <\/strong>functionality from the JetEngine <\/em>plugin.<\/p>\n","protected":false},"excerpt":{"rendered":"

Find out how to query items with Query Builder depending on two meta fields created with the JetEngine plugin.<\/p>\n","protected":false},"author":1,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[405],"yoast_head":"\nHow to Order Posts by Custom Meta Fields \u2014 JetEngine | Crocoblock<\/title>\n<meta name=\"description\" content=\"Discover how to set up order and offset query by two meta fields with Query Builder functionality available in the JetEngine WordPress plugin.\" \/>\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\/how-to-set-up-order-offset-query-by-two-meta-fields\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Order Posts by Custom Meta Fields \u2014 JetEngine | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"Discover how to set up order and offset query by two meta fields with Query Builder functionality available in the JetEngine WordPress plugin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-13T07:22:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/02\/queries-list-full.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=\"7 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\/how-to-set-up-order-offset-query-by-two-meta-fields\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/\",\"name\":\"How to Order Posts by Custom Meta Fields \u2014 JetEngine | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2022-11-04T21:16:04+00:00\",\"dateModified\":\"2024-05-13T07:22:26+00:00\",\"description\":\"Discover how to set up order and offset query by two meta fields with Query Builder functionality available in the JetEngine WordPress plugin.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/#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 Order Posts by Custom Meta Fields\"}]},{\"@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 Order Posts by Custom Meta Fields \u2014 JetEngine | Crocoblock","description":"Discover how to set up order and offset query by two meta fields with Query Builder functionality available in the JetEngine WordPress plugin.","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\/how-to-set-up-order-offset-query-by-two-meta-fields\/","og_locale":"en_US","og_type":"article","og_title":"How to Order Posts by Custom Meta Fields \u2014 JetEngine | Crocoblock","og_description":"Discover how to set up order and offset query by two meta fields with Query Builder functionality available in the JetEngine WordPress plugin.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/","og_site_name":"Help Center","article_modified_time":"2024-05-13T07:22:26+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/02\/queries-list-full.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/","name":"How to Order Posts by Custom Meta Fields \u2014 JetEngine | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2022-11-04T21:16:04+00:00","dateModified":"2024-05-13T07:22:26+00:00","description":"Discover how to set up order and offset query by two meta fields with Query Builder functionality available in the JetEngine WordPress plugin.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-set-up-order-offset-query-by-two-meta-fields\/#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 Order Posts by Custom Meta Fields"}]},{"@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\/30180"}],"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\/1"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=30180"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=30180"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=30180"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}