Jira query that excludes occurrence tickets where parent is closed status

[Kim Lewis]

Hi, Can anyone with this filter? I'm looking for the following criteria:

1. Status not in Canceled or Closed
2. Exclude Occurrence tickets that have Parent tickets that are canceled, closed
3. Exclude Occurrence tickets resolved more than 365 old.

project = ZPT AND type = Problem AND status not in (Canceled, Closed) and issuefunction not in subtasksof("project = ZPT AND type = Problem AND status not in (Canceled, Closed)") and (status not in (occurrence) or status in (occurrence) and resolved > -365d)

It is still returning occurrence tickets where the parent is Closed.

[Hannes Obweger - JXL for Jira]

Hi @Kim Lewis

just to add to @Shikha Verma's great answer:

If you're open to solutions from the Atlassian Marketplace, I believe that your use case would be easy to solve using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called smart columns that aren’t natively available, including e.g. the parent status and the time since resolved.

This is how it looks in action:

As you can see above, you can easily sort and filter by your sheet's columns and smart columns. To narrow down your list to the issues you're interested in, you'd simply add the relevant column filters to your status, time since resolved, and parent status columns.

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes

[Shikha Verma]

Hi, @Kim Lewis. Welcome to the community! Please give this a try.

project = ZPT AND type = Problem AND status NOT IN (Canceled, Closed) AND issueFunction not in subtaskOf("project = ZPT AND type = Problem AND status NOT IN (Canceled, Closed)") AND ( status NOT IN (Occurrence) OR ( status IN (Occurrence) AND resolved >= -365d AND issueFunction not in parentsOf("status IN (Closed, Canceled)") ) )
OR
project = ZPT AND type = Problem AND status NOT IN (Canceled, Closed) AND issueFunction NOT IN issuesInEpics("project = ZPT AND type = Problem AND status IN (Canceled, Closed)") AND (type != Occurrence OR (type = Occurrence AND resolved >= -365d))

Please ensure that the issuefunction plugin is installed and properly configured in your Jira instance.