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; } } }

Help required to form a combined JIRA Query!

Vijay Kumar_ln3ogr

I am trying to find issues as per the below conditions & their individual queries as follows & those queries work absolutely fine. They are time tested.

1) Story/Defect/Task is in 'COMPLETED' status, but subtask/s are in 'OTHER THAN COMPLETED' status.
project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND status = "Completed" OR issueFunction in subtasksOf("status != Completed") AND sprint in openSprints()

2) Story/Defect/Task is in 'OTHER THAN COMPLETED' status but subtask/s are 'COMPLETED' status.
project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND status != "Completed" OR issueFunction in subtasksOf("status = Completed") AND sprint in openSprints()

3) Story/Defect/Task is in 'OTHER THAN COMPLETED' but subtask/s are also 'OTHER THAN COMPLETED' status.
project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND status != "Completed" OR issueFunction in subtasksOf("status != Completed") AND sprint in openSprints()

Now I want to put all of these in one query as i need to find issues which meets all these criteria. Hence, I am writing below queries. None of it worked properly,

THE QUERIES WHICH DIDN"T WORK:

1) project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND sprint in openSprints() AND ( (status = "Completed" OR issueFunction in subtasksOf("status != Completed")) OR (status != "Completed" OR issueFunction in subtasksOf("status = Completed")) OR (status != "Completed" OR issueFunction in subtasksOf("status != Completed")) )

2) project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND sprint in openSprints() AND ( (status = "Completed" OR issueFunction in subtasksOf("status != Completed")) AND (status != "Completed" OR issueFunction in subtasksOf("status = Completed")) AND (status != "Completed" OR issueFunction in subtasksOf("status != Completed")) )

3) project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND sprint in openSprints() AND ( (status = "Completed" OR issueFunction in subtasksOf("status != Completed")) OR (status != "Completed" OR issueFunction in subtasksOf("status = Completed")) OR (status != "Completed" OR issueFunction in subtasksOf("status != Completed")) )

4) project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND ( (status = "Completed" OR issueFunction in subtasksOf("status != Completed")) OR (status != "Completed" OR issueFunction in subtasksOf("status = Completed")) OR (status != "Completed" OR issueFunction in subtasksOf("status != Completed")) ) AND sprint in openSprints()

Accepted answers

All comments

Mirek

Hi @Vijay Kumar

The reason that it does not work is probably because you mix of AND/OR conditions without properly grouping them. Specifically, you use multiple OR conditions for each scenario but didn't make sure the logic correctly grouped the status of the parent AND subtasks together.

Try this one..

project = CDP AND "Assigned Team" = "Chimera - Core API Team" AND issuetype in (Story, Defect, Task) AND sprint in openSprints() AND ( (status = "Completed" AND issueFunction in subtasksOf("status != Completed")) OR (status != "Completed" AND issueFunction in subtasksOf("status = Completed")) OR (status != "Completed" AND issueFunction in subtasksOf("status != Completed")) )

Vijay Kumar_ln3ogr

@Mirek
I am sorry, this is giving me zero results again.

Mirek

Could you please test it on a fresh Search not on Boards as a Quick filter? The reason is that it might be combined with your Board filter and making a bigger mess in logic. So first of all is to check if query is working overall.

Vijay Kumar_ln3ogr

@Mirek Could be the reason. Lemme try that right away!

Pasam Venkateshwarrao

Hi @Vijay Kumar

Welcome to the community,can you try this JQL Example

project = ABC AND "Assigned Team" = "Test Team"
AND issuetype in (Story, Defect, Task)
AND sprint in openSprints()
AND (status = "Completed" OR issueFunction in subtasksOf("status != Completed"))

Hope this helps

Vijay Kumar_ln3ogr

Hi @Pasam Venkateshwarrao
Thanks much for the reply. This query and so far whatever we have tried works at only User Story, Task & Defect level. It is unable to find a subtask underneath these story, defect & task, whether it's in completed status or other than completed status.
I now started getting doubt that, whether issueFunction is a valid one we are using.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud