BPM, Workflow, and Case

BPM, Workflow, and Case

Come for answers. Stay for best practices. All we’re missing is you.

 View Only
Expand all | Collapse all

BPM/BAW - Saved Searces order by with Dates

  • 1.  BPM/BAW - Saved Searces order by with Dates

    Posted Thu February 09, 2023 09:42 AM

    Hello.
    I'm using a saved search that order the result by taskDueDate and as second sort, by name. But since the taskDueDate is a default task value using Timestamp, how can i perform a saved search that only order from yyyy-mm-dd without using hours min and seconds?

    My objective is to order by name all ocurrences that have the same taskDueDate for each day. 

    Example:

    2022-01-05 - Andrew

    2022-01-05 - Carlos

    2022-01-05 - Magic

    But using timestamps, all taskDueDate values are like unique so it will not apply the alphabetic order on name since there aren't 2 exact dates equal



    ------------------------------
    Filipe Ferreira
    ------------------------------


  • 2.  RE: BPM/BAW - Saved Searces order by with Dates

    Posted Thu February 09, 2023 10:09 AM

    Sadly you will have to define the dueDate before task is created, like this:

    tw.local.dueDate = new tw.object.Date();
    tw.local.dueDate.setHours(0);
    tw.local.dueDate.setMinutes(0);
    tw.local.dueDate.setSeconds(0);
    tw.local.dueDate.setMilliseconds(0);

    And then in the priority settings of the task, bind the Due in: setting to that date.



    ------------------------------
    Johan Andersson
    ------------------------------