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

Entity, Run

Supported Types

  • AgileRun
  • AutomatedTestAssignment
  • AutomatedTestRun
  • Requirement
  • ScriptRun
  • TestScript
  • TestScriptAssignment

Supported Features

FeatureSupported?
AggregationYes (TimeSpan)
SortableYes
Sub-selectsNo

  • No labels