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?

[Sandeep Rajput]

@Bijay Kumar Sha Did you try 

javascript:TaskAssignmentFilter()+'^active=true';

[Bijay Kumar Sha]

Hi @Sandeep Rajput ,

As I mentioned it's working for active true groups. But the BR mentioned in the reference qualifier seems to be broken. 

[Ankur Bawiskar]

@Bijay Kumar Sha 

there is OOB query business rule on group table which should show only active groups

Is that BR not active in your instance? Please check that

[Bijay Kumar Sha]

Hi @Ankur Bawiskar ,

I've checked the BR and it is active. Please find the screenshot as below:

As I mentioned I've tried by putting active=true condition in the reference qualifier. It's filtering out the Active groups only. But the other BR mentioned in the reference qualifier isn't working.

So, I think only option left to put the condition in the BR itself mentioned in the reference qualifier. But as I mentioned the issue is the BR is Global table. How I can navigate to Assignment Group field available in group table from Global table?

Can you please help me on this?