How do I group in custom queries?

joben

A standard query has a “grouping” setting in the Config Tool.
Custom queries do not have this setting. Is there a way to accomplish this? Javascript perhaps?

I just need a very simple grouping. Just a heading with the group attribute value will do. Bonus if the grouping respects sorting the groups alphabetically. The records still also have to respect the “operations with records”. So generating a “dumb” list and displaying it is not a solution.

jktb75

Hi Joben,
There are 2 options:

Use a custom query and build your own functionality (html, css javascript or use Kendo ui to rebuild the table your way) or
A better way is to use the standard grid that already has all functionality for grouping, and use css, js and Kendo to display it as you require.
If you can share an image with explanation, I might be able to help in more detail