Reference Qualifier on Dictionary override

[Eileen Hessmill]

I needed to add a reference qualifier to list only assignment type groups for assignment group on a Change record. In the dictionary override for Change Request, I found that type=assignment didn't work, but rather typeLIKE046c900adb136b0072b380ba689619b5.

Is that to be expected? 

[Chuck Tomasi]

Yes. That's expected because type is a reference field. When you use a reference field, you must supply a sys_id. 

A more optimal way to do this would be type=046c900adb136b0072b380ba689619b5

because like does a wildcard search in the database and = does an exact match. Searches are more expensive than exact matches. Since you already know the exact sys_id, then use the = operator.

[Eileen Hessmill]

I was just copying from my personal developer site. Thanks for the info.

[Ankur Bawiskar · Accepted solution]

Hi Eileen,

That is because type field on group table is a reference/list field and not string hence you need to give sys id there instead of name.

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Hari63]

Hello,

I am also having the same requirement,

i have mentioned the sys_id of the groups which are need to be displayed as below in Dictionary Override.

Once i saved, the assignment group is not showing in 'Assignment_group' field.

Please help me where i have to modify.

Thanks in Advance