DEVELOPER TIP: The Admin overrides option in Access Control configuration grants access to the admin user even if the admin user doesn’t meet the requirements of the Access Control. Use caution when testing Access Controls as the admin user as it may not be indicative of the Access Control’s behavior.
)
appears next to each field. Hover over the Debug icon to see how many
Access Control messages there are for the field. Click the Debug icon to
see the Access Controls for that field. This strategy, obviously,
cannot be used to debug fields that are hidden by Access Controls.
if (!gs.hasRole("admin") && !gs.hasRole("user_admin") && gs.getSession().isInteractive()) {
answer = true;
}
else{
answer = false;
}
| Script Type | Executes on | Description | Often used to |
|---|---|---|---|
| Business Rule | Database access | Execute logic when records are queried, updated, inserted, or deleted. | Validate data or set fields on other records in response to fields on the current record. |
| Script Include | Must be explicitly called | A library of reusable functions. | Validate format, retrieve shared records, and work with application properties. |
| Script Action | Events | Respond to an event. | Send email notifications or write logging information. |
| Scheduled Script Execution (also known as a Scheduled Job) | Time | Script logic executed on a time-based schedule. | Create reports: send daily, weekly, monthly, quarterly, and annual information. Execute script logic only on weekdays or weekends. Can also be run on demand so sometimes used for testing. |
| UI Actions | Users | Add buttons, links, and context menu items to forms and list to allow users to perform application-specific operations. | Enable users to perform actions such as navigating to another page, modifying records, or allowing operations such as saving. |
| Scripts - Background | admin users only (some instances require the security_admin role) | Execute server-side code on demand from a selectable scope. Scripts - Background should be used with caution because badly written scripts can damage the database. | Test scripts. |
| Fix Scripts | Application installation or upgrade | Make changes that are necessary for the data integrity or product stability. | Create or modify groups or user authorizations. |
| Notification Email Script | Notification | Execute when emails are generated to add content to the email content or configuration. | Add a CC or BCC email address, or query the database and write information to the message body. |
| Scripted REST APIs | Request sent or received through web services | Defines a web service endpoint | Return value(s) or a JSON object based on a calculation or database lookup(s) |
| UI Page Processing Script | Users | Executes when a UI Page is submitted. | Validating data, setting values etc. |
| Transform Map Script | Data import | Modifies or copies data or data format when records are imported. | Standardize date formats, fill in missing data, standardize values, map incoming values to database values for choice lists, set default values. |
isDatePast: function(strDate){
// Create GlideDateTime objects for the current date and the passed in date
var rightnow = new GlideDateTime();
var testdate = new GlideDateTime(strDate);
// If the testdate is before rightnow, return true, else return false
if (testdate.before(rightnow)) {
return true;
}
else {
return false;
}
}, Calling this from another business rules something like this below: // Instantiate the NeedItUtils class. Call the isDatePast method and pass
// the u_when_needed value.
var niutils = new NeedItUtils();
var isPast = niutils.isDatePast(current.u_when_needed);
// If the isDatePast method returns true, the date is in the past.
if(isPast == true){
gs.addErrorMessage("When needed date cannot be in the past. Your request has not been saved to the database.");
current.setAbortAction(true);
} var GetEmailAddress = Class.create();
// Extend the global.AbstractAjaxProcessor class
GetEmailAddress.prototype = Object.extendsObject(global.AbstractAjaxProcessor,{
// Define the getEmail function.
// Create a GlideRecord for the User table.
// Use the sysparm_userID passed from the client side to retrieve a record from the User table.
// Return the email address for the requested record
getEmail: function() {
var userRecord = new GlideRecord("sys_user");
userRecord.get(this.getParameter('sysparm_userID'));
return userRecord.email + '';
},
type: 'GetEmailAddress'
});function onChange(control, oldValue, newValue, isLoading, isTemplate) {
// Modified the if to return if the newValue == oldValue to avoid
// unecessary trips to the server
if (isLoading || newValue === '' || newValue == oldValue) {
return;
}
// Instantiate the GetEmailAddress Script Include
var getEmailAddr = new GlideAjax('GetEmailAddress');
// Specify the getEmail method
getEmailAddr.addParam('sysparm_name','getEmail');
// Pass the Requested for sys_id
getEmailAddr.addParam('sysparm_userID', g_form.getValue('u_requested_for'));
// Send the request to the server
getEmailAddr.getXML(populateEmailField);
// When the response is back from the server
function populateEmailField(response){
// Extract the email address from the response, clear any value from the email field,
// set new value in the email field
var emailFromScriptInclude = response.responseXML.documentElement.getAttribute("answer");
g_form.clearValue('u_requested_for_email');
g_form.setValue('u_requested_for_email',emailFromScriptInclude);
}
}
) to configure the new field.
).QUESTION: You could write the validation logic in the Business Rule instead of using a Script Include. Given that, why use a Script Include? If you aren’t sure, scroll to the Answers section at the bottom of this page.
) and select the Save menu item. Do not click the Submit or Update buttons because that will take you away from the form.) and select the Save menu item.) and select the Save menu item. There should be no error message.Question: Why not write the email syntax validation in the Business Rule and not in the Script Include?Answer: Many applications or even tables within the same application will have email fields. Instead of writing the same logic for each application or table, create a Script Include that is accessible by all application scopes. This allows you to write the validation script logic only once.
Question: Why do you have to reload the main ServiceNow browser window?Answer: You added a field to the NeedIt Default view. ServiceNow had to be reloaded to display the new field on the NeedIt form.
) in the Script editor toolbar.
gs.error("The value of the Short description field is " + short_description);
NOTE: There are some useful methods for managing dates in the GlideSystem API also. For example, gs.daysAgo().
// 1. Create an object to store rows from a table
var myObj = new GlideRecord('table_name');
// 2. Build query
myObj.addQuery('field_name','operator','value');
myObj.addQuery('field_name','operator','value');
// 3. Execute query
myObj.query();
// 4. Process returned records
while(myObj.next()){
//Logic you want to execute.
//Use myObj.field_name to reference record fields
}NOTE: The GlideRecord API discussed here is a server-side API. There is a client-side GlideRecord API for global applications. The client-side GlideRecord API cannot be used in scoped applications.
// iterate through all records in the GlideRecord and set the Priority field value to 4 (low priority).
// update the record in the database
while(myObj.next()){
myObj.priority = 4;
myObj.update();
}// Set the Priority field value to 4 (low priority) for the first record in the GlideRecord
// update the record in the database
if(myObj.next()){
myObj.priority = 4;
myObj.update();
}// When using updateMultiple() use the setValue() method. If you do myObj.priority = 4, ALL
// records in the table will be updated and not just the GlideRecord records.
myObj.setValue('priority',4);
myObj.updateMultiple();// If you need to know the row count for a query on a production instance do this
var count = new GlideAggregate('x_snc_needit_needit');
count.addAggregate('COUNT');
count.query();
var recs = 0;
if (count.next()){
recs = count.getAggregate('COUNT');
}
gs.info("Returned number of rows = " +recs);
// Don't do this on a production instance.
var myObj = new GlideRecord('x_snc_needit_needit');
myObj.query();
gs.info("Returned record count = " + myObj.getRowCount());var myObj = new GlideRecord("x_snc_needit_needit");
myObj.addEncodedQuery('<your_encoded_query>');
myObj.query();
while(myObj.next()){
// Logic you want to execute for the GlideRecord records
}
var myObj = new GlideRecord("x_snc_needit_needit");
myObj.addEncodedQuery("u_when_neededBETWEENjavascript:gs.daysAgoStart(0)@javascript:gs.quartersAgoEnd(1)^active=true^state=14^ORstate=16");
myObj.query();
while(myObj.next()){
// Logic you want to execute for the GlideRecord records
}