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

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Rebekka Heilmann (viadee)

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

David Friedrich

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.

All comments

Rebekka Heilmann (viadee)

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

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

David Friedrich

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

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!

Florin-Mihai Mot

Thank you David! It helps indeed

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_

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-data-center

data-center