question Script Help to exclude weekends in Developer forum

Script Help to exclude weekends

Jyoti Tripathi — Tue, 06 Jun 2023 08:21:41 GMT

I have a custom True/False field, i wanted to make the field set as true when the Assignment Group for the case is empty for more than 1 business days..
Someone please help how to achieve this

Re: Script Help to exclude weekends

Jyoti Tripathi — Tue, 06 Jun 2023 08:46:57 GMT

@Ankur Bawiskar : please help

Re: Script Help to exclude weekends

Sai Shravan — Tue, 06 Jun 2023 08:57:41 GMT

Hi @Jyoti Tripathi ,

To automatically set a custom True/False field to "True" when the Assignment Group for a case is empty for more than one business day, you can use a Business Rule in ServiceNow. Here's an example

(function executeRule(current, previous,) { // Check if the Assignment Group is empty if (!current.assignment_group.nil()) { return; } // Check if the case has been empty for more than one business day var oneBusinessDay = 60 * 60 * 24; // Adjust if your business days have different durations var now = new GlideDateTime(); var createdOn = new GlideDateTime(current.sys_created_on); var elapsedDays = GlideDateTime.subtract(now, createdOn).getNumericValue() / oneBusinessDay; if (elapsedDays >= 1) { // Set the custom field to "True" current.u_custom_field = true; } })(current, previous);

When to Run : "Before" and "After"

Table : incident (if it is incident)

Regards,

Shravan

Please mark it as helpful and correct answer, if this helps you

Re: Script Help to exclude weekends

Jyoti Tripathi — Tue, 06 Jun 2023 09:04:03 GMT

Hi @Sai Shravan : The above code will not exclude weekends. Also Business Rule will work for this...how about a Schedule job?

Re: Script Help to exclude weekends

Grzegorz Kaznoc — Tue, 06 Jun 2023 09:26:35 GMT

Firstly it is good to have this information how long your assignemnt group is empty. You can take it from audit table, but it is not efficient way to search this way, so you want to somehow mark this time to get it easly accesible. Separate column which is calculated from business rule may help. It would store time when group become unasigned or incident with empty group has been created. And once incident is assinged you can clear whis field by same business rule.

Once you have it you can schedule action to raise you flag for such incidents. You can in your previous business rule schedule event and write script action which will mark youd field true if in the meantime it was not assigned (your time field will tell you that). Alternatively you can write Scheduled Script Execution (sysauto_script) job to search incident table by your time field and set value of your flag with updateMultiple() method for your incident GlideRecord.

For excluding weekends you can use GlideSchedule API which can tell you about elapsed time based on some schedule (like excluding weekends)

Re: Script Help to exclude weekends

Baala T — Tue, 06 Jun 2023 10:03:18 GMT

Hi Jyoti,

Please try below code in scheduled job, value of iDay 6 and 7 are referring

6 = Saturday
7 = Sunday

Regards,
Bala

Re: Script Help to exclude weekends

Ankur Bawiskar — Tue, 06 Jun 2023 10:13:38 GMT

@Jyoti Tripathi

you can schedule job daily and check if the group field is empty and it has been more than 1 business day

business day calculation is already shared with you

Re: Script Help to exclude weekends

Jyoti Tripathi — Tue, 06 Jun 2023 11:10:19 GMT

Hi @Baala T : Thanks for sharing the script, what if the case got created on weekend and group was empty (example on Saturday).. so on Tuesday(More than 1 business days) it will make the field set as true right?

Re: Script Help to exclude weekends

Jyoti Tripathi — Tue, 06 Jun 2023 11:12:12 GMT

Hi @Ankur Bawiskar : Apologies, i am not able to see the calculation shared by you.

Re: Script Help to exclude weekends

Baala T — Tue, 06 Jun 2023 11:42:01 GMT

Modified the script little bit. PFB

Re: Script Help to exclude weekends

Jyoti Tripathi — Wed, 07 Jun 2023 09:34:32 GMT

@Baala T :
it is not make the Custom field to set it as true when Assignment group is empty for more than 1 business days, please help

Re: Script Help to exclude weekends

Ankur Bawiskar — Wed, 07 Jun 2023 09:39:06 GMT

@Jyoti Tripathi

calculation is shared by other members.

Re: Script Help to exclude weekends

Baala T — Wed, 07 Jun 2023 10:04:52 GMT

Hope you have created as a scheduled job, What is the error that you are getting?

Let me know the Table Name and Field Name.

Re: Script Help to exclude weekends

Jyoti Tripathi — Wed, 07 Jun 2023 10:12:58 GMT

Table is sn_hr_core_case and field name is assignment_check1bd
This is how i want this to work-
if the case got created on Monday and group was empty.. so on Tuesday(More than 1 business days) it will make the field set as true
if the case got created on Tuesday and group was empty.. so on Wednesday..it will make the field set as true.. and so on..
But if the case got created on Saturday/Sunday and group was empty.. so on Tuesday (More than 1 business days) it will make the field set as true