Notification based on user's time zone
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2022 04:43 AM - edited 12-16-2022 12:02 PM
Can we trigger a notification based on user's time zone. I want to send an email notification at same time globally.
For example i want to send email at 12am in IST, Europe/London, US/Central etc..
Can we achieve through scheduled job.
I have tried these many ways but it is not working. Can you help me on this.
(function calculatedFieldValue(current) {
var tz = Packages.java.util.TimeZone.getTimeZone('US/Eastern');
var time = new GlideDateTime();
time.setTZ(tz);
time.setValue(current.sys_created_on);
return time.getDisplayValue();
})(current);
.................................................................................................
/ var gr = new GlideRecord("sys_user");
// gr.addEncodedQuery("time_zone=IST");
// gr.query();
// while (gr.next()) {
// gs.info("Timezone Test" + gr.user_name);
// gs.eventQueue("problem_resolve", current, gr.user_name, gr.email);
// }
// var session=gs.getSession();
// var tz=session.getTimeZoneName();
// var time = new GlideTime();
// gs.info(tz);
// gs.info(time);
..................................................................................................................
if (1==1) {
var when = new GlideDateTime();
gs.info("when1 "+ when);
var delay = new GlideTime();
delay.setValue("00:05:00");
when.add(delay);
// gs.info("time is "+delay);
// gs.info("Australia time :"+when);
var gr = new GlideRecord("sys_user");
gr.addEncodedQuery("time_zone=IST");
gr.query();
while (gr.next()){
gs.info("Testing Timezone" + gr.user_name);
gs.eventQueueScheduled("problem_resolve", current, gr.user_name, gr.email, when);
}
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-16-2022 05:39 AM
This looks quite interesting as well as difficult scenario to implement.
How many such time zones you have? If you have limited time zones like 4-5 then you can write those many scheduled jobs with different time zones to run at 12 AM.
Please mark answer as Correct or Helpful based on impact.
Regards,
Abhijit
ServiceNow MVP