Visual query builder is represented with a list of tables that contain Jira.
The icon for SQL Cloud Query Builder is situated below the Query Console:
Clicking on the query builder icon opens a new window with a working space, where you can build query:
Each table contains a legend inside. Clicking on it you will see the description:
The primary Key is the required field.
You can insert or item ID or JQL (depending on what table you choose).
Here is the list of steps to build a query:
Choose a table that you want to execute by clicking on it
!!! JQL field: Please pay attention that single quotes '' are already taken into account
2. Select columns that you want to have in your final table by ticking the check box
3. Each column that is linked to another table has a “plus” sign on the right. Clicking on, it will open a linked table. Select columns from the linked tables by clicking on them.
4. Run your query by clicking on the “run” button
5. In the field below the selected tables will appear preview of your built table. If the result serves you - close the window of the Query builder, and in the dialog window select “Copy and Exit”. It will copy your query to the Console window where you will get all results.
6. It will bring you to the Console window where you need to click on the “run” button to execute the query.
