How to exclude certain assignment group types when opening a task?

Linda6
Mega Guru

Dear Community,

 

on all the child tables of the task table I am supposed to exclude using assignment groups that are of a certain type.

I created two new types, let's call them Exclude1 and Exclude2 type and added these 'types' to the relevant assignment groups. Now, when I try to add an assignment group that is of type Exclude1 or Exclude2, it should not be possible.

How do I achieve this? A simple reference qualifier like this is not working:

types.png

Found out I could use an advanced ref qualifier, but as am new to coding, no idea how to write the code that would ensure that assignment groups of those two specific types won't be used...

Any hints, ideas please? Thank you so much in advance

1 ACCEPTED SOLUTION

Hi, 

Use the upper bottoms 'and' or 'or' clause for elaborating your query, try this: 

AdrianUbeda_0-1675943985595.png

This will show groups the groups that you have shared in the photo

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

View solution in original post

5 REPLIES 5

AshishKM
Kilo Patron
Kilo Patron

Hi @Linda6,

The condition you are trying with, are correct and it should exclude the group on all child table records.

Please share the testing result , if its not working as expected.

 

 


Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution