Use Reference Qualifier for group type

[wipeout630]

I am trying to add a reference qualifier to the Assignment Group field so only groups with a type of Support are shown.   I have tried the following combinations but to no avail:

• type=Support
• type='Support'
• type="Support"
• type=support
• etc.....

Do I need to use a sys_id instead of a string?

[danielbilling · Accepted solution]

I think you need to query the sys_id of that type record.

For more flexibility i would create a separate script and use javascript call in Ref Qual

[wipeout630]

Using the sys_id worked.   I'll work on using the script and javascript call at some point but this fixed my immediate problem.   Thanks!

[domaners]

The best way of getting the code for a reference qualifier I find is to navigate to the table (list) that the reference field is pointing to (in your case the group table), then use the filters to build the query you expect to put in to your reference qualifier. When you're happy that you have the right groups displaying, right-click on the filter then select Copy Query. The string that appears here can be pasted directly into the Reference qual field on the assignment group dictionary record. Let me know if you need any more clarification on this.

Cheers, Adam

[Victor Ruiz]

Awesome tip Adam....I just tried it and it worked like a charm !!!