Sorting by status and date at the same time?

[stayfi]

Hello,
is it possible to sort by status and date at the same time?

[shalmaxb]

In Layout Manager of your entity define a search filter for the fields you want to output. In the entity you can stack the filters, use more than one filter at once.

[stayfi]

thanks shalma, will try

[item]

Hi,
do you need sort by user request or by default on listView ?

i think, to test : in entityDefs, search on bottom of file : orderBy

and put something so : [ [ "status", "asc" ], [ "date", "desc" ] ]

to try .. but certainly work but this is then defaut orderby

[stayfi]

Hi item, indeed i want to sort by default on listview, where's the "orderBy" located in entitydefs?

any image to have an idea?

[item]

Hi,
i have never try !

https://github.com/espocrm/espocrm/blob/5e44fc2d4037e0d1ba22f6df03301ebb72f92c87/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Account.json#L364

you must go in custom/ressources/metadata/entitydefs/your entity.json
remove maybe line “order”

but make a backup of json before test, after in admin, clear cache rebuild.. if don’t work.. re-put old file.
if work.. post result

else you can try :

https://forum.espocrm.com/forum/developer-help/88687-orderby-list-of-options

[stayfi]

mm seems i should dive into the files, but since i'm not the admin, and i get error access, i'll try to forward my question to the manager, thanks again item

[item]

sorry stayfi,
just tested on last 7.3.4 .. not work.
then only way is by coding

[stayfi]

mm bummer, hope the dev team will implement it in the UI for easy access

[esforim]

Just to help with searches, this would be: multi-sort, or multiple-sorting, multiple column sorting

[stayfi]

Just to help with searches, this would be: multi-sort, or multiple-sorting, multiple column sorting

is this an option? or you're suggesting a feature?

[esforim]

It just for forum searching in the future. I should have add an "off-topic".

[deepsinghal29@gmail.com]

I want task on my sidebar to be sorted by status. I have updated the Deault Order field on Task entity to Status, but it still sorts on date.