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

Archived from the Xataface Users forum.

Jean — Wed Feb 17, 2010 1:40 am

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 — Wed Feb 17, 2010 11:43 am

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