Compatibility
From the 7.16.0 version custom, the fields are provided right within the Driver instead of a separate app.
They are very similar but not compatible as the plugin ikey changed and Jira is unable to find the older custom fields. You have to migrate the old custom fields to their counterparts created by hand and configured in an equivalent way (the SQL+JQL can be copied & pasted for reusing)
Three new custom field types are supported:
- Value: shows the first column of the first record returned.
- Table: shows multiple values result from a query as a table. The table column names are taken from the result set column names.
- Progress bar: shows a result value of a query as a progress bar.
and three variables
- ${id}
- ${key}
- ${project}
are supported for substitution in the queries in realtime:
They are case sensitive and replaced by their respective issue's values at runtime.
Examples:
select * from issues i where i.key = '${key}' |
select * from issues i where i.id = ${id} |
${key} and ${project} variables replaced by a string (varchar) values (i.e: ISSUE-1234), therefore it must be enclosed within single quotes
${id} is replaced by a long (numeric) value (i.e: 10000), therefore it must not be enclosed within single quotes