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 with a condition on one criteria

CécileV

Hello,

Can someone help me to write a JQL search for the following query:

In a given project (PRO1), I want to list all the issue types A (MIR) that have at least one link (link = "is MIR of" ) to an issue type B (SRS), but only the SRS in status APPROVED

I started to write:

project = PRO1 AND issuetype = MIR AND issueLinkType = "is MIR of"

but I don't know how to integrate the filter on the SRS' APPROVED status.

Any idea?

Accepted answers

Tessa Tuteleers

Hi @CécileV ,

I'm not sure if this can be done without the Scriptrunner app, but if you have that, you could use

project = "PRO1" AND issuetype = MIR AND issueFunction in linkedIssuesOf("issuetype = SRS AND status = approved", "is Mir of")

Hope this helps!

- Tessa

All comments

Tessa Tuteleers

Hi @CécileV ,

I'm not sure if this can be done without the Scriptrunner app, but if you have that, you could use

project = "PRO1" AND issuetype = MIR AND issueFunction in linkedIssuesOf("issuetype = SRS AND status = approved", "is Mir of")

Hope this helps!

- Tessa

CécileV

Hi Tessa, thanks a lot for your fast reply.

I got this error message: "Error in the JQL Query: Expecting ')' before the end of the query."

I place the ")" at the end, first, the result didn't show any issue.

I placed it after approved", then I got a error message again.

However, I know the result should not be empty...

Tessa Tuteleers

Hi @CécileV ,

just to be sure, you do have scriptrunner on your instance?
Could you copy paste your JQL to here? Perhaps add a screenshot in there as well?
Maybe the screenshot of an issue of which you are sure to match the conditions mentioned?
The one I posted seems to work for me, so I'd like to check what is different.

Keep in mind, this query will find issues that:

- Are in project PROJ1 +

- Are of the issuetype MIR +

- Are linked to issues of issuetype SRS that are in status approved with the "Is Mir of" link

CécileV

Yes Tessa, I confirm we have Scriptrunner.

I also confirm that what you mention as a result is what I expect.

But here is what I get (screenshot)

Welcome!

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

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

jql