Based on the date, an email notification should be sent to a specific group in catalogue form.

Sravani47 · ‎11-16-2022

We have one catalogue form in that catalogue with one "Specify end date of roles access" Date field, and an email notification should be sent to a specific group based on that date.

Please find the Catalogue form screen shot, This date is always a future date, and only on that date is an email notification sent to the group.

Please help me on this how to do this requirement.

Sagar Pagar · ‎11-20-2022

Hi @Sravani47,

Try this updated scripts and modified it accordingly.

var gr = new GlideRecord('sc_req_item');
gr.addQuery('cat_item', "sys_id_of catalog_item");
gr.query();
while (gr.next()) {
	var temp = gr.variables.end_date_of_roles_access.toString();

	if (new GlideDateTime(temp).getDate.getNumericValue() == new GlideDateTime(temp).getDate().getNumericValue()) {
	    
	//	gs.info("RITM Number: "+ gr.number + new GlideDateTime(temp).getDate.getNumericValue() + " - " + new GlideDateTime(temp).getDate().getNumericValue())
		gs.eventQueue('Request.RoleRevoke.Enddata', gr, gr.assigned_to.toString()); // fire this events

	}
}

Thanks,
Sagar Pagar

The world works with ServiceNow

View solution in original post

Sravani47 · ‎11-17-2022

1) added log gr.variables.end_date_of_roles_access.getDisplayValue()

Output is same result undefined.

2) logged gs.nowDateTime()

Output is current date and time

vikrantsharma · ‎11-17-2022

What about gr.variables.end_date_of_roles_access? What is the log for that?

Please make it correct or helpful if this solves or help you with your issue for other to make use it.

Thanks & Regards,
Vikrant Sharma

Sravani47 · ‎11-17-2022

gr.variables.end_date_of_roles_access

for this also same undefined

vikrantsharma · ‎11-17-2022

This is the right syntax, either the field is not on RITM, or the variable is empty.

Can you log gr.number and check what is the value of the field for that RITM?

Please make it correct or helpful if this solves or help you with your issue for other to make use it.

Thanks & Regards,
Vikrant Sharma

Sravani47 · ‎11-17-2022

gs.info("RITM number : "+gr.number);

display all RITM number.