question Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields in Community Central forum

Round Robin Business Rule script Question about addQuerry order for multiple custom fields

JGerrity — Tue, 08 Apr 2025 12:53:24 GMT

Hello All,

I'm attempting to build a round robin business rule script that will need to look at a couple of a custom fields:

u_roundrobin on the sys_user_group table as true/false.
"u_out_of_office" (true/false) on the sys_user table

What I want to do with my business rule, is:
1) Query the current.assignment_group to see if u_roundrobin = true

2) If true, query all members of that group and only include those who's u_out_off_office = false

My code so far:

(function executeRule(current, previous /*null when async*/) { var gMember = new GlideRecord('sys_user_grmember'); gMember.addQuery('group', current.assignment_group); gs.print("assignmentGroup:"+gMember); gs.log("assignmentGroup:"+gMember); var rrMember = gMember.addQuery('u_roundrobin', true); gs.print("rrMember:"+rrMember); gs.log("rrMember:"+rrMember); if(rrMember == true) { var agroup = new GlideRecord('sys_user_grmember'); agroup.addQuery('group', current.assignment_group); var ooo = agroup.addQuery('u_outlook_out_of_office', true); agroup.query(); gs.print("ooo:"+ooo); gs.log("ooo:"+ooo); if (ooo == true){ if (gMember.next()) { current.assigned_to = gMember.user; } } } })(current, previous);

I'm struggling with the logic of query group to determine if u_roundrobin is true, then multiple if's or if I can do it all within a query and only reference members of the current assignment group (if it's a member of roundrobin and the user is not outofoffice (ooo).

thoughts?
thank you.

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

Sandeep Rajput — Tue, 08 Apr 2025 13:20:49 GMT

@JGerrity Try if the following works.

(function executeRule(current, previous /*null when async*/) { var assignedGroup = current.getValue('assignment_group'); var group = new GlideRecord('sys_user_group'); group.addQuery('sys_id', assignedGroup); if (group.next()) { var isMemberRR = group.u_member_of_round_robin; gs.print("isMemberRR:" + isMemberRR); gs.log("isMemberRR:" + isMemberRR); if (isMemberRR == true) { var mem = new GlideRecord('sys_user_grmember'); mem.addQuery('group', group.getValue('sys_id')); mem.orderBy('user.u_last_assigned_task_date'); mem.query(); if (mem.next() && mem.user.u_outlook_out_of_office != '1') { current.assigned_to = mem.user; } } } })(current,previous);

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

Ankur Bawiskar — Tue, 08 Apr 2025 14:12:28 GMT

@JGerrity

when is the business rule running? on which table and what's the condition?

Your business rule should be Before insert/update.

(function executeRule(current, previous /*null when async*/) { // Query the assignment group to check if u_roundrobin is true var group = new GlideRecord('sys_user_group'); if (group.get(current.assignment_group) && group.u_roundrobin) { // Query all members of the group who are not out of office var gMember = new GlideRecord('sys_user_grmember'); gMember.addQuery('group', current.assignment_group); gMember.addQuery('user.u_out_of_office', false); gMember.query(); // If there are members available, assign the incident to the first one found if (gMember.next()) { current.assigned_to = gMember.user; } } })(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

JGerrity — Tue, 08 Apr 2025 14:52:30 GMT

I want to thank both @Sandeep Rajput and @Ankur Bawiskar for helping with this. Sandeep, really appreciate you pointing me in the right direction.

Ankur, your formatting and logic were bang-on!

Thank you both, greatly appreciated!!
Jason

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

Ankur Bawiskar — Tue, 08 Apr 2025 14:54:19 GMT

@JGerrity

Glad to help.

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

JGerrity — Tue, 15 Apr 2025 12:40:47 GMT

Hi @Ankur Bawiskar & @Sandeep Rajput ,

I'm looking to extend the functionality of this script and wondered if you had recommendations on logical approach (I'll try to figure out the coding part)...gotta learn right?

What I'm looking to do is iterate through the members of all assignment groups that have the group.u_roundrobin field set to true. Add all of these users into an array, then convert all users to input for an API action that will use MS Graph to check the autoreply status of Exchange Online via a batch API call. Then for all users who's autoreply status is enabled, set the u_outofoffice value to true on the user table.

Basically, it's looking to set the out of office flag to true based upon Exchange Online AutoReply status daily so our users only have to maintain out of office in one location (Outlook).

What I'm wondering is does this logic make sense? iterate through the assignment groups, add users to array and then add each user to an input variable of a flow action (script step), which will then be used to make the graph API call.

I was thinking a scheduled job (script) to only make the API call once or twice a day. The script needs to find all group members of round robin, set those users' email addresses (UPN) as input variables to then be called by an Flow (Action) which makes the API batch call, to check only those users.

Cheers!

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

Ankur Bawiskar — Tue, 15 Apr 2025 12:44:31 GMT

@JGerrity

yes you can use daily scheduled job and handle it

something like this but please enhance

If my response helped please mark it correct and close the thread so that it benefits future readers.

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

JGerrity — Tue, 15 Apr 2025 12:56:03 GMT

@Ankur Bawiskar Wow! not only a blazingly fast response but exactly what I was looking for. You even did the coding part for me!

Greatly appreciated thank you!
Jason

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

Ankur Bawiskar — Tue, 15 Apr 2025 13:49:08 GMT

@JGerrity

Glad to help.

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

JGerrity — Tue, 15 Apr 2025 20:01:27 GMT

Hello @Ankur Bawiskar

Thank you again for this it's a great start!

I noticed that the formatting of MS Graph batching is :

{ "requests": [ { "id": "1", "url": "/users/" + email + "/mailboxSettings/automaticRepliesSetting", "method": "GET" }, { "id": "2", "url": "/users/" + email + "/mailboxSettings/automaticRepliesSetting", "method": "GET" }, { "id": "3", "url": "/users/" + email + "/mailboxSettings/automaticRepliesSetting", "method": "GET" }, ] }

So I'm thinking that the users array should be counted or I'm wondering if it's possible to build the response body inside the

 while (group.next()) {

loop.

The request body is specific formatting with the combination of { "requests": [
Then each user is within a { }; and ID field is mandatory and then closed within the ]:

As referenced here: https://learn.microsoft.com/en-us/graph/json-batching?tabs=http

I'm not sure how to write the exact format of the required requestBody with an incremental ID value.

Cheers!

Re: Round Robin Business Rule script Question about addQuerry order for multiple custom fields

Ankur Bawiskar — Wed, 16 Apr 2025 02:29:14 GMT

@JGerrity

then inside the while loop form array of json objects and use it

something like this

If my response helped please mark it correct and close the thread so that it benefits future readers.