1. Create a BR on Change Table. a. State = Scheduled Advanced: use glide time

---

0 Helpfuls

- You can either use Flow Designer or Scheduled Job. - Schedule it to execute daily. - Glide into 'Change' table and check if planned start date = todays date and state=scheduled then update change state to 'implement'

---

0 Helpfuls

Basically you can write one Scheduled job that runs daily and check those whose Planned Start date is today and if records matches conditions then update the state of those records to implement . Below is the sample code var changeReqs = new GlideRecord('change_request'); changeReqs.addEncodedQuery('start_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()'); changeReqs.query(); while(changeReqs.next()){ changeReqs.setValue('state',-1); changeReqs.update(); }

---

0 Helpfuls

var gr = new GlideRecord('sys_user_has_role'); gr.addQuery('user','6816f79cc0a8016401c5a33be04be441') gr.query(); gs.print(gr.getRowCount()); while(gr.next()) { //one way to do it }

---

0 Helpfuls

var userid = gs.getUserID(); var gr = new GlideRecord('sys_user_has_role'); gr.addQuery('user.sys_id', userid); gr.query(); while(gr.next()){ gs.print(gr.role.getDisplayValue()); gs.print(gr.getRowCount()); }

---

0 Helpfuls

Whenever we have to find out count of something then it is recommended to use GlideAggregate API, using GlideRecord API with getRowCount method is not efficient and it is not considered as best practice. Therefore you can rather use below code. var userid = gs.getUserID(); var gaRoleCount=new GlideAggregate("sys_user_has_role"); gaRoleCount.addQuery("user",userid); gaRoleCount.addAggregate("COUNT","role"); gaRoleCount.query(); if(gaRoleCount.next()){ gs.print("Role Count for logged in user:" gaRoleCount.getAggregate("COUNT","role"); }

---

1 Helpfuls

Thanks

---

0 Helpfuls

Hi Ria, In 4th line you are grouping the count by role which is incorrect it should be only gaRoleCount.addAggregate("COUNT"); Check below code for more info var userid = gs.getUserID(); var gaRoleCount=new GlideAggregate("sys_user_has_role"); gaRoleCount.addQuery("user",userid); gaRoleCount.addAggregate("COUNT"); gaRoleCount.query(); if(gaRoleCount.next()){ //gs.print(gs.getUserName()) //gs.print(userid) gs.print("Role Count for logged in user:" gaRoleCount.getAggregate("COUNT")); }

---

1 Helpfuls

gs.print("Role Count for logged in user:" gaRoleCount.getAggregate("COUNT")) in this line was error in background script, Please once check it Tank You..

---

0 Helpfuls

var a=gs.getUser().getRoles(); gs.log(a); gs.log(a.size());

---

0 Helpfuls

g_scratchpad is used only in Onload Client scripts to get the data from Display business rule.

---

1 Helpfuls

In most of the use cases, we access it in onLoad client script. However g_scratchpad object can be accessed in all type of client scripts. In fact it can be accessed in UI policy script also. Here is very important use case where it can be used in on submit client script, if we want to validate something on submit of the form but data is not available on client side. Normally we use GlideAjax to get server side data but GlideAjax fails in onSubmit client script (GlideAjax is asynchronous call therefore form gets submitted before GlideAjax returns result). Therefore we can store result in g_scratchpad object in onChange client script and based on value we can restrict form submission in on submit client script.

---

0 Helpfuls

g_scratchpad is sent once when a form is loaded (information is pushed from the server to the client), whereas GlideAjax is dynamically triggered when the client requests information from the server. If you're using getReference you will get ALL data for each record you "get" whether you need it or not.

---

0 Helpfuls

Affected CI's are the CI's which are affected by associated change. This CI's are later considered to populate Impacted CI's or services. More Details Here : https://docs.servicenow.com/en-US/bundle/sandiego-it-service-management/page/product/change-management/concept/c_AffectedCIsAndImpactedServices.html

---

0 Helpfuls

You can find the "Column Level Encryption." course in Now Learning. To encrypt the attachment or particular field.

---

0 Helpfuls

Multirow Variable set is used to capture variable data in a grid layout while submitting a catalog item request for a group of entities. It is very useful when you want to create multiple order in one request.

---

0 Helpfuls

Whenever you need data in client script which is not available on the form then you will need to get it from server database. And to do so we can use GlideAjax. OR if you need to perform any operation/validation which requires server side script then we need to use GlideAjax.

---

0 Helpfuls

- We can execute client script on submit or on cell edit (list field update) but we cannot execute UI policy on submit or on cell edit. - We can execute client script for specific view but we cannot do the same via UI Policy. - UI Policies are faster as compare to Client scripts, therefore ServiceNow recommends to use UI Policies wherever possible.

---

0 Helpfuls

UI Policies can be run for a specific view if you uncheck the Global field and then enter the view name you need.

---

1 Helpfuls

Hi William We can execute client script or UI policy for the specific view as well.

---

0 Helpfuls

All Inbound actions process according to the order value defined. When "Stop Processing" checkbox is set to true it will stop processing further inbound email actions.

---

0 Helpfuls