How to create a filter that show me a issuetype list based from field from other issuetype?

Question

I have a issuetype named SPECIFICATION.

SPECIFICATION has a field named MODULE. When we fill the MODULE, we have 3 options: (M-A, M-B, M-C).

Module is a mandatory field that is filled when create the SPECIFICATION.

-----------------

I have another issuetype named BUG.

When create a BUG,  has a mandatory field that inform the SPECIFICATION that the BUG impact. So, the BUG always has a SPECIFICATION linked.

The BUG dosen't have the module informationm due the BUG has the SPECIFICATION linked, and the SPECIFICATION has a field that inform the MODULE.

----------------

My Doubt:

How to create a filter that show me JUST BUGs that is linked with SPECIFICATION that has MODULE="M-C"?

Alexey Matveev · Answer

Hello,

You can not do it out of the box. You have to use an add-on for it. There are a couple of add-ons which will let you make such a filter. For example, if you are on Jira Server/Data Center you could use Power Scripts add-on. You would need to write a script which would return you the desired results. You script would look like this

string [] keys = selectIssues(argv[0]);
string [] ret;
for(string k in keys) {
   for (string lk in linkedIssues(k)) {
         if (%lk%.issueType == "SPECIFICATION" && %lk%.#{MODULE} == argv[1]) {
            ret += k;
         }
   }
}
return ret;

Then you could call your script in a JQL query like this and create a filter out of the JQL Query

key in silJQLList("yourScriptName", "issuetype = BUG", "M-C")

You can modify your script as you wish. You can find more info on Power Scripts here:

https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.jjupin/server/overview