Sort Email Templates by field other than Date Created?

[tpayne03]

Hi,

We have ~25 email templates we use in EspoCRM and occasionally add new ones. Is there a way to sort them automatically alphabetically instead of by Date Created?

Like for example, we open the Email Template tab and "Name" is the default option to sort?

[victor]

1. In Your_Instance_Name/custom/Espo/Custom/Resources/metadata/entityDefs create a file EmailTemplate.json and add:
- If the default sort should be Ascending, then add:

{
    "collection": {
        "orderBy": "name",
        "order": "asc"
    }​
}
​

If the default sorting should be Descending, then add:

{
    "collection": {
        "orderBy": "name",
        "order": "desc"
    }
}​

2. Save changes to file and make Rebuild (in Administration > Rebuild).

[tpayne03]

Hi, I have copied the JSON array and am receiving error a Syntax Error in the data logs when I try to rebuild (Error 500 in Admin screen, check data logs and Syntax Error is noted in the logs)

Is there a piece of syntax or a character that is off in the array?

Freshly installed Espo 8.06 (coming from version 5 which ran for 6 years, but we moved to Office 365 and need the updated pack!).

[yuri]

Try to type the same JSON manually. Might be hidden characters present in the text (an issue of the forum software).

[victor]

tpayne03, yuri is right. The forum added extra characters to the code I suggested.

I copied the code from my previous post



and pasted it into Your_Instance_Name/custom/Espo/Custom/Resources/metadata/entityDefs/EmailTemplate.json:


You should remove <0x200b> and save the changes.

[tpayne03]

Thank you both! I hand typed it, and indeed there is there is that hex. No problem using that array hand typed. Sorry, I wasn't aware the forum could put in characters!