Allow users to select values from a linked database
The plugin can be configured to use a dropdown or an auto-complete field.
Write custom queries for searching based on values that the plugin links to.
It is possible to sort on the values returned from your linked database.
This plugin for Jira is a custom field that allows you to connect to an external database and fetch some values from there. After adding this custom field to an issue edit screen, you can select one of those values so it will be associated with the current issue.
You can choose how the values are rendered for viewing, editing and searching independently. For the editing, you can use a combobox (single select or cascading select) or an AJAX-style input field. Internally, the plugin will store only the primary key of the item you have selected, so you can safely edit things in your database, as long as you keep the primary key constant.
Privacy and security