How to use the autocomplete on an issue (simple query)
Create/Update an issue
Follow the steps below:
- Before using the database custom field of type Autocomplete, please make sure the type of the custom field is Autocomplete in the Kepler Administration Page.
- Go to an issue in JIRA and try to edit it first. The database custom fields will appear like any other custom field. When trying to edit an issue, the sql is executed and the results will be available through autocomplete.
- Try to type the first letter of a possible value and a list of options will appear. From these options one can be selected for the current field. When selecting a value for a main database custom field, the value for the child database custom field is filled in like in the picture below:
Now that the fields are filled in, the issue can be updated with the provided values.
After updating the issue, the values are displayed as details of that issue.
The creation of an issue can be done in a similar way.
Use autocomplete for a transition
The following example involves updating the issue fields when Start Progress is pressed.
This is similar to the update of an issue, still here are some screenshots to explain how to use the database custom fields on transitions.
The value of the field Product Name can be changed to another value like in the screenshot below:
The database child custom field is filled in on selection of the value for the main database custom field. If the button Start Progress is pressed, the values are updated for the database custom fields and the issue goes in the final state of the transition.
For this example it looks like this:
