This is probably simple, but what syntax to I use on an aggregate table to default the sort order so that the category with the highest number of records is first?
Page 1 / 1
Shane,
You’ll put the function and field of whichever field is the “number” field in the Fields to order records by property of the aggregate model. For example, I have an aggregate Account model that groups by Industry and has an aggregation on Id. If I want to show the records sorted by count high to low, then I put COUNT(Id) DESC into the Fields to order records by property
That worked, thanks so much!
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.