- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2023 06:24 AM - edited 09-13-2023 06:25 AM
Hi
I have below requirement.
there is Lookup request record producer on the portal.
I want the record producer to be visible only in month of August. other than August i don't want to see the Lookup request on portal.
for this i have created user criteria and add to Lookup request Available for.
var gdt = new GlideDateTime();
gdt.addMonthsLocalTime(8);
gs.info(gdt.getDate());
Not understanding why my user criteria not working?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2023 07:21 AM
Hi @sony8
//I have done it for Month September
Scheduled Job
Name : Activate Record producer if Month is September
Run : Monthly
Day : 1
Time : 00:00:00
Script :
var date = new GlideDateTime();
var grRP = new GlideRecord('sc_cat_item_producer');
grRP.addQuery('sys_id', '080fa5079777c5101780db24a253af97');
grRP.query();
if (grRP.next()) {
if (date.getMonthUTC() == 9) {
grRP.active = true;
} else {
grRP.active = false;
}
grRP.update();
}
Note : Do not use hard coded value for sys_id (I have used just for testing here)
You can use Conditional option if you want to run scheduled job on specific condition
ServiceNow Developer
I know one thing, and that is that I know nothing.
- Socrates
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2023 07:15 AM
share your updated script.
when I run the script in background it shows false it means the month is not August so the script is correct.
gs.info("The month is->" + new GlideDateTime().getMonthLocalTime());
var val = new GlideDateTime().getMonthLocalTime() == 8;
gs.info(val);
Output:
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2023 07:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-13-2023 09:45 PM
scheduled job for this requirement is unnecessary.
you didn't copy exact script I shared in my 1st response and hence it didn't work.
I already showed you that my script will work with output screenshot
you need to set answer variable in user criteria script field
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader