Filter to extract unresolved escalated tickets

[Saira Samman]

I need assistance in refining my filter.

Background:

• Project A is a Service Desk Project
• Project B is a Software project

Tickets from Project A are escalated to Project B. As a result the relationship between Project A and Project B tickets is shown as 'was escalated to' and  'is an escalation of'. 

Now as per the project post function rule, 'resolve child project B tickets on resolve project A tickets'. Meaning, when Project A ticket is resolved, any escalated Project B ticket should also be resolved.

Problem:

We encountered an issue recently with our rules and a few escalated tickets were not resolved upon parent ticket resolution. It is fixed now. However, I need to identify all escalated Project B tickets that are not resolved but their parent Project A tickets are marked as resolved.

Filter:

project = "B" AND status not in (Resolved, Closed, Done) AND issueFunction in hasLinks("is an escalation of") AND issueFunction in linkedIssuesOf("project = A and status  in (Resolved, Closed, Done)")

My filter does extract Project B tickets that contain link 'is an escalation of', but the links are not limited to Project A only. The results also include Project B tickets that were escalated from other projects as well. I need to extract unresolved escalated Project B tickets that were escalated from project A only.

Any guidance is appreciated.

Thanks,

Saira