Forums

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

Use values of jira fields in the query (database values plugin)

Olga Mendscheritski May 30, 2013

I use the database values plugin to retrieve some additional information about the customer based on the reporter. There is a following example in the documentation:

sql.query=select id, firstname, lastname, city, country from customer where jira_key like '${jira.project.key}'

It seems like only jira.project.key or jira.user will be substituted with real values. Can I access another field values in the query?

Thank you very much!

 

1 answer

0 votes
Wim Deblauwe
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.
August 13, 2015

No other values are possible.

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, jira service management, jsm webinar, ai in jsm, opsgenie integration, incident management, virtual agent, atlassian intelligence, ai-powered service desk, it operations, atlassian learning, service management webinar, team '25 recap

What’s new in Jira Service Management 🤔

Discover how Atlassian is revolutionizing service management with cutting-edge solutions for AI-powered support, HR Service Management, or DevOps connectivity.

Register here ⬇️
AUG Leaders

Atlassian Community Events