No match found for functions and table functions

When functions or table functions are written in lower cases - no match found error can occur:

Example for no match found

select aux.asissuekey(i.ID) ID1, i.summary
from issues i
limit 10

As a workaround - write the function name in upper cases:

Workaround

select aux.ASISSUEKEY(i.ID) ID1, i.summary
from issues i
limit 10

Same named columns return only one set of values

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:

Same name, same values presented

select jql.ID, CI.ID
from table(AUX.JQL('ID,issuekey,', 'type = bug')) jql 
join core.issuelinks CIL on CIL.destination = jql.ID
join core.issues CI on CI.ID = CIL.source

jql.ID and CI.ID will return the same column where CI.ID should be the source ID.

As a workaround use aliasing:

Same name, same values presented

select jql.ID as jqlid, CI.ID
from table(AUX.JQL('ID,issuekey,', 'type = bug')) jql 
join core.issuelinks CIL on CIL.destination = jql.ID
join core.issues CI on CI.ID = CIL.source

H2 driver bundled in JIRA

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

Browser not supported