A user function allows you to define a locally-used function within a formula. User functions can be defined in a similar manner as
local variables:
WITH square(x) = x * x :
square(impactField) / square(storyPoints)
In this example, the user function is given a name ("square") and then used to perform the same calculation on multiple fields. To learn more, see the language reference.
User Functions for Arrays - using the "$" character
When you need to perform an operation on each element in an array, you can use a user function such as the one above, or simplify it using “$” to indicate each element in the array.
worklogs.FILTER($.author = ME())
In this example, the "$" tells Structure to apply "author = ME()" to each element in worklogs - if the author is the current user, it returns true and that worklog will be included in the FILTER results.
This method becomes very powerful when you combine multiple user functions together. To learn more, see the language reference.
Embedded Queries (JQL and S-JQL)You can embed JQL and
Structured JQL queries inside an Expr formula, using a construct similar to
Aggregate Functions. The result will be a boolean value:
1
(true) if the current row matches the query0
(false) otherwise
For example:
// Collect total story points from all sub-issues assigned to members of Team2 group, unless the stories are under folder "Special"
SUM {
IF JQL { assignee in membersOf("Team2") } :
IF NOT SJQL { descendant of folder("Special") } :
storyPoints
}