Can a Filter include a link between an Epic and a Story?

[Phil Bustin]

I have a Filter that specifies Jira software Stories cloned from JSM issues.

    issueLinkType in ("Moved from", "Moved to", "Moved")

In a second Filter, I need some kind of component, if it exists, that will include Epics and their child Stories.  I haven't found such a component.

In the second filter, I tried using 'AND NOT issueLinkType =', with each of the above issueLinkType values, and similar with 'in' and all the values, but the result still included one of the Stories that had been cloned from a JSM issue.

I thought of creating a field "parent type" for Epics and their Stories, providing a value if and when Stories are created from the Epics, and using the field in the Filter, but of course I'd rather use some existing Filter value.

[Trudy Claspill · Accepted solution]

Hello @Phil Bustin 

I am not clear about your requirement

You want to create a filter that includes Epics and their child Stories. That part I understand. But what is your criteria for selecting those issues?

Are you looking at only natively available JQL functions or do you have any third party apps that extend JQL capabilities?

[Phil Bustin]

I have no third party apps.

To be clearer:

The two filters I created are for a Sandbox Dashboard that has two gadgets:

Gadget 1 should display JSM issues and their Dev Story clones, but only if one or more Dev Stories were cloned from the JSM issues.

Gadget 2 should display Epics and their Dev Stories, but only if one or more Dev Stories were created from Epics using "Add a child issue".

Filter 1 results include "Dev Story" issues only if they were cloned from JSM issues.

So, Filter 1 seems to be working.

Filter 1 (JSM issues and their cloned Dev Stories

"Global ID" is not empty AND issuetype in ("[System] Incident", "[System] Problem", "[System] Service request", "[System] Service request with approvals", "Dev Story") and issueLinkType in ("Moved from", "Moved to", "Moved") ORDER BY "Global ID" ASC, Created ASC

In Filter 1, when I at first tried issueLinkType ="is cloned by", there was no result (why?), so I tried the 'moved" values, and that displayed a JSM issue and its cloned Dev Story (the only one such pair I had created for the Dashboard).

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

Filter 2 is for Epics and their child Dev Stories, when Dev Stories are created from the Epic using "Add a child issue".  Without any clause to exclude Dev Stories cloned from JSM issues, the second Filter results include a Dev Story that was cloned from a JSM issue (not wanted for Gadget 2).

Filter 2 (Epics and their Dev Stories created using "Add a child issue")

"Global ID" is not empty AND issuetype in ("Epic", "Dev Story") ORDER BY "Global ID", Created ASC

In Filter 2, when I tried using issueLinkType not in ("Moved from", "Moved to", "Moved"), there were no issues found.

When I tried using AND NOT issueLinkType = "is cloned by", the result was a Dev Story that was cloned from a JSM issue, and no Epic.

So, I'm still looking for a clause in Filter 2 that would exclude Stories cloned from JSM issues.

Global ID Dashboard

Note issue TAST6-1654 as the first issue displayed in Gadget2, where I do not want it to display.  The same issue correctly displays in Gadget 1.

Gadget one displays a JSM issue, followed by its cloned Dev Story.

Beneath the unwanted issue in Gadget 2, an Epic is displayed, followed by its child Dev Stories.

[Phil Bustin]

I succeeded by adding AND NOT (issueType = "Dev Story" and "Epic link" is empty) to Filter 2.