{"id":41339,"date":"2023-08-02T09:00:05","date_gmt":"2023-08-02T09:00:05","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=41339"},"modified":"2023-12-11T16:48:49","modified_gmt":"2023-12-11T16:48:49","slug":"how-to-filter-by-relation-meta","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/","title":{"rendered":"How to Filter by Relation Meta"},"content":{"rendered":"\n

Create SQL Query in Query Builder<\/h2>\n\n\n\n
\n

Begin with creating a custom query in the JetEngine <\/em>Query Builder. Go to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong> and press \u201cAdd New<\/strong>.\u201d <\/p>\n\n\n\n

Give a Name <\/strong>to the query, a Description <\/strong>if desired, and set Query Type <\/strong>to \u201cSQL\/AI Query.\u201d<\/p>\n\n\n\n\"sql\n\n\n\n

In the Custom SQL Query <\/strong>section, add a \u201cjet_rel_default_meta\u201d From table<\/strong> as the source of pulling the values from the relation meta fields.<\/p>\n\n\n\n\"relation\n\n\n\n

Remember that the \u201cjet_rel_default_meta\u201d table should be selected if you keep Register separate DB table<\/strong> in the Relation <\/strong>settings disabled.<\/p>\n\n\n\n\"register\n\n\n\n

If you have this toggle in the enabled state, a separate table is created in the database, which has a different name like \u201cjet_rel_81_meta\u201d, where \u201c81\u201d is substituted with the Relation <\/strong>ID from your website. <\/p>\n\n\n\n

So, in this case, a respective table should be selected in the From Table<\/strong> field.<\/p>\n\n\n\n\"relation\n\n\n\n

Next, add the Where (query clause)<\/strong>, <\/strong>which specifies the meta field of the relation by which the filtering is to be performed. Select \u201cmeta_key\u201d as a Column, which is \u201cEqual\u201d (Compare <\/strong>field) to your relation meta field name mentioned in the Value <\/strong>field.<\/p>\n\n\n\n\"relation\n\n\n\n

The following clause is needed if the option Register separate DB table<\/strong> is disabled. <\/p>\n\n\n\n

In this case, the \u201crel_id\u201d value should be set as a Column<\/strong>, \u201cEqual\u201d as Compare <\/strong>operator, and the ID of the relation needs to be specified in the clause as the Value<\/strong>. As was shown earlier, you can find the ID of the relation in the URL on the Relation <\/strong>editing page.<\/p>\n\n\n\n

Also, mind changing the Type <\/strong>option to \u201cNumeric.\u201d<\/p>\n\n\n\n\"relation\n\n\n\n

In the query results preview, you can see the \u201cmeta_value\u201d column stores the value from the Relation <\/strong>meta field based on which the filter will be built.<\/p>\n\n\n\n\"meta\n\n\n\n

As the query is completed, you can save it.<\/p>\n<\/div><\/div>\n\n\n\n

Make Filter in JetSmartFilters<\/h2>\n\n\n\n
\n

Now proceed with creating a filter using the JetSmartFilters <\/em>plugin. <\/p>\n\n\n\n

Go to WordPress Dashboard > Smart Filters > Add New<\/em><\/strong> and select a needed type of filter. In the described case, we chose a \u201cRadio\u201d Filter Type<\/strong>.<\/p>\n\n\n\n\"radio\n\n\n\n

Next, pick a \u201cJetEngine Query Builder\u201d Data Source<\/strong>, and select a custom query from the previous step.<\/p>\n\n\n\n

The Property to get Value from<\/strong> and Property to get Label from<\/strong> should be completed with \u201cmeta_value\u201d.<\/p>\n\n\n\n\"jetengine\n\n\n\n

The last setting in the filter setup is the Query Variable<\/strong>, by which the filtering is performed. It should be “meta_value” as well.<\/p>\n\n\n\n\"meta\n\n\n\n

The filter setup is completed; it can be saved now.<\/p>\n<\/div><\/div>\n\n\n\n

Create SQL Query in Query Builder<\/h2>\n\n\n\n
\n

At this stage, we need to create another custom query that will be the source of the Listing template<\/strong> used in the Listing Grid<\/a> widget to show the filtered results.<\/p>\n\n\n\n

Go to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong>, and add a new custom query of \u201cSQL\/AI Query\u201d Query Type<\/strong>.<\/p>\n\n\n\n\"sql\n\n\n\n

Choose a table where an item from the relation is stored which is to be filtered. <\/p>\n\n\n\n

In the described case, it is the CCT. Therefore, a CCT table is selected accordingly. If you want to filter a post type used in the relation, pick a \u201cposts\u201d table.<\/p>\n\n\n\n

After it, enable the Use Join<\/strong> toggle.<\/p>\n\n\n\n\"use\n\n\n\n

After turning on the toggle, pick \u201cInner Join\u201d as a Join Type<\/strong>, and join the “jet_rel_default_meta” table.<\/p>\n\n\n

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

Remember that you may need to select a custom table for a relation if you enable Register separate DB<\/strong> table in the settings upon creating a relation.<\/p><\/div><\/div>\n\n\n\n

When current table column<\/strong> field should be completed with an option corresponding to the item in the relation that will be filtered. <\/p>\n\n\n\n

In the provided case, a CCT<\/strong> that is a parent item in the relation will be filtered, which is why the \u201cparent_object_id” is chosen.<\/p>\n\n\n\n

Is equal to other table column<\/strong> should be set to CCT\u2019s<\/strong> \u201c_ID\u201d or \u201cID\u201d in case a \u201cposts\u201d table was added previously.<\/p>\n\n\n\n\"relation\n\n\n\n

Next, add an item in the Where (query clauses) <\/strong>section, and specify a \u201cjet_rel_default_meta.meta_key\u201d Column <\/strong>to be \u201cEqual\u201d (Compare <\/strong>field) to the Relation <\/strong>meta field name (Value <\/strong>field.) With this clause, the posts will be pulled which have a value in the meta field of the relation.<\/p>\n\n\n\n\"value\n\n\n\n

If you use a post type instead of a CCT in the relation which is to be filtered, you may also need to specify a post type in the query. You should select \u201cposts.post_type\u201d to be \u201cEqual\u201d to a desired post type slug.<\/p>\n\n\n\n\"post\n\n\n\n

The custom query is done at this point, so it can be saved.<\/p>\n<\/div><\/div>\n\n\n\n

Build Listing Template for Custom Query<\/h2>\n\n\n\n
\n

Go to WordPress Dashboard > JetEngine > Listings<\/em><\/strong>, and click the \u201cAdd New<\/strong>\u201d button. <\/p>\n\n\n\n

The Listing source<\/strong> should be set to \u201cQuery Builder\u201d and the query created in a previous step should be picked in the Query <\/strong>field.<\/p>\n\n\n\n

Complete the Listing item name <\/strong>and pick the Listing view<\/strong>. Press the \u201cCreate Listing Item<\/strong>\u201d button.<\/p>\n\n\n\n\"sql\n\n\n\n

In the Listing template<\/strong>, you can add a Dynamic Field<\/strong><\/a> widget to pull data from the custom query.<\/p>\n\n\n

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

Note that you need to select fields under the Query<\/strong> section to output data in the Listing template<\/strong> for a custom query.<\/p><\/div><\/div>\n\n\n\n\"work\n\n\n\n

You can use a \u201cmeta_value\u201d Custom Object field\/ Meta field \/ Repeater key <\/strong>to show a value from a Relation <\/strong>meta field.<\/p>\n\n\n\n\"relation\n\n\n\n

Once you added all other needed fields, the Listing template<\/strong> can be saved.<\/p>\n<\/div><\/div>\n\n\n\n

Check Filtering on the Front End<\/h2>\n\n\n\n
\n

Add the filter and Listing Grid<\/strong> widget to a page to check the result.<\/p>\n\n\n\n\"relation\n\n\n\n

In the Listing Grid <\/strong>widget, select a Listing <\/strong>template that was built in a previous step.<\/p>\n\n\n\n\"listing\n\n\n\n

The setup is done; check the filtering on the front end.<\/p>\n\n\n\n

When an option is picked in the filter, a respective item with the filtered value in the Relation <\/strong>meta field is displayed in the Listing Grid<\/strong> accordingly.<\/p>\n\n\n\n\"listing\n<\/div><\/div>\n\n\n\n

Now you know how to build SQL queries and a filter to create filtering by a relation meta field on your website using the JetEngine <\/em>and JetSmartFilters <\/em>plugins.<\/p>\n","protected":false},"excerpt":{"rendered":"

This tutorial explains creating a custom SQL query for JetEngine Relation to filter posts by a Relation meta field.<\/p>\n","protected":false},"author":9,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[421,399],"yoast_head":"\nHow to Filter by Relation Meta \u2014 JetEngine | Crocoblock<\/title>\n<meta name=\"description\" content=\"From this guide, you will discover how to build an SQL query for JetEngine relation and filter posts by this relation\u2019s meta field on your WordPress website.\" \/>\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-filter-by-relation-meta\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Filter by Relation Meta \u2014 JetEngine | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"From this guide, you will discover how to build an SQL query for JetEngine relation and filter posts by this relation\u2019s meta field on your WordPress website.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-11T16:48:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/08\/Screenshot_77.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=\"9 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-filter-by-relation-meta\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/\",\"name\":\"How to Filter by Relation Meta \u2014 JetEngine | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2023-08-02T09:00:05+00:00\",\"dateModified\":\"2023-12-11T16:48:49+00:00\",\"description\":\"From this guide, you will discover how to build an SQL query for JetEngine relation and filter posts by this relation\u2019s meta field on your WordPress website.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/#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 Filter by Relation Meta\"}]},{\"@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 Filter by Relation Meta \u2014 JetEngine | Crocoblock","description":"From this guide, you will discover how to build an SQL query for JetEngine relation and filter posts by this relation\u2019s meta field on your WordPress website.","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-filter-by-relation-meta\/","og_locale":"en_US","og_type":"article","og_title":"How to Filter by Relation Meta \u2014 JetEngine | Crocoblock","og_description":"From this guide, you will discover how to build an SQL query for JetEngine relation and filter posts by this relation\u2019s meta field on your WordPress website.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/","og_site_name":"Help Center","article_modified_time":"2023-12-11T16:48:49+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/08\/Screenshot_77.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"9 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/","name":"How to Filter by Relation Meta \u2014 JetEngine | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2023-08-02T09:00:05+00:00","dateModified":"2023-12-11T16:48:49+00:00","description":"From this guide, you will discover how to build an SQL query for JetEngine relation and filter posts by this relation\u2019s meta field on your WordPress website.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/how-to-filter-by-relation-meta\/#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 Filter by Relation Meta"}]},{"@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\/41339"}],"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\/9"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=41339"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=41339"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=41339"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}