It would be nice if we could sort table aggregations when getting unique values like we can for normal queries. Especially since aggregations can be used for populating dropdowns. This could let us have drop downs sorted in alphabetical order or numerical order by say a part/product name/number. I think this would vastly increase the users of apps experience especially if an aggregation has many values to select from.
Doesn’t the query sort order get reflected in the unique values aggregation result? So as long as you have a query that sorts by the same field as your unqiue values aggregation, you should be fine…unless you have many records with the same value in that field, and run up against a query limit where potentially your aggregation could only have the one unique value, despite there being other unique values in the that column in the table…
1 Like