{"id":30210,"date":"2022-11-04T21:16:07","date_gmt":"2022-11-04T21:16:07","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/articles\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/"},"modified":"2023-07-28T13:58:59","modified_gmt":"2023-07-28T13:58:59","slug":"displaying-the-count-of-posts-containing-the-specific-term-in-elementor","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/","title":{"rendered":"How to Display the Count of Posts Containing the Specific Term in Elementor"},"content":{"rendered":"\n

Create a counter of the WordPress posts that contain only the needed terms by using the SQL query built with the JetEngine <\/em>plugin.<\/p>\n\n\n\n

Primarily, let\u2019s check the terms we will use for the query. Now we will go to the WordPress Dashboard > Pages > Categories <\/em><\/strong>directory.<\/p>\n\n\n

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

Mind that you can try to recreate this use case with the custom categories<\/strong><\/a>.<\/p><\/div><\/div>\n\n\n\n

Currently, we will use the \u201cInterviews\u201d and \u201cInterviews 2021\u201d terms. Remember that there are five and two items attached accordingly (in the Count <\/strong>tab), and look at their slugs.<\/p>\n\n\n\n\"wordpress\n\n\n\n

Query for Posts With the Specific Value in the Term<\/h2>\n\n\n\n
\n

Head to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong>. Click on the \u201cAdd New<\/strong>\u201d button to create a new query.<\/p>\n\n\n\n\"add\n\n\n\n

Complete the Name <\/strong>field and select the \u201cSQL Query\u201d option as Query Type<\/strong> in the General Settings tab.<\/p>\n\n\n\n\"general\n\n\n\n

Scroll down to the Custom SQL Query<\/strong> tab. Choose \u201cterms\u201d in the From table <\/strong>field and activate the Use Join <\/strong>switcher.<\/p>\n\n\n\n

Press the \u201cAdd New<\/strong>\u201d button to open the settings.<\/p>\n\n\n\n\"from\n\n\n\n

Set the \u201cInner Join\u201d Join Type <\/strong>or leave the field empty, as the needed type will be set automatically. The Join Table <\/strong>represents the database table that will be connected, so pick the \u201cterm_taxonomy\u201d option.<\/p>\n\n\n\n

In the When current table column <\/strong>and Is equal to base table column <\/strong>fields, <\/strong>choose the \u201cterm_id\u201d options.<\/p>\n\n\n\n\"join\n\n\n\n

Move to the following Where (query clauses) <\/strong>tab and press the \u201cAdd New<\/strong>\u201d button.<\/p>\n\n\n\n

Select \u201cterms.name\u201d as the Column<\/strong>, \u201cLike\u201d as Compare <\/strong>operator, and complete the Value <\/strong>field with the term slug. The value should represent the term for which you want to show the count on the front end.<\/p>\n\n\n\n

As \u201cinterviews-2021\u201d also contain the \u201cinterviews\u201d value, it will also be counted. Continue reading to know the exact way to count all their posts or see how to include only \u201cinterviews\u201d in the second part of the article.<\/p>\n\n\n\n\"where\n\n\n\n

Now scroll down to the Include columns <\/strong>field and complete it with the \u201cterm_taxonomy.count\u201d value.<\/p>\n\n\n\n

Finally, you can press the \u201cAdd Query<\/strong>\u201d button to finish the initial setup.<\/p>\n\n\n\n\"include\n\n\n\n

Proceed to WordPress Dashboard > Pages <\/em><\/strong>and open the page. You can do it by pressing the \u201cAdd New<\/strong>\u201d button or editing the existing page.<\/p>\n\n\n\n\"wordpress\n\n\n\n

Firstly, give a title to the page and click the \u201cEdit with Elementor<\/strong>\u201d button to proceed to the Elementor Editor.<\/p>\n\n\n\n\"terms\n\n\n\n

Once the page is opened in the Elementor Page Builder, find the Counter <\/strong>widget in the search bar.<\/p>\n\n\n\n\"counter\n\n\n\n

The primary setting we need is the Ending Number<\/strong>. Press the \u201cDynamic Tags<\/strong>\u201d button and find the \u201cDynamic Function\u201d item.<\/p>\n\n\n\n\"ending\n\n\n\n

Make sure you have set up the available settings. Choose the \u201cSQL query result\u201d Function <\/strong>and find the \u201cterm_taxonomy.count\u201d in the Query Column <\/strong>drop-down list.<\/p>\n\n\n\n

You can now see that the number on the counter has changed to \u201c5\u201d. This amount of posts we have attached to the \u201cinterviews\u201d category.<\/p>\n\n\n\n\"term\n\n\n\n

If you move to the Additional Function <\/strong>and select the \u201cSum\u201d option, you will see that the counter number has been changed to \u201c7\u201d.<\/p>\n\n\n\n

So now the counter also includes the \u201cinterviews-2021\u201d posts.<\/p>\n\n\n\n\"additional\n\n\n\n

Also, mind changing the Title <\/strong>to the one appropriate for the case.<\/p>\n\n\n\n\"title\n\n\n\n

Once you add all the needed widgets and style up the page, hit the \u201cPublish\/Update<\/strong>\u201d button to save the result.<\/p>\n\n\n\n\"two\n<\/div><\/div>\n\n\n\n

Counter of One Particular Term<\/h2>\n\n\n\n
\n

Additionally, you can follow the next steps to get results only for one specific term.<\/p>\n\n\n\n

Return to Query Builder <\/strong>and find the query you have built before. <\/p>\n\n\n\n

Open it and scroll down to the Join Tables <\/strong>tab. Here you can delete the set clause and create a similar one, but this time complete the Compare <\/strong>field with the \u201cEqual (=)\u201d value.<\/p>\n\n\n\n

Now press the \u201cAdd\/Update Query<\/strong>\u201d button and head to the front end to check the result.<\/p>\n\n\n\n

So note that there is no need to set the Additional Function <\/strong>in the Counter <\/strong>widget\u2019s Ending Number <\/strong>field.<\/p>\n\n\n\n\"where\n\n\n\n

This time, there is only a count of the posts related precisely to the \u201cinterviews\u201d term shown.<\/p>\n\n\n\n\"counter\n<\/div><\/div>\n\n\n\n

That\u2019s it; you have learned how to display the count of the posts containing particular needed WordPress terms using JetEngine\u2019s <\/em>Query Builder <\/strong>functionality.<\/p>\n","protected":false},"excerpt":{"rendered":"

Discover how to show the count of posts containing the specific WordPress term using SQL query built with JetEngine\u2019s Query Builder.<\/p>\n","protected":false},"author":1,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[405],"yoast_head":"\nHow to Display Count of Posts Containing the Specific Term in Elementor \u2014 JetEngine | Crocoblock<\/title>\n<meta name=\"description\" content=\"Find out how to display the count of posts that contain specific terms on your WordPress website with the help of JetEngine Query Builder and Elementor Page Builder.\" \/>\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\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Display Count of Posts Containing the Specific Term in Elementor \u2014 JetEngine | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"Find out how to display the count of posts that contain specific terms on your WordPress website with the help of JetEngine Query Builder and Elementor Page Builder.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-28T13:58:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/02\/wordpress-posts-categories-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\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/\",\"name\":\"How to Display Count of Posts Containing the Specific Term in Elementor \u2014 JetEngine | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2022-11-04T21:16:07+00:00\",\"dateModified\":\"2023-07-28T13:58:59+00:00\",\"description\":\"Find out how to display the count of posts that contain specific terms on your WordPress website with the help of JetEngine Query Builder and Elementor Page Builder.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/#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 Display the Count of Posts Containing the Specific Term in Elementor\"}]},{\"@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 Display Count of Posts Containing the Specific Term in Elementor \u2014 JetEngine | Crocoblock","description":"Find out how to display the count of posts that contain specific terms on your WordPress website with the help of JetEngine Query Builder and Elementor Page Builder.","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\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/","og_locale":"en_US","og_type":"article","og_title":"How to Display Count of Posts Containing the Specific Term in Elementor \u2014 JetEngine | Crocoblock","og_description":"Find out how to display the count of posts that contain specific terms on your WordPress website with the help of JetEngine Query Builder and Elementor Page Builder.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/","og_site_name":"Help Center","article_modified_time":"2023-07-28T13:58:59+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/02\/wordpress-posts-categories-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\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/","name":"How to Display Count of Posts Containing the Specific Term in Elementor \u2014 JetEngine | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2022-11-04T21:16:07+00:00","dateModified":"2023-07-28T13:58:59+00:00","description":"Find out how to display the count of posts that contain specific terms on your WordPress website with the help of JetEngine Query Builder and Elementor Page Builder.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetengine\/displaying-the-count-of-posts-containing-the-specific-term-in-elementor\/#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 Display the Count of Posts Containing the Specific Term in Elementor"}]},{"@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\/30210"}],"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=30210"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=30210"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=30210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}