Assignment Group field should not pick inactive groups

[Bijay Kumar Sha]

Hi,

I've an existing script available for Assignment Group field as below:

I need to one condition in above existing script as active=true. So, that Assignment Group should pick only active groups. 

However, the problem is the above BR is in Global table. How I can dot walk to group table and then to Assignment group?

I tried to put active=true in reference qualifier in the dictionary of Assignment group filed in above screenshot, but it's not working for all the tables like inc, service request, change, problem, task, group approval etc. 

So, only option is left for adding the condition in the script itself. 

Can anyone help me to do this?

[Ankur Bawiskar]

@Bijay Kumar Sha 

the BR mentioned in screenshot is a custom one?

if yes then you need to debug and fix that

[Bijay Kumar Sha]

Hi @Ankur Bawiskar ,

Yes, the BR mentioned in the Reference Qualifier is a custom one. But it was created in Global table. I just need to add the condition Active= True. But how I can do this? 

[Ankur Bawiskar]

@Bijay Kumar Sha 

I didn't get why to update that Custom BR when the OOB BR on Group table already hides inactive groups.

There is no need to update the custom BR or the reference qualifier condition. the OOB query BR on group table should do your job

[Bijay Kumar Sha]

Hi @Ankur Bawiskar , But it's not working.

As I showed you the OOB BR, it there in the system and Active as well.

But still, I'm able to select inactive group in Assignment Group field. 

[newhand]

@Bijay Kumar Sha 

The same with @Ankur Bawiskar 

By default, "Active=True" is enabled for normal users. (I have tried it, and it works well.)

Normally, you don't need to do anything...

However, when the session is interactive, users with the "admin" or "user_admin" role can select all groups.   

If you want "Active=True" to have an effect at any time, you can add this condition to the "Reference qual condition" on the "Reference Specification" tab.