Jql request

Question

Hi,

For a project named Demo I would like to create a filter which will show the {Problem Report, Enhancement Request, Development Request, Information Request} of the DEMO project that are in one of the states {Submitted, Analyzed, Accepted) while ALL {Problem Report, Enhancement Request, Development Request, Information Request, Story, Epics} children are in status {Closed, delivered, rejected}.

I tried:

-project = DEMO AND status in (Submitted, Analyzed, Accepted) AND issue in linkedIssuesFromQuery("project = DEMO AND status in (Closed, delivered, verified, solved)", Parent, Inward)

-project = DEMO AND status = Submitted AND issue in linkedIssuesFromQuery("project = DEMO AND status in (Closed, delivered, verified, solved)", Parent, Inward)

Without success,

Could someone help me?

Many thanks in advance,

Sab Rina · Answer

Hi thanks for your help,

But with this request I have all the parent issue which have at least one linked issue in the state Closed or delivered or verified or solved but in my case I would like the parent issue only if ALL the linked issues are Closed or delivered or verified or solved, for instance if a parent issue has 5 linked issue 2 closed, 2 verified and 1 SUBMITTED, i don't want to retrieve the parent issue in my request because of the 1 submitted,

I hope it will be clearer,

Many thanks once again,

Pedro Felgueiras · Answer

You can try to remove the extra parameter from the linkedIssuesFromQuery.

Try a query like this

-project = DEMO AND status = Submitted AND issue in linkedIssuesFromQuery("project = DEMO AND status in (Closed, delivered, verified, solved)")

If it dosent work try braking down the filter by parts.

Check if  - issue in linkedIssuesFromQuery("project = DEMO AND status in (Closed, delivered, verified, solved)") - return all the issues that is suposed.