Introduction
The Tissue Gadget use the issues from the primary set of issues to join up with linked issues from the secondary set of issues.
It will display blank values when there is no linked issues. This is similar to a Left Join in database terminology.
In some cases, the users may only want to display rows which have matching linked issues.
The Inner Join will skip those issues in the primary set of issues which does not have linked issues
Example
Primary Set of Issues (Epics)
Key | Epic Name | Linked Issue |
---|---|---|
TIS-100 | TIS bug fix | CS-18 |
TIS-99 | TIS feature improvement | CS-10 |
TIS-98 | TIS UI improvement | CS-15 |
TIS-20 | TIS performance fix |
Secondary Set of Issues (Feature request to be linked to epics)
Key | Summary | Status |
---|---|---|
CS-18 | TypeError when the issue data does not contain issuelinks field | Pending Dev |
CS-15 | To allow multiple link types for each level | Pending Dev |
CS-10 | To unescape the title which contains special characters | Pending Dev |
How the different join looks like
Left Join (Default)
Key | Summary | Linked Issue | Status |
---|---|---|---|
TIS-100 | TIS bug fix | CS-18 | Pending Dev |
TIS-99 | TIS feature improvement | CS-10 | Pending Dev |
TIS-98 | TIS UI improvement | CS-15 | Pending Dev |
TIS-20 | TIS performance fix |
Inner Join
Key | Summary | Linked Issue | Status |
---|---|---|---|
TIS-100 | TIS bug fix | CS-18 | Pending Dev |
TIS-99 | TIS feature improvement | CS-10 | Pending Dev |
TIS-98 | TIS UI improvement | CS-15 | Pending Dev |
Gadget View
Left Join | Inner Join |
---|---|
Steps to achieve Inner Join
It is possible to use ScriptRunner Enhanced Search to filter the primary set of
Head to ScriptRunner Enhanced Search
Enter your JQL to fetch the linked issues
E.g. Fetching linked issues are has the status Awaiting Dev and Link Issue Type = is related to
Code Block issueFunction in linkedIssuesOf(status in ("Awaiting Dev"), "is related to")
Check that the issues displayed are what you expect
Save JQL as a filter to use it in TISSUE
Update the filter options as required
Use the created filter in TISSUE by using the JQL command below
Code Block filter = <"YourCreatedFilterName">
You will be able to see the linked issues in your TISSUE gadget without empty values.