How Set "Group By" in Custom Query?

you might be able to generate groupings/subtotals using the 'SQL Form' tab, or a stored procedure, and then format output accordingly using Kendo UI Hash Templates' IF, ElseIf, Else, functionality.
but I never did it so don't really know.

but something you definitely could do as a work around, is use a process with subprocesses to pre-generate/compile the resultset with subtotal records in it, and then output this to a Custom Query, though it would take more time to generate.

I think your question is one which is best posed to Support.
Bruce with his dabblings in CQ's is going to get to the point where he asks the same question.
As well, there must be others who use CQ's who would like to know.

But something to consider with CQ's is that most often they will not have a grid type output layout conducive to subtotals.
In such cases if Aware had the subtotals option setting then where would the subtotal appear in the flow of output if it was left-to-right-top-to-bottom? (ie. each record as a tile)
As an entire row? As a tile immediately following the previous?

If I understand correctly, with standard queries, you can have the data in the table displayed and when an attribute changes, have subtotals for that grouping. This, plus expanding rows is missing from custom queries.

You can easily have a SP return the sub totals, but it sounds like you want that contained within your regular query and that is NOT easy to do in SQL.

Purest, I am using Custom Queries to look VERY similar to standard queries, except (with your help) using FLEX layout so I can have data wrap in each column when necessary. Also, what I consider a plus is that Operations with Items in custom queries, is not handled by the context menu (Right click) so I have the full width for my data, and the right click will display all of my item options.

Bruce

but what is the visual que to the user that menu options exist for the record?
is there a notice in the header bar of the query about right clicking or some other notification somewhere?
it seems a bit clunky and 'unfinessed' for you.

Nope, NO notice about the context menu. However

1) This is all INTRAnet so my users are trained
2) Many peeps are used to right clicking on something for options
4) Its the only way Custom queries work

Bruce

p.s. saving #3 for emergencies

cishpix wrote

Hello there,

when we create a "Standard Query", we can set the "Item Grouping" from the query options, but how can we do it IF we choose "Custom Query" because there is no "Item Grouping" option.

Is it possible?
If yes, how can I write the HTML code for show the item group?

Thanks for incoming answer.

Anything is possible, but the Kendo UI ListView (basis for AIM custom grid) does not inherently supporting column grouping. I don't know your use case, but it may be easier to to use a standard query so that you can leverage the out of the box grouping (and other features) and customize the UI to look like your custom query.