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

Florin-Mihai Mot March 18, 2024

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

2 answers

2 accepted

0 votes
Answer accepted
David Friedrich
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 18, 2024

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 March 18, 2024

Thank you David! It helps indeed :)

0 votes
Answer accepted
Rebekka Heilmann _viadee_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

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 March 18, 2024

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_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 18, 2024

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

Like Florin-Mihai Mot likes this
Florin-Mihai Mot March 18, 2024

Thanks again @Rebekka Heilmann _viadee_ 

Suggest an answer

Log in or Sign up to answer