Unable to sort decending

Bugs & Issues
1

Hi All!

I have been having an issue with sorting any data by date in a descending order.
Even if I use a single sorting expression in a formula I always get an ascending list.
Eg.:

Runs.Filter([Creation Date] >= Today() - Days(15)).Sort(Finished, false)

will result the same list as

Runs.Filter([Creation Date] >= Today() - Days(15)).Sort(Finished)

Has anybody else noticed a similar behavior?
Thank You!
Attila

2

The Sort() function is normally only used in formulas when followed by First() or Last(), in order to get the highest/lowest item. It has no effect on how a collection is displayed on the UI.
Sorting of a collection is a UI-only thing, and for formulas that result in a collection, it is not possible to control the sort order.

3

Thank You, Chr1sG for the quick answer. Albeit the reasoning surprises me as it would mean I can create views and sort its items any way I want, but I am unable to use the same feature in a formula to display the relevant information. Interesting.
Thanks again for the help!

4

We have a feature in the backlog to make collections that are the result of formulas, behave like regular relation fields on the UI (sort, filter, color-code) which will probably solve this

5
6

That is some great news, I am looking forward to seeing it. Thanks again!

7

Is there a way we can vote on this feature? I notice the original post is a bug report that has come up in several threads now.

8

If you’re encountering the problem described in this topic, then the solution will be supporting normal collection field behaviour for formulas/lookups, which is what is described in the topic mentioned above, so voting on that topic will be enough.

1 Like