Can't see the values in the JDVP custom field when using AJAX-style input field

Jason Plumhoff
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.
June 2, 2013

I was able to install and configure the Jira Database Values Plugin without significant issues. I set up the properties file to use a dropdown style input field, and was able to see all my database results as expected. However, if I switch to the AJAX style input field, no results are shown... it just appears to be a text input field.

For testing, I turned on debugging and opened a ticket. Here's what appeared in the log:

2013-06-03 08:05:11,992 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Setting jql queries: {}
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Got 0 substitutions in map
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] sql query after substitutions: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Got 0 substitutions in map
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] sql query after substitutions: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] No project cache for InternalDefaultProjectKey
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] Got 0 substitutions in map
2013-06-03 08:05:12,039 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [plugin.databasevalues.config.DatabaseValuesCFParameters] sql query after substitutions: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,149 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] SQL query: select PartNum, CAST(PartDescription as varchar(255)) from Part where Company = 'ABC'
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] Query returned 67843 rows
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] Showing first 5 records for debugging:
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=0, values={0=0000477026401, 1=PCB 96}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=1, values={0=0000688364000, 1=SSCRN: RETRO-FIT COMPUTER,REAR PANEL}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=2, values={0=0000879504000, 1=UTIL DIAG: SINGLE CHAMBER}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=3, values={0=030-070, 1=Keyboard holder}]
2013-06-03 08:05:12,695 http-bio-8080-exec-7 DEBUG ...<snip>... /secure/QuickCreateIssue!default.jspa [jira.plugin.databasevalues.DatabaseRowCache] DatabaseRow[nr=4, values={0=030-091, 1=Adaptor}]

4 answers

1 accepted

0 votes
Answer accepted
Jason Plumhoff
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.
July 14, 2013
Just to close the question... Since I never got an answer, I ended up uninstalling and going with the Kepler plugin.
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

This issue was fixed in JDVP version 3.1

0 votes
Matt Doar
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.
June 28, 2013
0 votes
Steve Syrett June 13, 2013

For what it's worth, I think I'm experiencing the same thing, but it started happening when I updated to Jira 6 and the latest version of the plugin. Ajax style shows me the search icon, but I never see any data. I enabled logging of the plugin and it shows the data coming back from the database in the "Returning JSON" section, so I know it is filtering and pulling back the data. I tried it in chrome, IE and firefox thinking it may be a browser issue, but same result. Then I switched to the combobox edit.type and it works fine.

Jason Plumhoff
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.
June 15, 2013
Thanks for responding. In the end, I just gave up and went with the Kepler plugin. It worked out of the box.
Mikhail Khrustalev August 18, 2013

Is there any ather way to solve this issue using JDVP? Kepler plugin unfortunately has very poor configuration parameters. And ... it is really different from JDVP.

Suggest an answer

Log in or Sign up to answer