Field: AccumulatedActualDuration
Description
The AccumulatedActualDuration is the total actual time to execute a script across all runs.
Examples
Two formats are supported:
The first allows you to provide a date in days, hours, minutes and seconds.
Code Block |
---|
|
days.hours:minutes: seconds
|
1 day, 3 hours, 15 mins can be written as follows:
Code Block |
---|
|
AccumulatedActualDuration = "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:
Code Block |
---|
|
AccumulatedActualDuration = "1 week, 2 days, 1 hour, 30 minutes"
|
Or in the shorthand form (familiar to JIRA/JQL users):
Code Block |
---|
|
AccumulatedActualDuration = "1w, 2d, 1h, 30m"
|
To find all runs where the the actual duration is within a range e.g.( 1-4 days):
Code Block |
---|
|
AccumulatedActualDuration >= "1 day" AND AccumulatedActualDuration <= "4 days"
|
Alternatively, you can use the short hand "range" syntax:
Code Block |
---|
|
AccumulatedActualDuration 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
Feature | Supported? |
---|
Aggregation | Yes (TimeSpan) |
Sortable | Yes |
Sub-selects | No |