SQL functions are functions that operate on data (columns) to deal with data types conversions, extract text strings and dates, formatting and much more!

You can see some of them in action from SQL built-in console in Jira: Click on the Examples link, then on the Tricks link and Run it.

Native Functions

SQL+JQL is really H2 therefore you can use almost all the H2 functions described in the product documentation:

http://www.h2database.com/html/functions.html

Custom Functions

SQL+JQL also supports some built-in functions to deal with specific Jira data and formats.

• Create HTTP links to Jira pages
• External Link
• Custom Field Cascade
• User functions
• User Groups Functions
• Wiki markup, HTML & texts, Renderers....
• Cached connections
• Formatting natural and work time