{"id":47542,"date":"2025-03-28T13:30:19","date_gmt":"2025-03-28T13:30:19","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=47542"},"modified":"2025-12-26T15:57:09","modified_gmt":"2025-12-26T15:57:09","slug":"how-to-combine-custom-field-and-post-properties-in-search-filter","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/","title":{"rendered":"How to Combine Custom Field and Post Properties in Search Filter"},"content":{"rendered":"\n

Build <\/strong>an <\/strong>SQL\/AI <\/strong>Query Type<\/strong><\/h2>\n\n\n\n
\n

Initially, navigate to the WordPress Dashboard > JetEngine > Query Builder<\/a><\/em><\/strong> tab and press the “Add New<\/strong>” button to create a query.<\/p>\n\n\n\n

Next, on the newly appeared Add New Query<\/strong> page, fill out the Name<\/strong> field (we type the “Search Filter” text); after that, select the “SQL\/AI Query<\/a>” Query Type<\/strong>.<\/p>\n\n\n\n

\"building<\/a><\/div>\n\n\n\n

In the next step, scroll the page down, enable the Advanced\/AI mode<\/strong> toggle, and paste the following text into the newly appeared SQL Query<\/strong> text area:<\/p>\n\n\n\n

SELECT p.*\n\nFROM {prefix}posts p\n\nLEFT JOIN {prefix}postmeta pm ON pm.post_id = p.ID AND pm.meta_key = 'property_description'\n\nWHERE (\n\n    p.post_type=\"properties\" AND\n\n    ( \"%jsf_filter_query|query_var|search_for_sql||plain%\" = '' OR\n\n    p.post_title LIKE \"%%jsf_filter_query|query_var|search_for_sql||plain%%\" OR\n\n    pm.meta_value LIKE \"%%jsf_filter_query|query_var|search_for_sql||plain%%\"\n\n    )\n\n);<\/code><\/pre>\n\n\n\n
Since we intend to search in the “Properties” CPT<\/strong> posts, in this code, we type the slug (here, “properties”) of this CPT<\/strong> in the following row:<\/p>\n\n\n\n
p.post_type= \"properties\" AND\" <\/code><\/pre>\n\n\n\n
Also, we search for the needed parameter in the post title or the “Property description” meta field<\/strong> and insert the Name\/ID<\/strong> of this meta field<\/strong> (in this case, the “property_description” text) into the row:<\/p>\n\n\n\n
LEFT JOIN {prefix}postmeta pm ON pm.post_id = p.ID AND pm.meta_key = 'property_description'<\/code><\/pre>\n\n\n\n
Therefore, to use the query correctly, adjust this code according to your needs.<\/p>\n\n\n\n
In the last step, select the “Post” option in the Cast result to instance of object <\/strong>drop-down list.<\/p>\n\n\n\n
In our code, we use the “wp_” text as a prefix instead of the {prefix} text (for example, the “wp_posts” instead of the “{prefix}posts”), because Query Builder<\/strong> dynamically pulls up the prefix of the current site’s database and substitutes.<\/p>\n\n\n\n
\"<\/a><\/div>\n\n\n\n
Once completed, scroll the page up and press the “Add Query \/ Update Query<\/strong>” button.<\/p>\n\n\n\n
Build a Post Type Query<\/strong><\/h2>\n<\/div><\/div>\n\n\n\n
\n
First, create a new query. Next, fill in the query’s Name<\/strong> (here, we type “Search Filter 2” ); then, expand the Query Type drop-down list and select the “Posts Query” option. Next, enter any ID in the Custom Query ID<\/strong> field (we insert “some_id”).<\/p>\n\n\n\n
Second, move to the Posts Query<\/strong> section and the General<\/strong> tab. In the Post Type<\/strong> drop-down list, choose the needed CPT<\/strong> (in this case, it was the “Properties” CPT<\/strong>).<\/p>\n\n\n\n
\"building<\/a><\/div>\n\n\n\n
Third, unfold the Post & Page<\/strong> tab, press the “dynamic tag<\/strong>” icon near the Post In <\/strong>field, and select the “Query Results” macro. Next, choose the previously built query of the \u201cSQL\/AI Query\u201d type (the “Search Filter” query, in this tutorial) in the Query<\/strong> drop-down list in the pop-up. Afterwards, pick the “List of items IDs” option in the Return<\/strong> drop-down list. Finally, click the “Apply<\/strong>” button and save the query.<\/p>\n\n\n\n
\"adding<\/a><\/div>\n<\/div><\/div>\n\n\n\n
Create a Search Filter<\/strong><\/h2>\n\n\n\n
\n
\n
In this stage, proceed to the WordPress Dashboard > Smart Filters > Add New<\/em><\/strong> tab to create a new filter. Next, on the newly appeared Edit Filter<\/strong> page, insert the filter’s Name<\/strong> (we type the “Search filter” text) and select the “Search” option in the Filter Type <\/strong>section.<\/p>\n\n\n\n
Second, select the “By Custom Field (from Query Variable)” option in the Search by <\/strong>drop-down list and click the “dynamic tag<\/strong>” icon in the Query Variable *<\/strong> field. <\/p>\n\n\n\n
Here, choose the “Plane Query Variable” option in the drop-down list and add the “search_for_sql” text in the Variable Name<\/strong> text field. Once added, the text “_plain_query::search_for_sql” will be displayed in the Query Variable * <\/strong>field.<\/p>\n\n\n\n
\"creating<\/a><\/div>\n\n\n\n
Finally, move to the top of the page and press the “Update<\/strong>” button.<\/p>\n\n\n\n
Add the Filter to a Page<\/strong><\/h2>\n\n\n\n
Create a page or open a created one in an editor you prefer. Here, we use Elementor.<\/p>\n\n\n\n
Divide the page’s layout into two columns and add the Listing Grid<\/a> widget to the right one. After that, set the needed Listing<\/strong> in the corresponding drop-down list and customize the listing as needed. For more details on configuring the Listing Grid<\/strong> settings, watch the How to \u0421reate a Listing Grid<\/a> video.<\/p>\n<\/div><\/div>\n\n\n\n
After that, proceed to the Advanced<\/strong> tab, move to the CSS ID<\/strong> text field and add the query\u2019s ID you previously inserted in the Custom Query ID<\/strong> field while you have built the Post Type Query <\/strong>(in our case, we copy the “some_id” text from the “Search Filter 2” query).<\/p>\n\n\n\n
\"adding<\/a><\/div>\n\n\n\n
Once completed, find the Search Filter<\/strong><\/a> widget and drag-n-drop it to the left column. In this step, select the previously created filter in the Select filter<\/strong> drop-down list (the “Search Filter” in this tutorial); next, choose the “JetEngine” option in the This filter for <\/strong>drop-down list. After that, select the “Mixed” Apply type<\/strong>.<\/p>\n\n\n\n
In the last step, proceed to the Query ID<\/strong> field and add the query\u2019s ID you previously inserted in the Custom Query ID<\/strong> field while you have built the Post Type Query <\/strong>(in our case, we copy the “some_id” text from the “Search Filter 2” query).<\/p>\n\n\n\n
\"adding<\/a><\/div>\n\n\n\n
Adjust the Search Filter<\/strong> settings as needed, for example, as explained in the How to Create a Search Filter in WordPress using Elementor Page Builder<\/a> video. <\/p>\n\n\n\n
Finally, publish the page and move to the front end to check if the filter works correctly.<\/p>\n<\/div><\/div>\n\n\n\n
Test the Flow<\/strong><\/h2>\n\n\n\n
\n
On the front end, we insert the “garage” text in the filter and press the “APPLY FILTER<\/strong>” button. Then, the CPT<\/strong> posts with text in the corresponding field and titles were displayed.<\/p>\n\n\n\n
\"the<\/a><\/div>\n<\/div><\/div>\n\n\n\n
That\u2019s it. Now you know how to apply the queries to the Search Filter<\/strong> of the JetSmartFilters<\/em> plugin for WordPress to provide filtering by some parameters.<\/p>\n","protected":false},"excerpt":{"rendered":"
Learn how to apply the queries to the Search Filter to provide filtering by some parameters, e.g., search CPT posts that include the specific text in their titles or the text meta fields.<\/p>\n","protected":false},"author":12,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[535],"yoast_head":"\nHow to Combine Custom Field and Post Properties in Search Filter \u4e00 JetSmartFilters I Crocoblock<\/title>\n<meta name=\"description\" content=\"Learn how to apply the queries to the Search Filter to provide filtering by some parameters, e.g., search CPT posts that include the specific text in their titles or the text meta fields.\" \/>\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\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Combine Custom Field and Post Properties in Search Filter \u4e00 JetSmartFilters I Crocoblock\" \/>\n<meta property=\"og:description\" content=\"Learn how to apply the queries to the Search Filter to provide filtering by some parameters, e.g., search CPT posts that include the specific text in their titles or the text meta fields.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-26T15:57:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/03\/building-a-sql-and-ai-type-query.webp\" \/>\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=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/\",\"name\":\"How to Combine Custom Field and Post Properties in Search Filter \u4e00 JetSmartFilters I Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2025-03-28T13:30:19+00:00\",\"dateModified\":\"2025-12-26T15:57:09+00:00\",\"description\":\"Learn how to apply the queries to the Search Filter to provide filtering by some parameters, e.g., search CPT posts that include the specific text in their titles or the text meta fields.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/#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 Custom Field and Post Properties in Search Filter\"}]},{\"@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 Custom Field and Post Properties in Search Filter \u4e00 JetSmartFilters I Crocoblock","description":"Learn how to apply the queries to the Search Filter to provide filtering by some parameters, e.g., search CPT posts that include the specific text in their titles or the text meta fields.","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\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/","og_locale":"en_US","og_type":"article","og_title":"How to Combine Custom Field and Post Properties in Search Filter \u4e00 JetSmartFilters I Crocoblock","og_description":"Learn how to apply the queries to the Search Filter to provide filtering by some parameters, e.g., search CPT posts that include the specific text in their titles or the text meta fields.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/","og_site_name":"Help Center","article_modified_time":"2025-12-26T15:57:09+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2025\/03\/building-a-sql-and-ai-type-query.webp"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/","name":"How to Combine Custom Field and Post Properties in Search Filter \u4e00 JetSmartFilters I Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2025-03-28T13:30:19+00:00","dateModified":"2025-12-26T15:57:09+00:00","description":"Learn how to apply the queries to the Search Filter to provide filtering by some parameters, e.g., search CPT posts that include the specific text in their titles or the text meta fields.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetsmartfilters\/how-to-combine-custom-field-and-post-properties-in-search-filter\/#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 Custom Field and Post Properties in Search Filter"}]},{"@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\/47542"}],"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\/12"}],"wp:attachment":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/media?parent=47542"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=47542"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=47542"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}