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 (smile).

  • 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