JQL query needed to see stories with links "blocks/is blocked by" for a Program increment

[Florin-Mihai Mot]

I need a filter to display the tickets that have dependencies.

The filter should display tickets that have

• Program increment field set to the next one (for example "PI24.002")
• A link "implements/is implemented by" or "blocks/is blocked by"

Filter by issuetype and responsible team should be possible

[David Friedrich · Accepted solution]

Hi @Florin-Mihai Mot 

issueLinkType in (blocks, "is blocked by", implements, "is implemented by")

for the links.

Not so sure about your Program increment field. Usually <YOURFIELDNAME>= "PI24.002" should do the trick.

Hope that helps.

[Florin-Mihai Mot]

Thank you David! It helps indeed :)

[scottconnerly]

Sometimes I use

issueLinkType IS NOT Empty

when I’m pulling issues into my Issue Flow diagram, in order to see all the relationship types.

[Rebekka Heilmann (viadee) · Accepted solution]

Hi @Florin-Mihai Mot and welcome to the community,

I guess the Program Increment Field is a custom field? You can simply search for values within that. Links can be searched per "issueLinkType".

The following JQL will give you any issue that has an Issue Link with the Type "is blocked by" or "blocks", is of the issuetype "Task" and has the Program Increment field set to PI24.002 (field name needs to be adjusted).

issueLinkType in ("is blocked by", blocks) and programincrement = "PI24.002" and issuetype = task

Check out this reference for more info on JQL in Data center: Advanced searching - fields reference | Jira Software Data Center 9.7 | Atlassian Documentation

[Florin-Mihai Mot]

I tried the below JQL and it retrieves something interesting:

issueLinkType in ("is blocked by", blocks) and issuetype = story 

Thank you for the prompt answer :)

Another question : can I build a JQL to show only Epics, then use a "Jira" macro in Confluence to pull in those Epics, and in the last step configure that Jira macro in my Confluence page to show also what's inside those Epics (Stories for example) ?

Many thanks in advance! 

[Rebekka Heilmann (viadee)]

You can filter for Epics with issuetype = Epic or get all children of a specific Epic with Epic Link = Epic-123. 

You can reference filters or simply create a new JQL in the Jira macro for Confluence. However, you cannot reference a filter result to search a specific field.

Filters can be used in JQL but only in a way that you can limit or extend the issues you search for on the same level.

So if you are searching for Epics and want to limit the search to any Epic returned  by FilterXYZ you add and Filter = FilterXYZ to the JQL. Same goes for "normal" issue types or simply general searches. However you cannot check whether Epic Link contains Epics from a filter result...
If that makes any sense?

The consequence is, that you would need to know the specific Epics you want to show the content of and search for them in the Epic Link:

Issuetype = story and Epic Link in ("Epic-123", "Epic-234", "Epic-345")

[Florin-Mihai Mot]

Thanks again @Rebekka Heilmann _viadee_