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 cloud certification, managing jira projects, jira project administration, jira cloud exam, atlassian certification, agile project management, jira workflows, jira permissions, jira training, jira cloud skills, atlassian learning

Become a Certified Jira Service Project Expert 🦸🏻‍♂️

Validate your expertise in managing Jira Service Projects for Cloud. Master configuration, optimize workflows, and manage users seamlessly. Earn global 🗺️ recognition and advance your career as a trusted Jira Service management expert.

Get Certified! ✍️
AUG Leaders

Atlassian Community Events