4 Replies Latest reply on May 6, 2013 7:32 AM by Aryan12345

    Group by clause using query builder

    Aryan12345 Level 1



      I have some event pages (pages created using a template called event) which are tagged with event types and I have 5 event types in total. In the event listing page, i want to show the events grouped by event types.


      Is there a facility in query builder to use "group by" which returns be results in different buckets?


      Is thats not the case, i have to run 1 query per event type which means i have to run 5 queries. (or i get the event type as facets -> get the buckets -> get the predicate for each bucket -> run one query per bucket which again is nothing buket one query per event type). I dont want to do that.  


      Hence using the query builder or any other form of querying, is there a way to group the results?