Navigating with a group by function

Hi @Rpauley,

Can you please share the details of the lobby element designer?

Thanks!
Bhagya

Hi @Rpauley,

Based on the screenshots that you have provided noticed that you have used CONTRACT in the GROUP BY clause whereas the select query uses “site_api.get_description(CONTRACT)” method.

The column used in a Group By clause must be available in the select statement. You cannot select aggregates across a field if you don't include the field in the group by list. 

You can either include column CONTRACT into the select statement or use the “site_api.get_description(CONTRACT)” method itself in the Group By clause.

Kindly try out and let me know the results.

Thanks,

Anjaleen

You can use matrix element. There is show summary option. 

Example:

@Bhagya Wickramasinghe , here is screen shot of lobby element designer

@Anjaleen Davidson i tried adding Contract and receive the same results getting a error message when i click on the QTY to bring that record up

@hhy38 i currently have the matrix for all of these i was trying to reduce the size of my lobby by combining them all into a list, everything works except for i cant navigate to the bad records