When functions or table functions are written in lower cases - no match found error can occur:
As a workaround - write the function name in upper cases:
|
If you do a search with a join of a JQL search and a core.issues table or two JQL searches and try to join them (and they have overlapping column names) it will return the first column of that only. For example:
jql.ID and CI.ID will return the same column where CI.ID should be the source ID. As a workaround use aliasing:
|
Smart QL app does not support H2 databases with driver bundled in Jira. You may want to update the driver in your Jira instance with version at least 1.4.197. See http://www.h2database.com/html/download.html |