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

joben

This is a basic proof of concept that works:

<div>

# if (typeof window.lastGroup === "undefined") {
    window.lastGroup = "";
}

if (data["name"] !== window.lastGroup) { 
    window.lastGroup = data["name"];

#
<div><b>{name}</b></div><br>
#

 } #

{task}<br><br>

</div>

Output should be something like:

Alice

Fix stuff
Fix more stuff

Bob

Fix the red car

Mallory

Get flowers
Book dinner

NOTE: Make sure that you have a DIV tag at the start and end of your template. My entries did not become clickable otherwise (operations with records), and I had a strange bug when navigating back and forth where the group header would disappear. Also make sure that you sort by the attribute you group by. I guess it won’t work otherwise.