Child pages
  • Actual Duration
Skip to end of metadata
Go to start of metadata

Field: ActualDuration


ActualDuration is the time that it takes to complete a single script run.


Two formats are supported:

The first allows you to provide a date in days, hours, minutes and seconds.

days.hours:minutes: seconds

1 day, 3 hours, 15 min can be written as follows:

ActualDuration = "1.03:15:00" 

The second format allows you provide a more readable date specifying optional values for weeks, days, hours & minutes.

1 week, 2 days, 1 hour, 30 minutes can be written as follows:

ActualDuration = "1 week, 2 days, 1 hour, 30 minutes"

Or in the shorthand form (familiar to Jira/JQL users):

ActualDuration = "1w, 2d, 1h, 30m"

To find all runs where the the actual duration is within a range e.g.( 1-4 days):

ActualDuration >= "1 day" AND ActualDuration <= "4 days"

Alternatively, you can use the short hand "range" syntax:

ActualDuration IN ["1 day", "4 days"]

Note: Because dates can contain hours, minutes and seconds components, testing for date equality may not match as you would expect, It is suggested that you use Date Ranges for matching values where you are not sure of the exact time component.

Supported Operators

=, <, >, <=, >=, IN, !=, NOT IN, IS, IS NOT

Supported Indexes

Entity, Run

Supported Types

  • AgileRun
  • AutomatedTestAssignment
  • AutomatedTestRun
  • ScriptRun
  • TestScriptAssignment

Supported Features

AggregationYes (TimeSpan)

  • No labels