Help Contents
-
Getting Started
-
Installation and Upgrade Guide
-
Administrator Guide
-
User Guide
-
Duette User Guide
-
Searching & TQL
-
Simple Search
-
Advanced Search
-
Testing Query Language (TQL)
-
Aggregation
-
Fields
-
Accumulated Actual Duration
-
Actual Duration
-
Affected Version
-
Agile Runs Count
-
All Packages
-
AllParents
-
Assigned To
-
Assignee
-
Assignment
-
Assignment Id
-
Assignments Count
-
Attachment Count
-
Automated Tests Count
-
Blocked
-
Change Comment
-
Comment
-
Component
-
Created At
-
Created By
-
Description
-
Destination
-
Difficulty
-
Difficulty Level
-
Directly Related To
-
Editor
-
Editors
-
Entity Type
-
Errors
-
Estimated Duration
-
Estimated Less Actual Duration
-
Execution Totals
-
Failed
-
Fields / Organisation
-
Fields / Package
-
Fields / Project
-
Fields / Relationship
-
Fields / Relationships
-
Fields / Relationship Type
-
Fields / Script
-
Finished At
-
Fixed Version
-
Has Agile Runs
-
Has Assignments
-
Has Attachments
-
Has Automated Tests
-
Has Coverage
-
Has Incidents
-
Has Requirements
-
Has Scripts
-
Id
-
Imported At
-
Incident Count
-
In Progress
-
Iterations
-
Key
-
Last Comment
-
Last Synchronized At
-
Last Updated At
-
Last Updated By
-
Name
-
Notes
-
NotRun
-
Number
-
Objective
-
Order Number
-
Parent
-
Parent And This Package
-
Parent Package
-
Passed
-
Post Condition
-
Pre Condition
-
Priority
-
Provides Coverage
-
Query
-
Raised By
-
Related To
-
Related To All Packages
-
Related To All Parents
-
Related To Entity Type
-
Related To Fields
-
Related To Id
-
Related To Organisation
-
Related To Package
-
Related To Parent
-
Related To Priority
-
Related To Project
-
Related To Status
-
Related To Type
-
Relationship Depth
-
Relationship Direction
-
Relationship Id
-
RelationshipTypeKey
-
Remaining Estimate
-
Requirements Count
-
Resolution
-
Run By
-
Run Number
-
Script Id
-
Script Priority
-
Script Status
-
Script Step Count
-
Script Type
-
Skipped
-
Source
-
Started At
-
Status
-
Step Actual Results
-
Step Data
-
Step Description
-
Step Expected Result
-
Step Notes
-
Summary
-
Test
-
Test Id
-
Test Scripts Count
-
Text
-
Ticket Id
-
Ticket Key
-
Ticket Url
-
Total Nodes
-
Total Results
-
Tracker
-
Type
-
Undetermined
-
Version Number
-
Warnings
-
Accumulated Actual Duration
-
Functions
-
Indexes
-
Operators
-
Order By
-
SET
-
TQL For JQL Users
-
Types
-
Values
-
Aggregation
-
Simple Search
-
API
-
Troubleshooting
-
Latest Version of this Documentation
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.
days.hours:minutes: seconds
1 day, 3 hours, 15 min can be written as follows:
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:
EstimatedLessActualDuration = "1 week, 2 days, 1 hour, 30 minutes"
Or in the shorthand form (familiar to Jira/JQL users):
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):
EstimatedLessActualDuration >= "1 day" AND EstimatedLessActualDuration <= "4 days"
Alternatively, you can use the short hand "range" syntax:
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):
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
Supported Types
- AgileRun
- AutomatedTestAssignment
- AutomatedTestRun
- ScriptRun
- TestScriptAssignment
Supported Features
Feature | Supported? |
---|---|
Aggregation | Yes (TimeSpan) |
Sortable | Yes |
Sub-selects | No |