{"id":30128,"date":"2022-11-04T10:14:15","date_gmt":"2022-11-04T10:14:15","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/"},"modified":"2024-05-23T09:10:28","modified_gmt":"2024-05-23T09:10:28","slug":"displaying-only-users-with-posts-in-a-listing","status":"publish","type":"tips-and-tricks","link":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/","title":{"rendered":"Displaying Only Users with Posts in a Listing"},"content":{"rendered":"\n

Create a SQL Query<\/strong><\/h2>\n\n\n\n
\n

Navigate to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong> and press the “Add New<\/strong>” button.<\/p>\n\n\n\n

Type the query Name<\/strong> (“users with posts (pages)” for this tutorial) and choose the “SQL\/AI Query” option from the Query Type<\/strong> drop-down list.
Proceed to the Custom SQL Query <\/strong>section and enable the Advanced\/AI mode<\/strong> toggle.<\/p>\n\n\n\n

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

Enter the following query into the SQL Query<\/strong> field:<\/p>\n\n\n\n

SELECT *\nFROM (\n   SELECT\n   {prefix}users.ID,\n   display_name,\n   user_login,\n   user_nicename,\n   COUNT( {prefix}posts.ID ) AS n,\n   SUBSTRING_INDEX(display_name,' ',-1 ) AS lastname\n\n   FROM {prefix}users\n   JOIN {prefix}posts\n     ON {prefix}posts.post_author = {prefix}users.ID\n   WHERE {prefix}posts.post_type IN ( 'page', 'post' )\n   GROUP BY {prefix}posts.post_author\n   ORDER BY n DESC\n   LIMIT 10 ) AS SortedByCount\nORDER BY lastname<\/code><\/pre>\n\n\n\n
 If needed, enable the Preview Results<\/strong> toggle on the top of the Add New Query<\/strong> tab to check the query results.<\/p>\n\n\n\n
