Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
Learn how to connect and manage your connected Atlassian data and external data.
Create or build off of dashboard templates to start analyzing your Atlassian data.
Learn how to create insightful charts and dashboards with your organization’s data.
Learn how to use Visual SQL to create queries and transform data for making charts.
Need feedback on data? Learn how to share charts and dashboards with teammates so they can leave comments.
Learn how to grant resource access to the people who need it.
Learn how to manage your workspace and how to monitor your workspace activity.
In SQL, a JOIN clause brings together the rows from two or more tables into a single query result set. A JOIN clause could have one or more joins, which are direct connections between two tables using foreign key relationships defined in the schema. Learn more about foreign keys.
JOIN clauses and the types of joins that you use can affect the data that are returned from your queries. Learn more about join types.
When using visual mode, you can see the query’s join path, which is a visual representation of its JOIN clause.
The example below shows a join path to connect the “Issue” and “Project fix version” tables. This join path involves two joins:
a join between the “Issue” table and the “Issue affected version mapping” table using the “Issue ID” columns
a join between the “Issue affected version mapping” table and the “Project fix version” table using the “Version ID” columns
Edit join path
It’s possible to have more than one way to join tables together. If your visual mode query has more than one join to choose from, you’ll see a “More options” label appear in the join path panel that indicates you can select different joins to use.
To select a different join in the join path:
Select Join path. A pop-up will appear.
Select a column name or line of an alternative join. The line will become blue to indicate it’s currently selected.
Select Run query to run your query with the updated join path.
Join path diagram
When you edit a join path, the pop-up will contain an interactive diagram that shows the following information:
Selected join - A currently selected join between two tables in the join path
Alternative join - Another join option to connect two tables together in the join path
Intermediate table - A helper table used to connect two tables that don’t have direct connections between them
Complex join paths
There are two reasons why you may not be able to edit a join path in visual mode:
the join path involves more than two joins
there are too many alternative joins to choose from
In these cases, you’ll need to switch to SQL mode and edit the JOIN clauses directly in the SQL query.
Changes you make in SQL mode don’t reflect in visual mode.
Was this helpful?