CelesteCS JQL Extensions plugin extends the standard Atlassian JIRA JQL functionality with a set of functions, which lets one to get sophisticated results with simple jqlx-prefixed function calls. The functions are available to be added to JQL queries as soon as the plugin is installed, no additional configuration is needed.
The power of CelesteCS JQL Extensions plugin is in the ability to effectively use internal JIRA APIs to get exactly what is needed without building huge JQL requests. Plus, the results are retrieved as standard JIRA objects, like Issues and DateTime, so no special filters or reports is needed to process these results.
Cloud version: CelesteCS JQL Extensions is also available for Jira Cloud as a native Forge app that runs entirely on Atlassian infrastructure: your Jira data never leaves Atlassian. The jqlx-prefixed functions work directly in the Jira Cloud issue navigator’s JQL search bar, with no separate integration plug-in to install. 63 of the 66 functions are available on Cloud; the few that are not are marked Datacenter Only on the Functions page.