Creating a reference qualifier to show certain assignment groups

[matthew_hughes]

On the below form, I'm wanting to add a filter within the 'Assignment group' field:

However, what I'm wanting to do is restrict the number of 'Assignment groups' that appear. The groups should only appear where the Active flag is true and their parent's parent is 'Markets'.

I've tried the following reference qualifier in the Dictionary Entry Override on the assignment group field, but it's not working:

I was just wondering if somebody could explain why it's not working and what I need to only show groups where the Active flag is true and their parent's parent is 'Markets'.

 

[Daniel Borkowi1]

Hi @matthew_hughes, your script should deliver a Encoded Query, so in your case it should deliver: 

"active=true^" +"parent.parent.name=Markets"

Hope that helps.

Greets Daniel.

[Hemanth M1]

Hi @matthew_hughes 

active=true^parent.parent=sys_id of the Markest group^EQ

[Daniel Borkowi1]

The current is referencing the record there the assignment group field is placed. So you shouldn't use current in this kind of reference qualifier, because the query is independent of this record.

https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/script/server-scripting/c...

[Hemanth M1 · Accepted solution]

@Daniel Borkowi1 ; yes your correct and there is no need of javascript in this case (since we are overriding with simple query)

something like :  active=true^parent.parent=sys_id of the Markest group^EQ >>> works