Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Below there are some samples:


  • Searching against total duration including every users within the selected status(es).

    Code Block
    "Time in Review" >= 4d


  • Searching against a single user. 

    Code Block
    "Time in Open" <= timeSpentBy("5d", "agrant")



  • Searching against multiple users. Below function searches time spent by users (agrant, jevans and hjennings) in 'Waiting for support status' more than 5 calendar days.

    Code Block
    "Time in Waiting for support" >= timeSpentBy("5d", "agrant", "jevans", "hjennings")



  • Searching by the IDs of status(es) . When the custom field is defined with multiple statuses, but you want to filter by some of them with the status IDs.

    Code Block
    "Time in Open" > timeSpentInStatus("2d", "1") 


    (where 1 is ID of status Open)

  • Searching by the names of the status(es). When the custom field is defined with multiple statuses, but you want to filter by some of them with the status names.

    Code Block
    "Time in In progress" >= timeSpentInStatus("6h", "In Progress") 
    
    "Time in In progress" >= timeSpentInStatus("6h", "Open", "In Progress", "In Review")



  • Searching by status ID and the users

    Code Block
    "Time in In progress" > timeSpentInStatusBy("8h", "3", "agrant")
     


    (where 3 is ID of status Open and agrant is the username)

  • Searching by status name and the users

    Code Block
    Test > timeSpentInStatusBy("10h", "Open", "hjennings")