How to use
...
dynamic query on a database custom field in an issue
The following steps will guide you on how to use the auto complete on an issue for a dynamic query to retrieve values for a database custom field, based on the values of other custom fields :
- Check in the administration page that you have a dynamic sql.
...
- Let's change the values now, so go directly to the fields Published and Not published, special created for this example. These fields have the id: customfield_11901(Not publichedpublished) and customfield_11900(Published). These are simple jira custom fields, of type "Text Field (< 255 characters)".
- Let's type in first "jjupin" for Published and try to fill in the second value for Not published. At this time, the values for Product Name and Product Id are dynamically changed depending on the value of the field Published as long as Not published.
...
- On selection, the child databse custom field is automatically filled in with the id of the selected product.
Note Note: Every database custom field has a default value: blank, displayed in a the field of type Select List as "None".
- To see the results, save the issue and go to the details:
| Info |
|---|
In a similar way, the auto complete dynamic query is used to retrieve values for other operation a database custom field in a select list. Database custom fields can be used also in other operations on issues. |