Is there a way to tie a database query to a combobox in jira?

[Alexandra Topoloaga]

Hi Dave,

Please take a look on [KCF Pro|https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.keplercf-pro/server/overview]. If offers you 6 types of custom fields: single and multi select, with or without autocomplete, radio buttons and checkboxes. The options can be rendered as Strings (by default) or as Issue/Project/User/Group/Component/Version pickers.

From what I understood, you want a KCF Multiple Autocomplete. Check this example: https://confluence.kepler-rominfo.com/display/KCFPRO/KCF+-+Multiple+Autocomplete

Hope this helps,
Alexandra 

[JamieA]

The ScriptRunner functionality for that is https://scriptrunner.adaptavist.com/latest/jira/behaviours-conversions.html

Specifically: https://scriptrunner.adaptavist.com/latest/jira/behaviours-conversions.html#_walkthrough_choose_from_a_database_table

[JamieA]

And it's been tested with tables with tens of millions of options.

[Dave Scheet]

We are connecting our client and program database to JIRA for billing purposes.  We have clients that have over 1000 programs, so a simple drop down isnt user friendly, and there are some users that dont know all of their program names (how they are entered into the db) so, autocomplete has some issues as well.   A combobox would meet these needs perfectly.  Is there a way to create one, either by custom code or a plugin?

We currently have both script runner and database custom fields installed (used in the current implementation)

Here is a sample of what I am looking for

http://dschu012.github.io/jquery-multicombobox/

[Tibor Hegyi _META-INF_]

Yes, there are free and commercial addons available for that:

• Free: https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.databasecf/server/overview
• Free: https://marketplace.atlassian.com/plugins/org.deblauwe.jira.plugin.database-values-plugin/server/overview
• Paid: https://marketplace.atlassian.com/plugins/com.valiantys.jira.plugins.SQLFeed/server/overview

[Tibor Hegyi _META-INF_]

And ScriptRunner for JIRA as always: https://scriptrunner.adaptavist.com/latest/jira/recipes/misc/connecting-to-databases.html

With scripted fields. Though I'm a bit uncertain if a scripted field can display and selection options in a dropdwon

[Dave Scheet]

Do any of these options have a combo box like what is shown in the provided link.

[Tibor Hegyi _META-INF_]

Kepler's Database Custom FIeld and NFeed definitely offer a dropdown with autocomplete renderer. I have used them in the past.

One example is DBCF: https://marketplace-cdn.atlassian.com/files/images/com.keplerrominfo.jira.plugins.databasecf/80b1d9ab-7731-4b83-a32f-ac2ca9b3355d_scaled.png

And NFeed also has an autocomplete element: https://marketplace-cdn.atlassian.com/files/images/com.valiantys.jira.plugins.SQLFeed/65eaf5bd-5f37-4f4b-af29-fd0f3bf465f0.jpeg

[Tibor Hegyi _META-INF_]

Do you need multiple selection as well?