Lookup Manager
Lookup Manager
Breadcrumbs

Lookup multiple columns in Automation for Jira (New)

Goal

This section shows the instructions to lookup multiple columns in Automation for Jira during issue creation.

Pre-requisites

✔️ Install the Automation for Jira - Server
✔️Create a lookup table
✔️ Jira Administrators permission to create / edit Automation Component

Demonstration

The Lookup Manager will compare the value of two issue fields with two columns from Plugin Management Table:

  • Issue Type field and Type column

  • Application Name field and Application 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 System < Automation rules. You also can type gg then Automation rules

AutomationForJira_Step0.png

2. After created Trigger Component, select New action

multipleLookup_Automation_created.png


3. Search Update Issue Field (Lookup Manager) in the search field. You also can find Update Issue Field (Lookup Manager) under the Issue actions

multipleLookup_Automation_action.png

4. Click Add column to compare and update the fields

multipleLookup_Automation_config.png

5. Provide a name for the automation and Turn it on

multipleLookup_Automation_publish.png