How to Exclude Group values in Structre?

Question

Hello All,

New to structre add-on. How to exclude certain values from the Group.

Let say i have following automation set on custom fields -

Group By Customfield_A

Group by Customfield_B

resulting structre looks like below -

System (Customfield_A Value)

R1111 (Customfield_B value)

R2222 (Customfield_B value)

XC (Customfield_A)

R2121 (Customfield_B value)

R2323 (Customfield_B value)

R4141  (Customfield_B value)

Now i want to exclude only R2121 and R4141 from XC Group. How do i do that?

Please help.

Thanks in advance,

ch

Egor Tasa [ALM Works] · Answer

Hi,

This issue is discussed in our support ticket, but let me mention here that S-JQL can be used to filter out certain combinations of parents and children. So if you need to remove group X only from under group Y, you can use the following statement: not (item(*, X) and child of item**, Y). For groups this can only be done either in transformation, through structure() function, or for an inserted structure (insert the structure containing groups and then add filter) - this is because grouping at the moment happens after filtering.

Regards,
Egor