Skip to Content (Press Enter)
2026-01-23 11-38-55
Dinesh Murugan
Champion
28Views
2Comments
Solved
How to Group Data Using Filters in the Data Tab Without "Group By"?
Question
ODC

I am not using this Aggregate in a screen, so I am unable to use the "Group By" option. How can I group data using a filter in the Data tab? 


0
0
30 Dec 2024
Copy Link
2020-07-21 19-28-50
Rajat Agrawal
Champion
Solution

Hi @Dinesh M 

We can not directly apply filter in data tab but we can create a server action inside this we apply Advanced SQL and write  SQL queries, including grouping logic.

Regards,

Rajat


See solution in context
2
0
30 Dec 2024
Copy Link
2025-12-03 17-22-41
Lavanya Kamalaguru
Solution

Hi @Dinesh M 

Please refer the attached oml. I hope that will solve your issue.

Thanks,

Lavanya Kamalaguru

See solution in context
GroupBy.oml
1
0
31 Dec 2024
Copy Link
2020-07-21 19-28-50
Rajat Agrawal
Champion
Solution

Hi @Dinesh M 

We can not directly apply filter in data tab but we can create a server action inside this we apply Advanced SQL and write  SQL queries, including grouping logic.

Regards,

Rajat


2
0
30 Dec 2024
Copy Link
2025-12-03 17-22-41
Lavanya Kamalaguru
Solution

Hi @Dinesh M 

Please refer the attached oml. I hope that will solve your issue.

Thanks,

Lavanya Kamalaguru

GroupBy.oml
1
0
31 Dec 2024
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.