Filtering stories based on parent's value in JIRA structure

Sasha_vnemfh

Hello, I'm trying to apply filter generator to filter issues based on parent's values. 

Groups are created by popping up the values from the story level to an epic by aggregate function. Then I want to keep stories only related to the group to do that I'm using parent{} function to get value from grandparent and comparing it with a story. It works great in quick transformation, however the same code doesn't work if you try to apply it via automation. 

Here is the code: 
parent#level=-2{item} == groupValue 
where groupValue returns the name of the group the item belongs. 

 

What I have now:

- Group 1

-- Epic 1 

--- Story 1 (Related to Group 1)

--- Story 2 (Related to Group 2) 

- Group 2

-- Epic 1 

--- Story 1 (Related to Group 1)

--- Story 2 (Related to Group 2) 

 

What I want to get: 

- Group 1

-- Epic 1 

--- Story 1 (Related to Group 1) 

- Group 2

-- Epic 1 

--- Story 2 (Related to Group 2) 

 

David Niro

Hello @Sasha ,

Welcome to the Community!

The reason your Filter will work as a Transformation, but not as a Generator is due to the order of operations for Generators.

Filtering happens before Grouping.  So, as a Generator, the filter is unable to reference the Group, because it has not happened yet.  Transformations happen after all generators, which is why it does work there.

There is a workaround you could try. 

You can create a new structure and use the Structure Inserter as your Insert Generator.  Select the original structure as the one you want to insert.  From here, you can now add your FIlter by Attribute w/ Formula as a Generator. 

Please let me know if this helps, or if I can clarify anything!

Best,
David