This should be possible by using "orderby" on the event type property plus on the UI side rendering the results accordingly.
ordere by only offers sorting facility or am I wrong?
1 person found this helpful
Note that with the query builder (or jcr xpath search) you only get a list of nodes as results - you cannot change the output columns and do aggregate functions. Hence your UI code needs to do that.
Perfect... thats answers the query...
Basically the summary is I cannot use aggregate functions like group by. Once i get the search results, i can either use facets, get the bucket predicates and drill down the search OR get all the results, do look up on property (using Node.getProperty) of each node in the result and build my UI based on mere coding. Am I right?