\"the<\/a><\/div>\n\n\n
<\/svg><\/div>
Things to know<\/div>
This query displays users who created the default WordPress posts and pages and sorts the users in the DESC order according to the number of posts and pages they have created. If you need to display the  CPT<\/strong> post\u2032s authors, add the CPT<\/strong> post\u2032s slug to the WHERE {prefix}posts.post_type IN <\/i> line. Partially, if you would like to add the \u201cProperty\u201c CPT<\/strong> with the \u201cproperty\u201c slug, this command will look as follows: WHERE {prefix}posts.post_type IN ( \u2032page\u2032, \u2032post\u2032, \u2032property\u2032 ) <\/i>.<\/p><\/div><\/div>\n\n\n\n
Press the “Add Query<\/strong>” button to save the query or the “Update Query<\/strong>” button to update it.<\/p>\n<\/div><\/div>\n\n\n\n
Create a Users Query<\/strong><\/h2>\n\n\n\n
\n
Navigate to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong> and press the “Add New<\/strong>” button.<\/p>\n\n\n\n
Type the query Name <\/strong>(“users with posts (pages) 2” in this case), and choose the “Users Query” Query Type<\/strong>.<\/p>\n\n\n\n
If selected, the “Users Query” option activates the User Query<\/strong> section of the Query Builde<\/strong>r<\/strong> tab.<\/p>\n\n\n\n
Open the Include\/Exclude<\/strong> tab and hit the macros trigger (“coin stack<\/strong>” button) next to the Include<\/strong> field. Select the “Query Results” macro from the drop-down list.<\/p>\n\n\n\n
Then, choose the previously built query (the “users with posts (pages)” query for this tutorial) in the Query<\/strong> drop-down list, the “List of selected fields from item object” option in the Return<\/strong> drop-down list, and the “ID” option from the Comma separated fields list<\/strong> field.<\/p>\n\n\n\n
\"adding<\/a><\/div>\n\n\n\n
Finally, click the “Apply<\/strong>” and “Add\/Update Query<\/strong>” buttons.<\/p>\n<\/div><\/div>\n\n\n\n
Create Users Listing Template<\/strong><\/h2>\n\n\n\n
\n
Go to WordPress Dashboard > JetEngine > Listings<\/em><\/strong> and hit the “Add New<\/strong>” button.<\/p>\n\n\n\n
In the Setup Listing Item<\/strong> pop-up, select the “Users” Listing <\/strong>s<\/strong>ource<\/strong>, type the listing\u2019s name in the Listing item<\/strong> name<\/strong> field (in this tutorial, the \u201cListing_for_Users\u201d listing), and choose the editor in the Listing view<\/strong> drop-down list. <\/p>\n\n\n\n
In this case, we display users in Elementor, but the appropriate blocks and elements are available in Block Editor and the Bricks theme as well.<\/p>\n\n\n\n
\"setup<\/a><\/div>\n\n\n\n
The tutorial How to Create a Listing Template for Users<\/a> details the main features of creating listings for users.<\/p>\n\n\n\n
Find and drop the Dynamic Field<\/strong><\/a> widget to show the users’ data. Here, we selected the “Post\/Term\/User\/Object Data” from the Source<\/strong> drop-down list. Then, we chose the needed option from the Object<\/strong> Field<\/strong> drop-down list (we picked the “Display Names,” “ID,” “E-mail,” and “Registration Date” options to display the appropriate user\u2019s data).<\/p>\n\n\n\n
\"adding<\/a><\/div>\n\n\n\n
Additionally, you can apply other widgets to display data associated with users.<\/p>\n\n\n\n
In this case, we added the Dynamic Field<\/strong> and Dynamic Image<\/strong><\/a> widgets to show the user\u2019s data from the meta fields of the meta boxes added to the users. <\/p>\n\n\n\n
\"adding<\/a><\/div>\n\n\n\n
Learn more about Applying Meta Boxes to User Profiles<\/a> from the tutorial.<\/p>\n\n\n\n
When you finish customizing the listing item, push the “Update<\/strong>” button.<\/p>\n<\/div><\/div>\n\n\n\n
Add the Listing to a Page<\/strong><\/h2>\n\n\n\n
\n
Move on to the page where you want to display users with posts. In this tutorial, we display users with posts in Elementor.<\/p>\n\n\n\n
Drag and drop the Listing Grid<\/strong><\/a> widget and select the needed listing (in this case, the created previously “Listing_for_Users” listing item) from the Listing<\/strong> drop-down list of the General<\/strong> tab.<\/p>\n\n\n\n
Read the tutorial Listing Grid Widget Overview<\/a> to know how to manage the Listing Grid<\/strong> widget\u2019s settings.<\/p>\n\n\n\n
\"add<\/a><\/div>\n\n\n\n
Then, unroll the Custom Query<\/strong> tab and enable the Use Custom Query<\/strong> toggle. <\/p>\n\n\n\n
In the Custom Query<\/strong> field, select the needed option (“users with posts (pages) 2” in this case).<\/p>\n\n\n\n
\"adding<\/a><\/div>\n\n\n\n
Once completed, press the “Publish\/Update<\/strong>” button.<\/p>\n<\/div><\/div>\n\n\n\n
Check Results<\/strong><\/h2>\n\n\n\n
\n
Navigate to the front end to check if the query works correctly.<\/p>\n\n\n\n
\"user<\/a><\/div>\n<\/div><\/div>\n\n\n\n
That’s all. Now you know how to add listings with the active users who published posts on your WordPress website and display users’ metadata via the Listing Grid<\/strong> widget\/block\/element of the JetEngine <\/em>WordPress plugin. <\/p>\n","protected":false},"excerpt":{"rendered":"
Learn how to add listings with the active users who published posts on your WordPress website and display users’ metadata with the Listing Grid widget\/block\/element of the JetEngine WordPress plugin.<\/p>\n","protected":false},"author":1,"featured_media":0,"template":"","format":"standard","tipstricks-tags":[359],"yoast_head":"\nDisplaying Only Users with Posts in Listing Grid \u2014 JetEngine | Crocoblock<\/title>\n<meta name=\"description\" content=\"Learn how to add listings with the active users who published osts on your WordPress website and display users' metadata with the Listing Grid widget\/block\/element of 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\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Displaying Only Users with Posts in Listing Grid \u2014 JetEngine | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"Learn how to add listings with the active users who published osts on your WordPress website and display users' metadata with the Listing Grid widget\/block\/element of the JetEngine WordPress plugin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-23T09:10:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2024\/05\/add-a-SQL-and-AI-query-1024x640.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\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/\",\"name\":\"Displaying Only Users with Posts in Listing Grid \u2014 JetEngine | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2022-11-04T10:14:15+00:00\",\"dateModified\":\"2024-05-23T09:10:28+00:00\",\"description\":\"Learn how to add listings with the active users who published osts on your WordPress website and display users' metadata with the Listing Grid widget\/block\/element of the JetEngine WordPress plugin.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tips & tricks\",\"item\":\"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Displaying Only Users with Posts in a Listing\"}]},{\"@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":"Displaying Only Users with Posts in Listing Grid \u2014 JetEngine | Crocoblock","description":"Learn how to add listings with the active users who published osts on your WordPress website and display users' metadata with the Listing Grid widget\/block\/element of 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\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/","og_locale":"en_US","og_type":"article","og_title":"Displaying Only Users with Posts in Listing Grid \u2014 JetEngine | Crocoblock","og_description":"Learn how to add listings with the active users who published osts on your WordPress website and display users' metadata with the Listing Grid widget\/block\/element of the JetEngine WordPress plugin.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/","og_site_name":"Help Center","article_modified_time":"2024-05-23T09:10:28+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2024\/05\/add-a-SQL-and-AI-query-1024x640.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\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/","url":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/","name":"Displaying Only Users with Posts in Listing Grid \u2014 JetEngine | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2022-11-04T10:14:15+00:00","dateModified":"2024-05-23T09:10:28+00:00","description":"Learn how to add listings with the active users who published osts on your WordPress website and display users' metadata with the Listing Grid widget\/block\/element of the JetEngine WordPress plugin.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/displaying-only-users-with-posts-in-a-listing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/crocoblock.com\/knowledge-base\/"},{"@type":"ListItem","position":2,"name":"Tips & tricks","item":"https:\/\/crocoblock.com\/knowledge-base\/tips-and-tricks\/"},{"@type":"ListItem","position":3,"name":"Displaying Only Users with Posts in a Listing"}]},{"@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\/tips-and-tricks\/30128"}],"collection":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/tips-and-tricks"}],"about":[{"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/types\/tips-and-tricks"}],"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=30128"}],"wp:term":[{"taxonomy":"tipstricks-tags","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/tipstricks-tags?post=30128"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}