How to get MySQL query data into a issue field?

How can I make a MySQL query to fetch some data from the database and display it in issue fields? 
Can I make a jira filter with that SQL query? 
For e.g. There is a table in our company database which has a column in it, I want to get that column and make it appear in jira issues?

Thanks in advance.

sD

3 answers

1 accepted

1 vote
Tayyab Bashir Community Champion Oct 24, 2017

Hi, 

You cannot directly make SQL queries to Database within JIRA using JQL filters.

You can look into Power Database Fields Plugin and nFeed Plugin to connect to a DB, fetch data from there and display into a custom field. 

For e.g. The Power Database Field plugin gives you additional customfields and one of them is Database Custom Field. You can create a customfield of this type, and configure it to your db and fetch relevant data. 

Add the The table grid editor as an additional option.

 

Francis

Power Database Fields looks like a free addon so I probably will think about using that

Many thanks. 

1 vote

You need code to do that.  Something to read your data and display it as a field.

There are "database fields" add-ons in the marketplace which allow you to draw their options from a database and to display SQL queries too, it's worth a look at those, rather than writing your own.

A better option may be to use something like ScriptRunner to provide a "scripted field" that can pull the data you need, if it's read only.

Translating a SQL query into a Jira filter is a non-starter.  The database behind Jira is a data store and is not designed for anything like reporting.  But if you implement your display as a field, then yes, you can search that in JQL queries.

Power Database Fields looks like a free addon so I probably will think about using that.

ScriptRun looks good too but Its quite expensive for just one operation :(
I have to actually connect to an external Database (Not JIRA DB). So i think i would need addon for it.

Thankyou for your help

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,296 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot