This schema provides various JIRA related helping functions and tables.

Fuction AUX.PATH
Functions converts any field given in a parameter call with XPATH expression.
Function ASDURATION
This function converts database duration (see estimate/timestimate etc columns - these fields are simple integer type) to human readable form known from JIRA.
Function ASICON
This functions "casts" any URL like value to an object which builtin navigator will show as a link to an image.
Function ASISSUEKEY
Functions converts issue id to its appropriate key.
Function ASLINK
This functions "casts" any URL like value to an object which builtin navigator will show as a link.
Function ASPROJECTKEY
This function converts project id from to its key. With this function you can limit joins to Table PROJECTS in your query for presentation purposes.
Function ASPROJECTNAME
This function converts project id from to its name. With this function you can limit joins to Table PROJECTS in your query for presentation purposes.
Function GETFIELD
This function returns the value of issue field, regular one or custom field.
Function JQL
This function enables power of JQL in you SQL queries. It returns the data in table format just like the builtin JQL navigator, so you can use it in your SQL queries.
Function LOGGEDINUSER
Returns id of a current logged in user which is you .
Function AUX.ASTEXT
Function converts any input parameter into readable text. This is useful for a simple casting java objects to text.
Following parameters are obligatory:
Type
Notes
Function FORMAT
Function returns the formatted string by given format and arguments.
Function takes following parameters:
Type
Function AUX.ASUSERDISPLAYNAME
Function converts user key pararemet into user’s display name.
Following parameter is obligatory:
Type