Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Can JQL reference a lookup table or array of information?

GREG DORNOFF October 15, 2021

I'm looking to have information stored in a central location such as a look up table or array and reference as needed in JQL statements.  Does anyone know if this functionality is available?

2 answers

0 votes
Rob Horan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 15, 2021

You might be able to get what you're looking for using Lookup Manager for Jira

 

https://marketplace.atlassian.com/apps/1214700/lookup-manager?tab=overview&hosting=cloud

0 votes
Trudy Claspill
Community Champion
October 15, 2021

Can you elaborate on your scenario?

To clarify, are you trying to merge Jira search results with search results from the external source? Or are you trying to use data from the external source as criteria in your JQL that will search Jira issues?

There is not native functionality in Jira to support this.

Concerning the first options of marrying results from the external source with results from Jira, I found this blog post:

https://www.adaptavist.com/blog/connect-jira-to-external-and-local-databases-using-scriptrunner

Joshua Sneed Contegix
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 15, 2021

Seconded, Greg. Clarification is needed.
Jira stores information in a central location (database), where you can look at arrays of data (issues), and is the facilitator for JQL. Maybe start here? Cheers!

Suggest an answer

Log in or Sign up to answer