Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Example script: A default before-query business rule

Example script: A default before-query business rule

You can use a query business rule that executes before the database query is made to prevent users from accessing certain records.

Caution: The customization described here was developed for use in specific instances, and is not supported by ServiceNow. This method is provided as-is and should be tested thoroughly before implementation. Post all questions and comments regarding this customization to our community forum.

Consider the following example from a default business rule that limits access to incident records.

Table 1. Default business rule limits access to incident records
Name Table When
incident query Incident before, query

Example script

This example prevents users from accessing incident records unless they have the itil role are listed in the Caller or Opened by field. So, for example, when self-service users open a list of incidents, they can only see the incidents they submitted.
if(!gs.hasRole("itil")&& gs.isInteractive()){
  var u = gs.getUserID();
  var qc = current.addQuery("caller_id", u).addOrCondition("opened_by", u).addOrCondition("watch_list","CONTAINS", u);
  gs.print("query restricted to user: "+ u);}
Note: You can also use access controls to restrict the records that users can see.

Schedule script for weekdays

Type: Business Rules/Client Scripts

This script schedules the script for weekdays. Insert any script where it says "Your Script Here."
var go ='false';
var now =new Date(); 
// Correct time zone, which is by default GMT -7 
var day = now.getDay(); 
// No go on Saturday or Sunday 
if(day !=0&& day !=6){
// (your script here)

Set date field according to current date

This script sets a date field depending on the current day of the week. In this example, if the day is Monday through Wednesday, it sets the date to this coming Monday; otherwise it sets the date field to next Monday.
function setCabDate(){
var today =new Date();
var thisDay = today.getDay();
//returns 0 for Sunday, 1 for Monday, etc. thru 6 for Saturday.
var thisMon =new GlideDateTime();
var nextMon = thisMon.getNumericValue();
nextMon +=(1000*60*60*24*7);
if((thisDay <4)&&(thisDay >0))
  //if today is Mon thru Wed (thisDay = 1, 2, or 3), set cab to this coming Monday.
elseif((thisDay >=4)||(thisDay ==0))
  //if today is Thurs thru Sun (thisDay = 4, 5, 6, or 0), set cab to next Monday.

To validate the input of all date/time fields, you can use the following in a validation script (System Definition > Validation Scripts). Because the date/time format is hard coded in this script, it must match your instance's date/time format. If your instance's date/time format changes, you must update your validation script.

Set the validation script's type to Date/Time. Then, with this validation script, if a user enters an incorrect format in a date/time field, they will receive an error message.
function validate(value){
// empty fields are still valid dates 
// We "should" have the global date format defined always defined. but there's always that edge case... 
if(typeof g_user_date_time_format !=='undefined')return isDate(value, g_user_date_time_format); 
// if we don't have that defined, we can always try guessing 
return parseDate(value)!==null;}
Figure 1. Date/time validation