Announcement

Collapse
No announcement yet.

Sorting by status and date at the same time?

Collapse
X
Collapse
 
  • Page of 1
  • Filter
  • Time
  • Show
Clear All
new posts
Previous template Next
  • #1

    Sorting by status and date at the same time?

    Hello,
    is it possible to sort by status and date at the same time?
    Tags: None
  • #2
    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.

    Comment

    • #3
      thanks shalma, will try

      Comment

      • item
        #3.1
        item commented
        03-11-2023, 07:04 PM
        Editing a comment
        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
    • #4
      Hi item, indeed i want to sort by default on listview, where's the "orderBy" located in entitydefs?

      any image to have an idea?
      Last edited by stayfi; 03-12-2023, 10:00 AM.

      Comment

      • #5
        Hi,
        i have never try !

        espocrm/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Account.json at 5e44fc2d4037e0d1ba22f6df03301ebb72f92c87 · espocrm/espocrm
        https://github.com/espocrm/espocrm/blob/5e44fc2d4037e0d1ba22f6df03301ebb72f92c87/application/Espo/Modules/Crm/Resources/metadata/entityDefs/Account.json#L364
        EspoCRM – Open Source CRM Application. Contribute to espocrm/espocrm development by creating an account on GitHub.


        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 :

        OrderBy List of options - EspoCRM Open Source Community Forum
        https://forum.espocrm.com/forum/developer-help/88687-orderby-list-of-options
        Hello, Does anyone know how to specify OrderBy as a list ? For example, on the backend one can do: $this->entityManager ->getRDBRepository('MyEntity') ->getRelation($entity, 'children') ->order('LIST:machineStatus:IN_USE,STORED_INOPERABLE,TRANSFERRED_SOLD,DISPOSED') ->find();​ but how does one do something
        Last edited by item; 03-12-2023, 11:03 AM.

        Comment

        • #6
          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

          Comment

          • item
            #6.1
            item commented
            03-12-2023, 07:23 PM
            Editing a comment
            sorry stayfi,
            just tested on last 7.3.4 .. not work.
            then only way is by coding
        • #7
          mm bummer, hope the dev team will implement it in the UI for easy access

          Comment

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

            Comment

            • #9
              Originally posted by espcrm View Post
              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?

              Comment

              • esforim
                #9.1
                esforim commented
                03-15-2023, 01:36 AM
                Editing a comment
                It just for forum searching in the future. I should have add an "off-topic".
            • #10
              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.
              Attached Files

              Comment

              Previous template Next
              Working...
              X