Field: EstimatedDuration
Description
EstimatedDuration is a reference field for Requirements and Scripts.
Examples
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:
EstimatedDuration = "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:
EstimatedDuration = "1 week, 2 days, 1 hour & 30 minutes"
Or in the shorthand form (familiar to Jira/JQL users):
EstimatedDuration = "1w 2d 1h 30m"
To find all runs where the the actual duration is within a range e.g.( 1-4 days):
EstimatedDuration >= "1 day" AND EstimatedDuration <= "4 days"
Alternatively, you can use the short hand "range" syntax:
EstimatedDuration IN ["1 day", "4 days"]
Note: Because dates can contain hours, minutes and second 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
Supported Types
- AgileRun
- AutomatedTestAssignment
- AutomatedTestRun
- Requirement
- ScriptRun
- TestScript
- TestScriptAssignment
Supported Features
Feature | Supported? |
---|---|
Aggregation | Yes (TimeSpan) |
Sortable | Yes |
Sub-selects | No |