Lookup Manager
Breadcrumbs

Lookup Manager

OOO Banner.png


Introduction


The Lookup Manager Plugin provides the capability to set a field based on the value of another field via lookup tables.
It works similarly like the Excel's vLookup function. Jira admins can define multiple lookup tables and workflow post functions to perform the point-in-time lookups.

Besides that, the tables can also be published and viewed by authorised users like a directory.

Getting Started


Use Cases


The Lookup Manager Plugin will be useful in the following possible scenarios

  • Route the request for the next person in the workflowSet the manager custom field based on the reporter fieldSet the assignee field (person in charge) based on the selected system custom field

  • Select the priority based on the issue type or reporter

  • Set the group to be notified based on the selected system custom field

  • Set the issue security based on the issue type

  • Set the customer's details (company, phone, address) based on the user ID

  • Set the staff's info based on their user ID (Useful when LDAP integration is not possible)

  • Set a customer facing field value based on the internal field used by the Jira ServiceDesk agents

Benefits of the plugin


  • Easy to use/visualise with a mapping table

  • Centralised instead of spreading across the individual workflows

  • Mapping is for the point in time. i.e. Updating the lookup table values will not affected those issues that have been looked up

Key features


Set the assignee or other fields automatically with a lookup table

  • Automate the routing of requests to assignees/approvers based on a selected field (e.g. system, department, country, etc).

  • It can also be used to set other fields

Highlight_Routing.png


Manage the lookup tables directly within Jira

  • Can define multiple lookup tables for various purposes

Highlight_Maintain.png


Smart handling when the lookup value cannot be found

  • Able to select various lookup optionDefault to a value Stop Current Action Skip and Continue

Highlight_Smart Lookup.png


Integrated with Automation For Jira

  • Create new component to update the issue field

Highlight_Automation.png


Integrated with Jira Service Desk

  • Create new action to update the issue field

Highlight_ServiceDesk.png