/
To get started

To get started

As you might know all data in Jira is stored in numerous tables. So to be able to create complicated tables or execute any data from Jira in table format you gonna need to connect different Tables, columns and registers (fields) one with another. To find out what tables does you Jira instance has and what columns contain each table you will need these two queries:

  1. Show all tables

    show tables

 

 

2. Show columns of selected table

show columns from ISSUE

Insert a query selecting a name of a table that you are interested in

 

 

Related content

ISSUE TYPE ID
ISSUE TYPE ID
Read with this
Built-in dynamic tables, column constraints and full scans
Built-in dynamic tables, column constraints and full scans
Read with this
STATUS ID
Read with this
USER ID
Read with this