Forums

Hi
I set up a form for registered users to give ratings to articles
As I have over 200 artcicles I want every user can see a list of all items with those he rated, and the rate value he gave and those that he did not rated (to facilitate the job) of course without seeing the notes of other users.
The rate is in a table field "score" with rows user_id and (joomla user id) article_id (the same as joomla) and rating value
i didn't succeed to set the query on ChronoConnectivity
Thank you for your help

Hi Himan,

It sounds as though you need a compound query. The main part will look up all of the articles; the secondary part will get the user's ratings and link those to the articles.

I think that one of the FAQs has some help with compound queries.

Bob

Thank you GreyHead for your answer
I looked in the FAQ but didn't find about the compound query
can you show me where thanks
H

Hi evrybody
Any idea about this query
Thanks for your help😀
H

Hi Himan,

Please see this FAQ

Bob