The following field codes are used: - %{issue.cfaaaaa} is the field code for the field Fiscal year.
- %{issue.cfbbbbb} is the field code for the field Department.
The department will be returned in the following format: Value in field "Department" | Value returned by the expression |
---|
Development | DEV | Sales | SAL | Marketing | MAR |
The expression will only grab the first three letters and write them in upper case by using substring() and toUpperCase().
In our case we want the sequenceNumber to be a 3-digit number. Therefore the following expression is used: substring("000", length(projectProperty("sequenceNumber")), 3) |
It takes the length of the sequenceNumber and dynamically adds zeros to fill up the sequenceNumber to a 3-digit number. Example: "sequenceNumber" project property | Added zeros | Output |
---|
1 | 2 | 001 | 10 | 1 | 010 | 100 | 0 | 100 |
The used functions are substring(), length() and projectProperty(). |