How to insert DISTINCT and GROUP BY in a url for an action

[Jean]

Hello again Steve,
Is there anything in the URL conventions to insert a DISTINCT and a GROUP BY in the URL for an action ?
Thank you
Jean

[shannah]

Hi Jean,

No direct way to do this. There are workarounds using relationships (and searching on the related fields) which can yield a similar search (but slow on large datasets) - but no direct way.

For something like this you're probably looking at either creating a View and querying that - or creating a custom action altogether.

-Steve