I have a list of logs, and I want to group them by the user's name. Is it possible to group data in a GridDetail?
Like
If this is a classic detail, this marketplace add-on will allow you to group the rows of any list: https://marketplace.creatio.com/app/tree-view-creatio
Ryan
Hi Ryan,
I intend to do something like that.
SELECT username
FROM logs
GROUP BY username
I’m not sure if it’s possible to list the grouped data.
Thanks
Cristiano Carvalho,
Yes, that is what that marketplace add-on allows you to do - the column you select (in your case the username) will group the rows by that column, so rows with that username will be grouped below it and can be expanded.
You can see an example of this out of the box on the classic project page, the structure tab (the project tasks) group this way as well (it is grouped by the ParentId column). You can analyze the "ProjectStructureDetailV2" schema to see how it is implemented.
Ryan
Ryan Farley,
I am afraid, this addon allows to display parent-child tree, but not group by category.
Hello, yes, that's true.
Do you know of another option to group by name?
Thanks
Dear Cristiano,
Unfortunately, the option to group the list is not currently available.
As a workaround, you can add two separate lists to the page. In the first list, include users, and in the second, logs. Then, apply a filter to the logs based on the selection in the users' list.
This setup allows you to select one or more users in the first list, and the second list will automatically display logs related to the selected users.
You can also set up a pivot table in Classic UI dashboards, which allows grouping by a certain column, but pivot tables also have some restrictions. You can read more about it in this article.
Additionally, I created an idea for our R&D team.
Have a great day!
Cristiano Carvalho,
If you want to create read-only detail, you can create VIEW with ParentId field. Then you can use this add-on.
But editable detail is much more difficult
Another option is to create 2 details - Contacts and Logs. So, Logs detail is filtered by selected Contact
Kind regards,
Vladimir