Filter for issuetype of parent of parent

[Langer Lukas]

Hey!

For a customer I need to rebuild a JQL filter, that should only show Changes and Bugs if the parent of their parent is not of the issueType "Story".

Is there any possibility to create such a filter not using third party apps?

[Aron Gombas _Midori_]

The type of the grandparent is not directly available in JQL.

A common approach of these type of problems is the following:

1. You add a new custom field called "Grandparent type" (can be even text)
2. You add automation rules that maintain this field:
   1. Initialize its value when the work item is created
   2. Update its value when the work item is moved
   3. ...

After this, you can use your custom field intuitively in JQL queries:

type and (Change,Bug) and "Grandparent type" != "Story"