Hi all,
AFAIK "group by" does not work with query extensions.

What would be the easiest way to get an display session, which "groups" the first part of an two part index?

So if for example if my index is like "index1 = field1, field2"
the session should skip any duplicates of field1 and only display one record per different value in field1.

Kind regards
Richard

Have you looked at using skip.io? I am thinking you display the first record set like a hold variable, then in the after.read section checking the current field against the hold variable - if equal then execute skip.io.

Hi Mark,

thanks for that advice. That should work!

But, to save time I will first create a version without that "grouping". And after that, if there is more time, I will try.
There ist also some additional logic, which I have now in a query.extension, to transfer into main.table.io-section. I think it will be better not to use both techniques

Kind regards
Richard