Hi everyone,
I have a requirement in PEGA Constellation, where we are displaying data in a table within a case. Currently, the table shows a list of requests, but I need to group the data by a specific column.
For example, if we have 5 employees, and each employee has 2 requests, the table currently displays 10 rows. However, I want to group the data by Employee, so the table displays only 5 rows, with each row representing an employee and their associated requests grouped under them.
I see that there is an option to group data on the UI side, but I need this grouping to be applied by default when the table loads.
How can I achieve this in Constellation?
Thanks.
@MOHAMMED IMRAN
We have an option in table level view, group by, you can add the Employee as a grouping condition. Find the attachment for the same.
@Kishore Kumar Madduri Hi Kishore ,
Thank you for your response.
The Group By option is available in the Data Type List View, but I need it specifically for the case area. I have a Page List property on pyWorkPage, and in the UI of the case request, I am using this embedded Page List to display the data in a table. However, I don’t see the Group By option available in this section.
Is there a way to enable default grouping for embedded Page Lists in the case UI?
@MOHAMMED IMRAN
We have no option for group by for direct embedded Data/Pagelists. I suggest to create a Datapage source as DT and map the pagelist results to Datapage results and Create table view and source this Datapage and you will be able to group by.
Hi @MOHAMMED IMRAN,
We can add Group by directly
While creating page list we to select Embedded data list data and configure your page list
Regards,
Mohd Qizer Uddin
@MOHAMMED IMRAN
Since embedded fields are editable by design , there is no authoring experience to group by a column.
You can however show the data in read only using a data reference field to use group by , filter etc options.
