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

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

This widget could not be displayed.
Just to close the question... Since I never got an answer, I ended up uninstalling and going with the Kepler plugin.
This widget could not be displayed.

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.

Thanks for responding. In the end, I just gave up and went with the Kepler plugin. It worked out of the box.

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.

This widget could not be displayed.

This issue was fixed in JDVP version 3.1

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted yesterday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

82 views 1 0
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