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:
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
Hi,
Use the upper bottoms 'and' or 'or' clause for elaborating your query, try this:
This will show groups the groups that you have shared in the photo
Hi Linda6,
From my point of view, with that simple reference qualifier should be enough for achieving this. However, you need to define the OR and AND logic clause.
In this case, the picture that you are showing will show any assigment group which type=null^ORItil^ORapproval_group & typeNOTContain Exclude1 & typeNOTContain Exclude.
As far as I understand, your requirement need to show exclude1 or exclude2 type, so for this I would modify the second part of the qualifier (if the firt one is need it, if not you can remove/edit it). It should look as follows:
With this, if assigment group type is null or itil & exclude 1 or exclude 2 will be selecteable.
Hello, thank you.
The true names of those types are 'AD Group' and 'Access group'.
When I set the condition to NOT INCLUDE these groups, like this:
...it returns some of the groups with other types, but does not return those groups whose type is EMPTY.
And however I change the condition filter, it still does not show ALL the relevant groups (all those whose type is either EMPTY or is different to type 'AD Group' or 'Access group'.
Hi,
Use the upper bottoms 'and' or 'or' clause for elaborating your query, try this:
This will show groups the groups that you have shared in the photo
