Schema AUX

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