Excluding groups with S-JQL

Andrey Tyupov

Hello,

I am getting a little stuck trying excluding some of the groups I have in my structure. 

 

Let's say I have the following automation set:

 

• Group By Labels
• Insert Issues with a JQL-query

 

and the resulting structure looks as follows

 

• > Label1
• > Label2
• > Label3

 

Now let's say I want to exclude the 'Label3' group from my structure. How do I do that?

 

Based on the https://wiki.almworks.com/display/structure/S-JQL+Reference I tried placing the following S-JQL query Filter on top of all the automation:

• item(group, 'Label1, Label2')

 

I also tried

• item(label, 'Label1, Label2')

and

• item(*, 'Label1, Label2')

 

But all of the queries removed everything from the structure.

 

Am I missing something here?

Vlad[ALM Works]

Hi Andrey,

I'm not sure if you got my response from the ticket you submitted to our Support Team, therefore I wanted to update my post here as well, just in case.

My previous response was not detailed enough nor was it the accurate method to truly accomplish the exclusion of desired Groups and for that, I apologize.

One way to exclude "Label3" as in your example, is to use the following Query as a Transformation, which you will be able to save as a Quick Transformation for future use:

not self_or_descendants of item (*, Label3)

or conversely, you can include "Label1" and "Label2" only:

self_or_descendants of (item(*, Label1) or item(*, Label2))

 

The reason we’re using a Transformation instead of a Generator here is that Filters are executed before Groupers. Therefore, when the Filter Generator is run, there are no Groups yet, which won't produce the desired results. The Transformation allows you to apply the Filter after the Grouper has been applied to the structure.

Transformations use the same type of functions as Generators. The main difference is that Transformations can only be applied to the whole structure (while Generators can be inserted under a Folder or under a manually added issue) and you cannot use Insert Generators as you already have a set of issues to work with.

With that said, if you prefer to use a Filter Generator instead, you can Insert your current structure that already contains your Inserted issues along with your Labels Grouper into a new structure and then apply the Filter Generator with one of the S-JQL Queries above. You will get the same results.

I hope this clarifies things. Otherwise, please let me know if you need further assistance.

 

Best Regards,

Vlad

ALM Works