- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-19-2022 08:37 AM
Hi All,
I have a requirement, I have created a report on change table and added to a dashboard. I used a filter planned start date is between one week? Currently I am changing it manually every week.
Can anyone suggest can we write any script like scheduled job or anything which automatically add seven days in that??
Thanks in Advance
Solved! Go to Solution.
- Labels:
-
Change Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2022 01:30 AM
Hi,
update as this and it worked for me
var gr = new GlideRecord('sys_report');
gr.addQuery('sys_id','6a793872073630102011ff208c1ed0d5');
gr.query();
if(gr.next())
{
var gdt = new GlideDateTime();
var ed = new GlideDateTime(gdt);
ed.addDaysUTC(7);
var query = "end_dateBETWEENjavascript:gs.dateGenerate('" + gdt.getDate() + "','" + "00:00:00" + "')@javascript:gs.dateGenerate('" + ed.getDate() + "','" + "00:00:00" + "')";
gr.filter = query;
gr.update();
}
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2022 01:30 AM
Hi,
update as this and it worked for me
var gr = new GlideRecord('sys_report');
gr.addQuery('sys_id','6a793872073630102011ff208c1ed0d5');
gr.query();
if(gr.next())
{
var gdt = new GlideDateTime();
var ed = new GlideDateTime(gdt);
ed.addDaysUTC(7);
var query = "end_dateBETWEENjavascript:gs.dateGenerate('" + gdt.getDate() + "','" + "00:00:00" + "')@javascript:gs.dateGenerate('" + ed.getDate() + "','" + "00:00:00" + "')";
gr.filter = query;
gr.update();
}
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-20-2022 07:36 AM
Thank you so much Ankur.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎09-15-2022 12:52 AM
Hi, Is it possible to have a condition that checks if the report is called by a dashboard?