1 Reply Latest reply on Mar 27, 2015 7:49 AM by CraigMiddelstadt

    Status order on query

    Johnwalker Apprentice

      Hi all,

       

      I'm creating a dashboard for new process and would like to group the calls based on the statuses.

       

      I know that this is possible to sort them on the status but as you would expect its showing the statuses sorted in alphabetic order but I actually want them sorted in order the statuses show in the process (eg the process starts with To Be Actioned then moves on to Awaiting Demo then Awaiting Quote).

       

      Any idea if this if possible and if so how?

       

      Thanks

      John

        • 1. Re: Status order on query
          CraigMiddelstadt Master

          You Could add and INT attribute to the Lifecycle -> Status window then create a query for this and open each status and assign a number which correlates with the order of your process.  Then add this attribute to your query and sort ascending and hide attribute on the query.