Reference Qualifiers - Adding Multiple Conditions

[andrewdunn]

Hi - looking for some assistance.

I believe this is an easy issue which I just cannot get my text correct

I have my assignment group Reference Specification as:

• Use reference qualifier: Advanced
• Reference qual: javascript:new BackfillAssignmentGroup().BackfillAssignmentGroup()

The above means that if an "Assigned To:" person is entered and the ITIL user wants to see what Assignment groups they are a member of they get the correct list.

What I want to do is also have the Assignment Group limited to just those groups that start with "IT"

If I do a simple qualifier I get the code "nameSTARTSWITHIT^EQ"

However I cannot combine them into one string to both work

What I have tried (amongst other options):  

• javascript:'new BackfillAssignmentGroup().BackfillAssignmentGroup()^'+nameSTARTSWITHIT^EQ()
• javascript:'new BackfillAssignmentGroup().BackfillAssignmentGroup()^'^nameSTARTSWITHIT^EQ()

Any ideas would be appreciated

cheers

[Slava Savitsky]

I think Andrew is trying to limit the list of available groups based on group membership of the user in the 'Assigned to' field rather than that of the current user (the one who is viewing the form) but I may have misunderstood the requirement.

[andrewdunn]

Thanks All - great insights - I apologise for not being clearer in what I was trying to achieve

Slava - you are right - I am trying to limit the available groups based on the "Assigned to" user. Although I did take Michael's idea and work a few other options around it (none were successful for me)

Thanks Subhajit as this is a good option, however trying to keep the tables as clean as possible although I can see some good alternative uses for this option

The one line reference qualifier is exactly what I was looking for, although Kalai's answer would have been good if I could get it to work as this would then be across all modules and options.

Slava - is there a way to modify the script so it only shows "IT" groups if the "Assigned To" field is blank?

Cheers

[Slava Savitsky · Accepted solution]

Sure. Try this:

javascript: var refQual = ''; if (current.assigned_to != '') {var usr = gs.getUser(); usr = usr.getUserByID(current.assigned_to); var grp = usr.getMyGroups().toArray(); refQual = 'sys_idIN' + grp.join()} refQual += '^nameSTARTSWITHit'; refQual;

[Bob]

Got totally lost in the weeds on trying to come up with a great way to do the backfill on the assignment group. This is fantastic in it's simplicity!

Thank you for saving me any more wasted time!

[Kristina2]

Hi Slava ,

Hope you can help me too .

I am looking for a reference Qualifier .

Default group is a filed in User Profile , which currents filters the group , the user is member of , by using a Script include in reference Qualifier .

But I am trying to add 2 more conditions .

Group Type is other and Active is true