JIRA Database values plugin new release 1.2

Posted at — Jan 20, 2011

I am very proud on this new release of my jira database values plugin. Not only does it have a bunch of really nice additions (which I am going to explain a bit more in detail here), but there are also a lot of people that have helped this release by providing bug reports, patches, …​

1) JQL Function to search on 'secondary' attributes

I am most proud of this one, because I think it will be really useful to a lot of people. Suppose you link to your customer database and would like to know how many issues are coming from customers in Belgium. This was almost impossible to do before, but with the new dbValuesMatching JQL function, it is a piece of cake:

Customer in dbValuesMatching("Country", "Belgium")

This shows it in action in JIRA 4.2:

selection 015

You can also use not in so search for all customers not in Belgium:

Customer not in dbValuesMatching("Country", "Belgium")

This shows it in action in JIRA 4.2:

selection 016

See Configuration of the JQL function on how you need to set this up.

2) Sort

Sorting works again! I was not aware of it, but it seems that sorting got broken when we upgraded the plugin for JIRA 4. Jenifer Lambert pointed this out and now it works perfectly again.

3) Linking of different database values custom fields

This release allows you link 2 (or more) custom fields. You can then use the selected value of the first custom field in the query to the database for the 2nd custom field. See here for the details.

Thanks to Frédéric Beuserie and Miguel Maldonado for providing a patch for this.

4) Use the jira user in your SQL query

If you want your query to depend on the current logged in user, this new feature makes it possible. This is an example:

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

Thanks to David Corley for providing a patch for this.

5) Nice error message if properties file cannot be found

Previous versions would display something like this if the properties file cannot be found:

selection 006

The new version is a bit friendlier and shows this:

selection 012

6) Log what the database returns

To help with debugging if something goes wrong, the plugin now prints the first 5 records if you enable the DEBUG logging. See here for more info on how to enable logging.

7) Clickable items in the 'Issue Statistics' dashboard gadget

If you use your custom field in a 'Issue Statistics' dashboard gadget, you can now click through on any item to further inspect the issues:

selection 014

Thanks to Cyrille Courtière for providing a patch for this.

Enjoy this new release! Download it from https://plugins.atlassian.com/plugin/details/4969 and please put in a review if you like the plugin.

If you want to be notified in the future about new articles, as well as other interesting things I'm working on, join my mailing list!
I send emails quite infrequently, and will never share your email address with anyone else.