Descending date sorting ̶b̶u̶g̶

[abidoss]

I recently noticed an issue with date sorting: when I sort in descending order, the dates are not arranged correctly, as shown in the attached screenshot

[yuri]

I've never encountered this. Can anyone who can reproduce look into?

[victor]

I recently noticed an issue with date sorting: when I sort in descending order, the dates are not arranged correctly, as shown in the attached screenshot

It is not reproduced in either custom or system entities (with either custom or system fields).

[abidoss]

The problem only appears when I enter a word in the search bar — for instance, "administrateur"

[abidoss]

It's strange — the issue doesn't occur with this status or with other statuses.


the issue only occurs when this particular status is selected ,I noticed that the issue occurs when I select "All" and the status is set to "Closed" in the search filter

[yuri]

It's because the full text search relevance sorting is applied before the "date". Records that are more relevant will be displayed first. The regular field order will be applied on top.

It's configurable.

https://docs.espocrm.com/development/metadata/entity-defs/#fulltextsearchordertype