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

Open

2. Show columns of selected table

Open