{"id":41381,"date":"2023-08-02T10:46:11","date_gmt":"2023-08-02T10:46:11","guid":{"rendered":"https:\/\/crocoblock.com\/knowledge-base\/?post_type=article&p=41381"},"modified":"2023-08-02T13:20:15","modified_gmt":"2023-08-02T13:20:15","slug":"how-to-show-posts-reviews-with-average-rating-count","status":"publish","type":"article","link":"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/","title":{"rendered":"How to Show the User’s Posts Reviews with Average Rating Count on the Single User Profile Page"},"content":{"rendered":"\n

Create an SQL Query<\/h2>\n\n\n\n
\n

Start with building an SQL query to retrieve the needed data.<\/p>\n\n\n\n

Go to WordPress Dashboard > JetEngine > Query Builder<\/em><\/strong>, and add a new query by clicking the corresponding button.<\/p>\n\n\n\n

Complete the Name <\/strong>field and select\u201d SQL\/AI Query\u201d Query Type<\/strong>.<\/p>\n\n\n\n\"sql\n\n\n\n

Now move to the Custom SQL Query <\/strong>tab, pick a \u2018jet_reviews\u2019 option in the From table <\/strong>selector, and enable the Use Join<\/strong> toggle.<\/p>\n\n\n\n\"jet\n\n\n\n

We need to join a \u2018posts\u2019 table using the \u201cInner Join\u201d option as a Join Type<\/strong> because it contains columns by which the query needs to be performed to retrieve the proper data.<\/p>\n\n\n\n

The When current table column<\/strong> and Is equal to other table column<\/strong> should be set to \u201cID\u201d and \u201cpost_id\u201d respectively.<\/p>\n\n\n\n\"posts\n\n\n\n

Proceed with adding Where (query clauses.)<\/strong><\/p>\n\n\n\n

In the first clause, we need to specify that the author of the post which has been reviewed is the queried user. This way, we get the posts added by the queried user.<\/p>\n\n\n\n

So, the Column <\/strong>should be set to \u201cposts.post_author\u201d, Compare <\/strong>to \u201cEqual,\u201d Value <\/strong>to \u201cQueried user ID,\u201d and Type <\/strong>to \u201cNumeric.\u201d<\/p>\n\n\n\n\"post\n\n\n\n

In the following clause, we set \u201cposts.post_type\u201d as Column<\/strong>, \u201cEqual\u201d as Compare <\/strong>operator, and a specific post type\u2019s slug from which we want to pull the posts as Value<\/strong>.<\/p>\n\n\n\n\"post\n\n\n\n

In the following clause, we want to eliminate the reviews submitted by the queried user themselves. This step is optional if you wish to include the reviews submitted by the post author in their own posts.<\/p>\n\n\n\n\"post\n\n\n\n

The custom query is completed; press the \u201cAdd Query<\/strong>\u201d button to save it.<\/p>\n<\/div><\/div>\n\n\n\n

Display Average Reviews Count<\/h2>\n\n\n\n
\n

At this point, go to a template used on the Single User Profile Page<\/strong> in the Profile Builder<\/strong>, and add the widgets that can display the average rating count.<\/p>\n\n\n\n

Add the Heading widget to the template, and click the dynamic tag icon.<\/p>\n\n\n\n\"dynamic\n\n\n\n

In the dynamic tags list, select the \u201cDynamic Function\u201d option.<\/p>\n\n\n\n

The Function <\/strong>should be set to \u201cSQL Query Results.\u201d<\/p>\n\n\n\n

The \u201crating\u201d from the SQL query created in the previous step needs to be chosen as Query Column<\/strong>.<\/p>\n\n\n\n

The Additional Function<\/strong> should be set to \u201cAverage\u201d as we need to count the average rating value.<\/p>\n\n\n\n\"sql\n\n\n\n

After setting up the dynamic function, you can add the Before <\/strong>and After <\/strong>text in the Advanced <\/strong>tab to create a more customized result.<\/p>\n\n\n\n\"dynamic\n\n\n\n

Now add another Heading widget to display the number of reviews left for the posts authored by the queried user.<\/p>\n\n\n\n

This time, we should select a \u201cQuery Results Count\u201d macro and choose the Custom Query <\/strong>created earlier. <\/p>\n\n\n\n

The Returned Count <\/strong>option does not need to be changed; the default one is correct. In this Heading widget, we also added a Before <\/strong>and After <\/strong>text in the Advanced <\/strong>tab.<\/p>\n\n\n\n\"query\n<\/div><\/div>\n\n\n\n

Check Result on Front End<\/h2>\n\n\n\n
\n

Now the template should be saved, and the result for this step can be checked on the Single User Profile Page<\/strong> on the front end. The Heading widgets show the average rating count and the review count correctly.<\/p>\n\n\n\n\"single\n\n\n\n

We can proceed with displaying the reviews created for the posts of the queried user.<\/p>\n<\/div><\/div>\n\n\n\n

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

In this step, we will create a Listing template<\/strong> for the custom query built to show all information about the reviews submitted to the posts of the queried user.<\/p>\n\n\n\n

Go to WordPress Dashboard > JetEngine > Listings<\/em><\/strong>, and press the \u201cAdd New<\/strong>\u201d button at the top of the page to call a Listing item settings pop-up.<\/p>\n\n\n\n

The Listing source<\/strong> should be set to \u201cQuery Builder.\u201d Next, pick the custom Query <\/strong>created earlier, and give it a name in the corresponding field.<\/p>\n\n\n\n\"sql\n\n\n\n

In the editor, you can add a Dynamic Field<\/strong><\/a> widget to show the data from the query.<\/p>\n\n\n

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

You should select fields under the Query<\/strong> object to pull data from the custom query.
\n<\/p><\/div><\/div>\n\n\n\n\"dynamic\n\n\n\n

You can add any needed fields from the custom query as a Dynamic Field<\/strong> Source <\/strong>to display the reviews data.<\/p>\n\n\n\n

In the described case, we added a Dynamic Field<\/strong> with an \u201cauthor\u201d source for showing the review’s author.<\/p>\n\n\n\n

The \u201cauthor\u201d object field itself stores an ID of the user, which is why an additional callback is needed to convert a user ID into the needed user property like a Display name<\/strong>. The \u201cGet user data by ID\u201d Callback <\/strong>is not available by default, so it needs to be installed from GitHub Gist<\/a> and uploaded to your website to be in the list of Dynamic Field Callbacks<\/strong>.<\/p>\n\n\n\n\"dynamic\n\n\n\n

Using another Dynamic Field<\/strong> widget, we also displayed a date when some user left a review. We added a \u201cFormat date\u201d Callback <\/strong>to apply a needed format to date.<\/p>\n\n\n\n\"dynamic\n\n\n\n

As the Listing template<\/strong> is completed, it can be saved.<\/p>\n<\/div><\/div>\n\n\n\n

Output Listing Grid with SQL Query<\/h2>\n\n\n\n
\n

The last step is placing the Listing Grid<\/strong><\/a> based on SQL query on the Single User Page<\/strong>.<\/p>\n\n\n\n

Go to the needed template applied in the Profile Builder<\/strong> settings, and open it in the Elementor editor. Add the Listing Grid<\/strong> widget on the template, select the Listing <\/strong>template for the custom SQL Query, and configure other settings for the Listing Grid<\/strong> widget if needed.<\/p>\n\n\n\n\"posts\n\n\n\n

Now we can check the result.<\/p>\n\n\n\n

The Listing Grid<\/strong> shows the reviews submitted to the posts of the queried user on their Single User Profile Page <\/strong>as per the custom query created via JetEngine\u2019s <\/em>Query Builder<\/strong>.<\/p>\n\n\n\n\"reviews\n<\/div><\/div>\n\n\n\n

That\u2019s all; now you know how to display the WordPress user\u2019s posts reviews with average rating count on the Single User Profile Page with JetReviews <\/em>and JetEngine<\/em>.<\/p>\n","protected":false},"excerpt":{"rendered":"

This tutorial explains how to create an SQL query to show an average rating count submitted to the posts published by the queried user and output that count. <\/p>\n","protected":false},"author":9,"featured_media":0,"template":"","format":"standard","builder-category":[],"article-category":[463],"yoast_head":"\nHow to Show User\u2019s Posts Reviews with Average Rating Count \u2014 JetReviews | Crocoblock<\/title>\n<meta name=\"description\" content=\"From this guide, you will find out how to display the reviews with average rating count on the Single User Profile page using JetReviews and JetEngine plugins.\" \/>\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\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Show User\u2019s Posts Reviews with Average Rating Count \u2014 JetReviews | Crocoblock\" \/>\n<meta property=\"og:description\" content=\"From this guide, you will find out how to display the reviews with average rating count on the Single User Profile page using JetReviews and JetEngine plugins.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/\" \/>\n<meta property=\"og:site_name\" content=\"Help Center\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-02T13:20:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/08\/Screenshot_57.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=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/\",\"url\":\"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/\",\"name\":\"How to Show User\u2019s Posts Reviews with Average Rating Count \u2014 JetReviews | Crocoblock\",\"isPartOf\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/#website\"},\"datePublished\":\"2023-08-02T10:46:11+00:00\",\"dateModified\":\"2023-08-02T13:20:15+00:00\",\"description\":\"From this guide, you will find out how to display the reviews with average rating count on the Single User Profile page using JetReviews and JetEngine plugins.\",\"breadcrumb\":{\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/#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 Show the User’s Posts Reviews with Average Rating Count on the Single User Profile Page\"}]},{\"@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 Show User\u2019s Posts Reviews with Average Rating Count \u2014 JetReviews | Crocoblock","description":"From this guide, you will find out how to display the reviews with average rating count on the Single User Profile page using JetReviews and JetEngine plugins.","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\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/","og_locale":"en_US","og_type":"article","og_title":"How to Show User\u2019s Posts Reviews with Average Rating Count \u2014 JetReviews | Crocoblock","og_description":"From this guide, you will find out how to display the reviews with average rating count on the Single User Profile page using JetReviews and JetEngine plugins.","og_url":"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/","og_site_name":"Help Center","article_modified_time":"2023-08-02T13:20:15+00:00","og_image":[{"url":"https:\/\/crocoblock.com\/knowledge-base\/wp-content\/uploads\/2023\/08\/Screenshot_57.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/","url":"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/","name":"How to Show User\u2019s Posts Reviews with Average Rating Count \u2014 JetReviews | Crocoblock","isPartOf":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/#website"},"datePublished":"2023-08-02T10:46:11+00:00","dateModified":"2023-08-02T13:20:15+00:00","description":"From this guide, you will find out how to display the reviews with average rating count on the Single User Profile page using JetReviews and JetEngine plugins.","breadcrumb":{"@id":"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/crocoblock.com\/knowledge-base\/jetreviews\/how-to-show-posts-reviews-with-average-rating-count\/#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 Show the User’s Posts Reviews with Average Rating Count on the Single User Profile Page"}]},{"@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\/41381"}],"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=41381"}],"wp:term":[{"taxonomy":"builder-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/builder-category?post=41381"},{"taxonomy":"article-category","embeddable":true,"href":"https:\/\/crocoblock.com\/knowledge-base\/wp-json\/wp\/v2\/article-category?post=41381"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}