Jira Database Values Plugin Questions

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Jira Database Values Plugin Questions

forums-5
Hello,
I have two questions related to implementation of the jira database values plugin:

1. In the plugin [documentation|https://studio.plugins.atlassian.com/wiki/display/JDVP/JIRA+Database+Values+Plugin?focusedCommentId=34013227#JIRADatabaseValuesPlugin-Dependingontheproject] , the author describes how to make the results of the query depend on the actual project being used with the following syntax:

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

I would like to make the results of my query depend on the actual issue being used, rather than project -- is it as simple as replacing '${jira.project.key}' with '${jira.issue.key}'?

2.  For any given issue, the query I am using will return a single record.  As such, I'd like that value to be automatically populated in my custom field.  When I go to edit the issue, the value appears in the drop-down list, but the default is "none".  Is it possible to default the value, rather than having to explicitly select the value from the drop-down list?

Thanks in advance for any help you can offer!!

-Marshall
--
Post by m_t - online at:
http://forums.atlassian.com/thread.jspa?forumID=46&threadID=47116
_______________________________________________
Jira-user mailing list
[hidden email]
To unsubscribe or change your options visit this page:
http://lists.atlassian.com/mailman/listinfo/jira-user
Reply | Threaded
Open this post in threaded view
|

Re: Jira Database Values Plugin Questions

Ankur
This post has NOT been accepted by the mailing list yet.
Hi Marshall,

did you get any solution to show values based on a jira issue {jira.issue.key} instead of project key {jira.project.key}

thanks,
ankur