Only show groups with "assignment group" ticked

[scottjus82]

Good morning,

I am trying to sort out an issue with our assignment groups. I only want to display groups that are active and marked as an "assignment group" in the groups user administration section. This was meant to have been done by predecessor however it does not work. The following line is in the ref qualifier field for assignment group on the incident form. active=true^typeISEMPTY^NQactive=true^typeLIKE50e336982b6705000e9f8c1fe8da1590. the first problem is it dosnt work as stated as in I can assign tickets that are marked as in-active. also tere is no reference to "assignement group" true or false field.

Can anyone advise? I have played around with the script but have not got it working.

Regards

[scottjus82]

Thanks for the quick reply,

I have tried that but gave it another try in case of typos in my script and it still dosnt work.

[Jim Coyne]

What is the actual name of the "assignment group" field?   That may be the issue.   Take a look at post which shows how to build the query.

If that does not work, you may have a Dictionary Override configured - Dictionary Overrides - ServiceNow Wiki

If that is not the case, can you try to duplicate your setup in https://demo007.service-now.com/login.do?

[scottjus82]

Hi Jim,

thanks for the help so far.

Whilst working on a diffeent area I have noticed that your reference qualifier works.....So on Change and work requests (customer app) the assignment group only shows groups that are both active and listed as an assignment group where as on the incident table all show. I am assuming that since all three reference the same table (task) and the same column name (assignment_group) I must have a clashing rule or script on the incident table?

Any thoughts would be appreciated.

[scottjus82]

Hi,

further to the above I found the cause of the problem (sticks out like a sore thumb now) we had a dictionary overide for incident that overides the ref qualifier.

All fix and working

thanks for the help provided.

Regards

[Jim Coyne]

You are welcome.