Date: Fri, 29 Mar 2024 08:14:19 +0000 (UTC) Message-ID: <1616264264.11405.1711700059616@catch-kbase-p> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_11404_331107738.1711700059615" ------=_Part_11404_331107738.1711700059615 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
ActualDuration is the time that it takes to complete a single script run= .
Two formats are supported:
The first allows you to provide a date in days, hours, minutes and secon= ds.
days.h= ours:minutes: seconds
1 day, 3 hours, 15 min can be written as follows:
Actual= Duration =3D "1.03:15:00"=20
The second format allows you provide a more readable date specifying opt= ional values for weeks, days, hours & minutes.
1 week, 2 days, 1 hour, 30 minutes can be written as follows:
Actual= Duration =3D "1 week, 2 days, 1 hour, 30 minutes"
Or in the shorthand form (familiar to Jira/JQL users):
Actual= Duration =3D "1w, 2d, 1h, 30m"
To find all runs where the the actual duration is within a range e.g.( 1= -4 days):
Actual= Duration >=3D "1 day" AND ActualDuration <=3D "4 days"
Alternatively, you can use the short hand "range" syntax:
Actual= Duration IN ["1 day", "4 days"]
Note: Because dates can contain hours, minutes and seconds components, t= esting 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.
=3D, <, >, <=3D, >=3D, IN, !=3D, NOT IN,= IS, IS NOT
Feature | Supported? |
---|---|
Aggregation | Yes (TimeSpan) |
Sortable | Yes |
Sub-selects | No |