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

How the different join looks like

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

1. Head to ScriptRunner Enhanced Search

   

   
   

2. Enter your JQL to fetch the linked issues

   1. 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")

3. Check that the issues displayed are what you expect

   

4. Save JQL as a filter to use it in TISSUE

   

5. Update the filter options as required

   

6. Use the created filter in TISSUE by using the JQL command below

   Code Block
   filter = <"YourCreatedFilterName">

   

7. You will be able to see the linked issues in your TISSUE gadget without empty values.

Reference

• https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-functions

• https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/jql-keywords

• https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-enhanced-search/scriptrunner-enhanced-search-jql-queries