- Support Forum
- /
- Main Forum
- /
- Joomla Extensions Support
- /
- vReview
- /
- How to call Average Rating in Seblod?
How to call Average Rating in Seblod?
- Daniel
-
- Offline
- Administrator
-
Hi Claudio,
xml column in database table #__vreview_review is varchar which stores multiple parameters in JSON format. So you need to write your query accordingly. If you want us to assist you in the Job, Please contact our Sales team at This email address is being protected from spambots. You need JavaScript enabled to view it..
Thanks
Daniel
Please Log in or Create an account to join the conversation.
- claudio Fernandes
-
Topic Author
- Offline
- New Member
-
- Posts: 4
Hi, I am building a directory with Seblod and vReview is working well in full article view by calling the module.
Now I need to show average ratings for each article in the listings search. Seblod provides field plugins that allow me to add SQL or PHP code. I've tried this SQL query but it's not working.
SELECT AVG(rating) FROM #__vreview_review as t1 WHERE t1.xml = [pk]
Can you help?
Regards
Anjo
Please Log in or Create an account to join the conversation.
