reference qualifier script member of group

[Karen Warren]

This has come up for me enough times and I don't want to continue to rely on our outside implementers.

I need to create a reference qualifier that is scoped to a particular group. Can someone let me know what that script would look like? I thought I was close a couple times, but I keep missing it.   sys_user field that references only a particular group.

This would be a big help.

Thanks,

Karen

[Brian Dailey1]

Hi Karen,

Do you have a reference to the group existing on the same form or record?   If so, then the easiest solution is to use this group field as the dependency for your user field.   Just as 'assigned_to' gets filtered by the chosen 'assignment_group'.

See Creating New Fields - ServiceNow Wiki

If not, then maybe some more detail around your use case might help.

Thanks,

-Brian

[Karen Warren]

Hi Brian,

Unfortunately, no.   I know what you are getting at and it is not referenced elsewhere on the record.   I had hoped to be able to mimic the behavior of the way Assigned To works by restricting to members of the Assignment Group referenced in the form. Unfortunately, my skill set is not quite there and I was not able to fill in the gaps for myself.

I have a Student Assigned To field. It is currently configured as a reference field to the Sys_user table. This is fine, but huge overkill.   It would be far better to have that field restricted to only show members of a group (in this case the group is called ACS_withStudentAssignment.   There is no corresponding role either as these are not process users.   Essentially all I want is to be able to have a criteria that says Is Member Of.   (Boy I wish SN had that as a criteria. It would really be useful.)

Thanks,

Karen

[Brian Dailey1]

Hi Karen,

When you say "Assignment Group referenced on the form", what do you mean then?   Because it sounds as though you do have a field on this form/object referencing the Groups table, and that then could be used as a dependency for Assigned_to.

What object are you working with Incident/Request/custom/etc.?   Perhaps a screenshot of the table definition (Configure--> Table) for this object would be helpful.

Thanks,

-Brian

[Karen Warren]

Hi Brian,

Thanks for replying and I am sorry for not being clear. I only meant to indicate that it is NOT like the relationship between Assignment Group and Assigned To.

This is entirely within the Incident Table.   We have a custom field called u_student_assigned_to.   It is a reference field to the sys_user table. I would like the search for that field to be restricted to users who are a member of a specific group. I am happy to provide a screen cap, just not sure what to provide.  

I feel as though I am not answering what you are asking me.

Karen