Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

Field: EstimatedLessActualDuration

Description

Estimated Less Actual Duration is a calculated field representing the difference between the estimated time and the actual time it took to execute the script.

Examples

Two formats are supported:

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

Code Block
languagenone
days.hours:minutes: seconds

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

Code Block
languagenone
EstimatedLessActualDuration = "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
languagenone
EstimatedLessActualDuration = "1 week, 2 days, 1 hour, 30 minutes"

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

Code Block
languagenone
EstimatedLessActualDuration = "1w 2d 1h 30m"

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

Code Block
languagenone
EstimatedLessActualDuration >= "1 day" AND EstimatedLessActualDuration <= "4 days"

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

Code Block
languagenone
EstimatedLessActualDuration IN ["1 day", "4 days"]

Find all runs where the actual duration has exceeded the estimated duration (i.e. the value is a negative number of minutes, hours, days):

Code Block
languagenone
EstimatedLessActualDuration < "1m"

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
  • ScriptRun
  • TestScriptAssignment

Supported Features

FeatureSupported?
AggregationYes (TimeSpan)
SortableYes
Sub-selectsNo