It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

Dave Scheet Apr 06, 2016
 

4 answers

1 vote
Alexandra Topoloaga Apr 06, 2016

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 

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 Apr 06, 2016

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

 

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

Do you need multiple selection as well?

0 votes
Dave Scheet Apr 06, 2016

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/

JamieA Apr 06, 2016

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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Next-gen

Introducing subtasks for breaking down work in next-gen projects

Teams break work down in order to help simplify complex tasks. This is often done iteratively, with tasks being broken down into smaller tasks and so on until the work is accurately captured in well-...

1,100 views 13 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you