Goal
This section shows the instructions to configure Workflow Post Function to perform a lookup during issue transition to update issue field.
Pre-requisites
✔️ Create a lookup table
✔️ Jira Administrators permission to create / edit Workflow Post Function
Demonstration
The Lookup Manager use the value in the App field, get the App Management Table to search the App column. If there is a matching row, get the value in the Manager column and then set it in the Assignee field.
...
Configuration steps
1. Go to the workflow you wish to perform a lookup function.
...
6. You should see the following fields
Source Field | The custom field which stores the lookup value to be searched in the lookup table. |
---|---|
Lookup Table | Lookup table which store the data set to be searched |
Search Column | Column in which the lookup value will be searched |
Matched Column | Column in which the matching value will be returned |
Destination Field | Field in which the matching value will be populated in |
Action if No Records Matched |
|
Action if No Value in Source Field |
|
|
|
Default to a value
If no value in source field, the value will be used to search in lookup table
...
7. You can view the summary of the post function
...
8. For this tutorial, you need to remove the “3. Assign the issue to the current user. Please note that the issue will only be assigned to the current user if the current user has the 'Assignable User' permission.”
...
8. Remember to publish the workflow
...
For example, in the scenario, where only critical applications have duty personnel,
|
It can be translated into 2 lookup post functions in the reverse sequence
Initialise the assignee with the System Lead by performing the lookup for the System Lead
Then call the lookup for the Duty Personnel using the selected application. If there is no matching records, skip the update and continue