Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Does Jira have the ability to pull data from a table?

Can JIRA perform a lookup function to pull information out of a table?
For example, if we provided JIRA a table with data values in multiple columns for making a burger - bun type, condiments, packaging, employee - and we asked it to give us the employee value associated with sesame seed bun, ketchup, and cardboard box...could it give us the associated employee name listed in the table and insert the value into a user field?
Real world ex: we have client name, client#, teams, and products...based on a number of combinations, if a task is entered via a form and the values = clientABC, #1234, team falcons, product research THEN assign task to Michael J. 
The assignee field (or maybe another field) would pull from the table to extract that user

1 answer

1 accepted

1 vote
Answer accepted
Kai Sören Becker
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.
Mar 30, 2023

Hi @Trevor Overstreet 

I've read your text twice but I actually have no idea what you are trying to achieve.

Out of the box, there is no option for Jira Cloud to pull data from a database.
Therefore you would need to use an app like Elements Connect

First point:

Have a reference data table (attached) with multiple data point and columns. Ideally pulled via API from another system so its always updated or stored in Jira and manually updated (least desired)


Be able to create automation rules using this data table to reference assignees and automatically assign issues based on the grid in the data table. So when a task is submitted via an intake form and it answers which Client, Department, Product then it auto assigns to that person. See attachment and hope this helps.

We can not set up these rules manually bc there would be 100+ rules

This app you referenced may work if we can use it for automation


Screen Shot 2023-03-30 at 4.06.52 PM.png

Laura Campbell _Elements_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Mar 31, 2023

Thanks for the mention @Kai Sören Becker !

@Trevor Overstreet You should be able to set up your use case by adding Elements Connect connected items to your JSM request, and then using Automation to take the assignee from your datasource and set it in the issue.

To get an idea of how this could work, check out this tutorial of querying Okta to get the reporter's manager and set them as the approver:

You mention that your data is available via API; you'll want to check the authentication required. For information, authorization grant code flow will be available very shortly (in addition to the currently supported API authentication methods).

If you have questions about setting up your use case, our Product Manager would be happy to talk with you. You can book a call here.

Kai Sören Becker
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.
Mar 31, 2023

@Trevor Overstreet by default there is no option to store such data in Jira. So this data should be made accessible via app or you could use Assets to store this information. But therefore an upgrade to your Jira plan would be necessary.

Thank you both @Kai Sören Becker @Laura Campbell _Elements_  for the suggestions and documentation! I will certainly review Elements Connect in more detail. We haven't created the API yet but ideally this data would feed from Gainsight into Jira. 

Suggest an answer

Log in or Sign up to answer
Site Admin
AUG Leaders

Atlassian Community Events