Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Excerpt | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Fixed values
Variable values (field values)Numeric values of Number, Date, Date-Time and Priority data type fields can be inserted in expressions with following notation {...somefield}, e.g., use
Math Functions
Date-Time FunctionsFields of type Date and Date-Time contain a numeric value with the milliseconds elapsed since January 1, 1970, 00:00:00 GMT. We usually need to get significative numbers from this numeric value, like YEAR, MONTH, DAY, HOUR, MINUTE, etc. To achieve this, Automation Toolbox for Jira provides a comprehensive set of functions, most of them with TIMEZONE as input argument, since any significative number relative to a timestamp depends on the timezone.
colour | Blue |
Returns the week of the year of the date-time t in a certain time_zone as
Example: Example: Example: dayOfTheYear(number t, timeZone time_zone) Available since version 1.1.0
Returns the day of the year of date-time t in a certain time_zone as
Example: stringToDate(string s, timeZone time_zone) |
stringToDate(string s, string date_time_pattern ) |
Returns a
Example: stringToDate(string s, string date_time_pattern , string language , string country ) |
Returns a
Example: formatDuration(number duration) |
Returns a
Example: shortFormatDuration(number duration) |
Returns a
Example: formatWorkDuration(number duration) |
Returns a
formatDuration() but using the workday and workweek defined at time tracking configuration , instead of 24 hours per day and 7 days per week.Example: shortFormatWorkDuration(number duration) |
Returns a
shortFormatDuration() but using the workday and workweek defined at time tracking configuration , instead of 24 hours per day and 7 days per week.Example: timeZone(string timeZone_name) |
Returns the timeZone whose name is represented by string timeZone_name. This function is useful to obtain a timeZone from a string, like the value of a Project Properties. Example: timeInValue(string field field, boolean expression predicate) Available since version 1.1.0
Returns the
^% .Example: Example: Example: timeInValue(%{00017}, ^% in ["Critical", "High"]) returns the number of milliseconds the field priority (field code %{00017}) of the current issue has had a value of Critical or High. timeInValue(number field field, boolean expression predicate) Available since version 1.1.0
Returns the
^ .Example: Example: Example: timeInValue(string field field, issue list issues, boolean expression predicate) Available since version 1.1.0
Returns the sum of milliseconds a string field with code %{nnnnn} has had a value satisfying a boolean expression predicate in distinct issues as
^% .Example: Example: Example: timeInValue(number field field, issue list issues, boolean expression predicate) Available since version 1.1.0
Returns the sum of milliseconds a number or date-time field with code {nnnnn} has had a value satisfying a boolean expression predicate in distinct issues as
^ .Example: Example: Example: timeInValue(string field field, boolean expression predicate, string schedule_name, timeZone time_zone) Available since version 1.1.0
Returns the
^% . The time being calculated by this function is only counted during a defined schedule with name schedule_name for time zone time_zone.Example: Example: Example: timeInValue(number field field, boolean expression predicate, string schedule_name, timeZone time_zone) Available since version 1.1.0
Returns the
^ . The time being calculated by this function is only counted during a defined schedule with name schedule_name for time zone time_zone.Example: Example: Example: timeInValue(string field field,issue list issues, boolean expression predicate, string schedule_name, timeZone time_zone) Available since version 1.1.0
Returns the
^% . The time being calculated by this function is only counted during a defined schedule with name schedule_name for time zone time_zone.Example: Example: Example: timeInValue(number field field, issue list issues, boolean expression predicate, string schedule_name, timeZone time_zone) Available since version 1.1.0
Returns the
^ . The time being calculated by this function is only counted during a defined schedule with name schedule_name for time zone time_zone.Example: Example: Example: fieldChangeTimes(string field field, boolean expression predicate) Available since version 1.1.0
Returns the timestamps as
^0% , and after the change by ^1% . The timestamps are returned as a number list sorted in ascending order.Example: Example: Example: fieldChangeTimes(number field field, boolean expression predicate) Available since version 1.1.0
Returns the timestamps as
^0 , and after the change by ^1 . The timestamps are returned as a number list sorted in ascending order.Example: Example: fieldChangeTimes(string field field, issue list issues, boolean expression predicate) Available since version 1.1.0
Returns the timestamps as
^0% , and after the change by ^1% . The timestamps are returned as a number list containing a sequence of sorted numeric values in ascending order for each parameter issue.Example: Example: Example: fieldChangeTimes(number field field, issue list issues, boolean expression predicate) Available since version 1.1.0
Returns the timestamps as
^0 , and after the change by ^1 . The timestamps are returned as a number list containing a sequence of sorted numeric values in ascending order for each parameter issue.Example: Example: lastFieldChangeTime(string field field) Available since version 1.1.0
Returns the timestamp as
lastFieldChangeTime(%{00000}) returns the timestamp of the last update of an issue's summary (field code {00000})
Time MacrosDate-Time values are numeric values representing the number of milliseconds elapsed since January 1, 1970, 00:00:00 GMT. Macros are aliases for literal / fixed values. A comprehensive set of time macros is provided to make your expressions more readable.
Examples
|
Div | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||||||||
|