Since the 7.17.0 version, the sql function requires a query ID ad the first parameter. It is no longer possible to run an arbitrary query from the Issue Navigator: only trusted users can write and save queries to get a Query ID
It also supports parameters now...
sql(#ID, parameters,...)
About the custom JQLs
- It allows trusted users to build a catalog of parametrizable JQL functions shareable with the rest of the organization.
- It allows you to take the control of how the JQL functions work as opposed to the opacity of the JQL functions provided by most of the apps available from the Atlassian Marketplace
- The result is standard JQL functions that run in the context of the calling user honoring Jira permissions at the core level to enrich your Jira reporting capabilities.
Example: Get the issues with a given number of comments
...