solution for my query

solution for my query

  

hi friends,

                 In my scenario i have a user table club table userrating table in which each user rate the club and i want to display the average rating of each club in a table,how to solve it

Hi Karthik,

I don't know if I understood what you want, but from what I understand you have a table for users, a table for clubs, and a table with reviews of users to clubs (you should have the id of the user, the id of the club and the review itself in that table).

To implement what you want in OutSystems, add the Clubs and reviews tables as sources of an aggregate. Then group by the Club Id and calculate the average of the review column. To help you, read this documentation:

-> "Calculate Values from Grouped Data" - 

https://success.outsystems.com/Documentation/10/Developing_an_Application/Use_Data/Query_Data/Calculate_Values_from_Grouped_Data

-> "Aggregate a Column into a Single Value" - 

https://success.outsystems.com/Documentation/10/Developing_an_Application/Use_Data/Query_Data/Aggregate_a_Column_into_a_Single_Value


Does it help you?