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.
Code Block |
---|
|
days.hours:minutes:seconds
|
1 day, 3 hours, 15 min can be written as follows:
Code Block |
---|
|
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:
Code Block |
---|
|
EstimatedDuration = "1 week, 2 days, 1 hour & 30 minutes"
|
Or in the shorthand form (familiar to Jira/JQL users):
Code Block |
---|
|
EstimatedDuration = "1w 2d 1h 30m"
|
To find all runs where the the actual duration is within a range e.g.( 1-4 days):
Code Block |
---|
|
EstimatedDuration >= "1 day" AND EstimatedDuration <= "4 days"
|
Alternatively, you can use the short hand "range" syntax:
Code Block |
---|
|
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
Entity, Run
Supported Types
- AgileRun
- AutomatedTestAssignment
- AutomatedTestRun
- Requirement
- ScriptRun
- TestScript
- TestScriptAssignment
Supported Features
Feature | Supported? |
---|
Aggregation | Yes (TimeSpan) |
Sortable | Yes |
Sub-selects | No |