Introduction
Atlassian imposes limitations on how ScriptRunner JQL functions can integrate with their infrastructure.
With ScriptRunner Enhanced Search, users can utilize JQL functions and save them as filters for use in Atlassian's JQL search.
This means that you will be able to use it with
...
TISSUE Cloud!
Background
To give a comprehensive background, users can refer to Atlassian’s example of how SQL joins works.
Example
Table 1
Key | Summary | Linked Issue |
---|---|---|
TASK-1 | To perform UAT | Subtasks-1 |
TASK-2 | To scan for bugs | Subtasks-2 |
Table 2
Key | Summary | Linked Issue |
---|---|---|
TASK-2 | To scan for bugs | Subtasks-2 |
TASK-3 | To deploy to production | |
TASK-4 | To standby for issues |
...
Subtasks-2 |
How the tables will look in TISSUE gadget and ScriptRunner’s Enhanced Search
TISSUE Gadget is configured to work like a 'Left Join,' which means that all rows from the left table (Table 1) will be displayed, even if there is no matching value in the right table (Table 2).
Any missing data from the right table will show as empty values.
Left Join (Used by TISSUE gadget)
Key | Summary | Linked Issue |
---|---|---|
TASK-1 | To perform UAT | Subtasks-1 |
TASK-2 | To scan for bugs | Subtasks-2 |
TASK-4 | To standby for issues | Subtasks-2 |
TASK-3 | To deploy to production |
ScriptRunner’s Enhanced Search, using an 'Inner Join,' will only display rows where there is a match between the two tables. If there are no matching records, those rows will be excluded from the result, meaning rows with empty values won't be shown
Inner Join (Possible through the use of ScriptRunner’s Enhanced Search)
Key | Summary | Linked Issue |
---|---|---|
TASK-1 | To perform UAT | Subtasks-1 |
TASK-2 | To scan for bugs | Subtasks-2 |
TASK-4 | To standby for issues | Subtasks-2 |
Steps to achieve Inner Join
Head to ScriptRunner Enhanced Search
Enter your JQL
...
Check that the issues displayed are what you expect
...
Save JQL as a filter
...
Update the filter options as required
Use the new filter in
...
TISSUE by modifying the JQL
Code Block filter = <"
...
YourCreatedFilterName">
...
You will be able to see the same results shown in Step 3 in your
...
TISSUE Gadget
...
Before using Enhanced Search | After using Enhanced Search |
---|---|