GlideElement- Global

var gr = new GlideRecord('problem');

// Get records in new state in Problem Table
gr.addQuery('state','101');

// Sort records in order of recent to earlier Created Date
gr.orderByDesc('sys_created_on');

// Limit the query to three records
gr.setLimit(3); 
gr.query();

while(gr.next()){
  if(gr.short_description.canCreate()){ ///check to see if the current user is allowed to create the record
  gs.info("I can create new records for the field Problem statement for - " + gr.number);
  }
}

I can create new records for the field Problem statement for - PRB0000004
I can create new records for the field Problem statement for - PRB0001000
I can create new records for the field Problem statement for - PRB0001001

var grIncident = new GlideRecord('incident');
grIncident.addEncodedQuery("active=true"); //Query the Incident table for active incidents
grIncident.orderByDesc('number');
grIncident.setLimit(3); // limit to three results for example
grIncident.query();

while (grIncident.next()) {
    if (grIncident.short_description.canRead()) { //check to see if the current user is allowed to read the record
        gs.info('You have permission to read the short description of: ' + grIncident.number + ' ' + grIncident.short_description);
    }
}

*** Script: You have permission to read the short description of: INC0009009 Unable to access the shared folder.
*** Script: You have permission to read the short description of: INC0009005 Email server is down.
*** Script: You have permission to read the short description of: INC0009001 Unable to post content on a Wiki page

var grIncident = new GlideRecord('incident');
grIncident.addEncodedQuery("active=true"); //Query the Incident table for active incidents
grIncident.orderByDesc('number');
grIncident.setLimit(3); // limit to three results for example
grIncident.query();

while (grIncident.next()) {
    if (grIncident.short_description.canWrite()) { //check to see if the current user is allowed to write to the record
        gs.info('You have permission to write to the short description of: ' + grIncident.number + ' ' + grIncident.short_description);
    }
}

*** Script: You have permission to write to the short description of: INC0009009 Unable to access the shared folder.
*** Script: You have permission to write to the short description of: INC0009005 Email server is down.
*** Script: You have permission to write to the short description of: INC0009001 Unable to post content on a Wiki page

if (!current.assigned_to.nil() && current.assigned_to.changes()) {
  gs.eventQueue('incident.assigned', current, current.assigned_to.getDisplayValue(), previous.assigned_to.getDisplayValue());
}

if (theState.changesTo(resolvedState)) {
  operation = 4; //Resolved
}
else if (theState.changesTo(closedState)) {
  operation = 11; //Resolution Accepted
}
else if (theState.changesFrom(resolvedState) || theState.changesFrom(closedState)) {
  operation = 10; //Re-open
}
else {
  operation = 6; //Update
}

if (theState.changesTo(resolvedState)) {
  operation = 4; //Resolved
}
else if (theState.changesTo(closedState)) {
  operation = 11; //Resolution Accepted
}
else if (theState.changesFrom(resolvedState) || theState.changesFrom(closedState)) {
  operation = 10; //Re-open
}
else {
  operation = 6; //Update
}

var inc = new GlideRecord('incident');
inc.get('17c90efb13418700cc36b1422244b05d');
gs.info(inc.calendar_duration.dateNumericValue());

var now_GR = new GlideRecord('sys_user');
now_GR.query("user_name","admin");

if (now_GR.next()) {
   gs.info("The value of the tree_picker attribute in the location column is " + now_GR.location.getAttribute("tree_picker"));
}

The value of the tree_picker attribute in the location column is true

var gr = new GlideRecord('incident');

//query the Incident Records which have category as Inquiry/Help
gr.addQuery('category','inquiry');

// sort them in the order of earlier to recent created date
gr.orderBy('sys_created_on');
gr.query();

if(gr.next()){ //If at least any one record exists matching this query

  //Print the base table for the Assignment Group field
  gs.print("The Base Table for the field Assignment Group is - " + gr.assignment_group.getBaseTableName()); 
};

The Base Table for the field Assignment Group is - task

var inc = new GlideRecord('incident');
inc.query();

if (inc.next())
 {
   // opened_by field has attribute "ignore_filter_on_new = true"
   gs.info(inc.opened_by.getBooleanAttribute("ignore_filter_on_new"));

  // short_description field does not have attribute ignore_filter_on_new
   gs.info(inc.short_description.getBooleanAttribute("ignore_filter_on_new"));
 }

true
false

var glideRecord = new GlideRecord('incident'); 
glideRecord.query('priority','1'); 
glideRecord.next(); 

// urgency has choice list: 1 - High, 2 - Medium, 3 - Low, with value: 1, 2, 3
var choices = glideRecord.urgency.getChoices();

var gr = new GlideRecord('change_request');

//query for the change records with change type as "Normal"
gr.addQuery('type','normal');

// sort them in the order of recent to earlier Created Date
gr.orderByDesc('sys_created_on'); 

// limit the query to 4 records
gr.setLimit(4); 
gr.query();

while(gr.next()){
 //Printing the choice label for those records
 gs.print("The label of the current priority '"+ gr.priority+"' for the change request - " + gr.number + " is - "+ gr.priority.getChoiceValue()); 
}

The label of the current priority '4' for the change request - CHG0000014 is - 4 - Low
The label of the current priority '4' for the change request - CHG0000013 is - 4 - Low
The label of the current priority '4' for the change request - CHG0000012 is - 4 - Low
The label of the current priority '4' for the change request - CHG0000011 is - 4 - Low

var inc_gr = new GlideRecord('incident');
inc_gr.get('985f53d82fab301032e8808cf699b6e8'); // Get a particular Incident

var field_element = inc_gr.getElement('cmdb_ci'); // Get the Configuration Item element
var dependent_field = field_element.getDependent(); // Read the dependent field
gs.info("Dependent field: " + dependent_field);
if(dependent_field)
  {
    var dependent_field_value = inc_gr.getValue(dependent_field);  
    if(!dependent_field_value)
      {
        var base_table = field_element.getRefRecord(); // Retrieve the reference record
        var dependent_field_value = base_table.getValue(dependent_field); // Read the parent field value
      }
    inc_gr.setValue(dependent_field, dependent_field_value); // Update the parent field on the Incident
    inc_gr.update();
  }

company

var gr = new GlideRecord('cmdb_ci_hardware');
gr.setLimit(1);
gr.query();

if (gr.next()) {
    var field_element = gr.getElement('model_id'); // Get the model_id field element
    var dependent_table = field_element.getDependentTable(); // Get the table that drives filtering

    gs.info("Field: " + field_element.getLabel());
    gs.info("Dependent table: " + dependent_table); // cmdb_model_category

    if (dependent_table) {
        // Use the dependent table to query what's controlling the filter
        var dep_gr = new GlideRecord(dependent_table);
        if (dep_gr.get(gr.getValue('model_category'))) {
            gs.info("Controlling record: " + dep_gr.getDisplayValue());
            gs.info("Only models belonging to category '" + dep_gr.getDisplayValue() + "' are valid for this CI");
        }
    }
}

Field: Model ID
Dependent table: null

var fields = current.getFields();
for (var i = 0; i < fields.size(); i++) { 
  var field = fields.get(i);
  var name = field.getName(); 
  var value = field.getDisplayValue(); 
  gs.print(i + ". " + name + "=" + value); 
}

var gr = new GlideRecord('incident');
gr.addQuery('active', true);      // get the active records
gr.orderByDesc('sys_updated_on'); // sort the records from most recent to oldest updated date
gr.setLimit(2);                   // limit the query to 2 records
gr.query();

while(gr.next()){ // Printing the Display Value of the Configuration Item field. 
  // If the Display Value is Null/Empty, then it will be substituted with Default value "I with Null/Empty Display Value"
  gs.info("The Display Value of the Configuration Item for the incident - "+ gr.number+ " is " + gr.cmdb_ci.getDisplayValueExt(40, " CI with Null/Empty Display Value"));
}

The Display Value of the Configuration Item for the incident - INC0007001 is  CI with Null/Empty Display Value
The Display Value of the Configuration Item for the incident - INC0000069 is NYC RAC

var uiView = new GlideRecord("sys_ui_view");
uiView.get("fa776f6d97700100f309124eda2975bc");

gs.info("getDisplayValue: " + uiView.getElement("title").getDisplayValue());
gs.info("getDisplayValueLang: " + uiView.getElement("title").getDisplayValueLang("de"));

getDisplayValue: Accept
getDisplayValueLang: Akzeptieren

var gr_Inc = new GlideRecord('incident');
gr_Inc.query();
if(gr_Inc.next()) {
    var attr = gr_Inc.getDynamicAttribute('inc_dynamic_schema->make');
    gs.info(attr.getValue());
}

var gr_Inc = new GlideRecord('incident');
gr_Inc.query();
if (gr_Inc.next()) {
    var ge_Make = gr_Inc.getElement('inc_dynamic_schema->make');
    var namespace = ge_Make.getDynamicNamespace();

    gs.info("toString:    " + namespace);
    gs.info("name:        " + namespace.getName());
    gs.info("isActive:    " + namespace.isActive());
    gs.info("isTransient: " + namespace.isTransient());
}

toString:    incident/inc_dynamic_schema
name:        incident/inc_dynamic_schema
isActive:    true
isTransient: false

// Gets the name of the namespace from the inc_dynamic_schema dynamic_attribute_store column on the incident table

var gr_Inc = new GlideRecord('incident');
gr_Inc.query();
if (gr_Inc.next()) {
    var ge_Make = gr_Inc.getElement('inc_dynamic_schema->make');
    gs.info(ge_Make.getDynamicNamespaceName());
}

number,short_description,active

var fields = current.getFields();
for (i=0; i<fields.size(); i++) { 
  var field = fields.get(i);
  var descriptor = field.getED(); 
  gs.print("type=" + descriptor.getType() + 
    " internalType=" + descriptor.getInternalType()); 
}

var fields = current.getFields();
for (var i = 0; i < fields.size(); i++) {
  var field = fields.get(i);
  var name = field.getName();

  // Returns the unformatted value of the element
  var value = field.getElementValue(name);
  var disValue = field.getDisplayValue();
  gs.print(i + ". " + name + " = " + value + ' display value = ' + disValue);
}

1. cmdb_ci = 109562a3c611227500a7b7ff98cc0dc7 display value = Storage Area Network 001
2. impact = 2 display value = 2 - Medium

var incidentGR = new GlideRecord('incident');
incidentGR.setLimit(1);
incidentGR.query();
if (incidentGR.next()) {
    incidentGR.short_description.setError('The description is too short.');
    gs.info(incidentGR.short_description.getError()); // 'The description is too short.'
}

The description is too short.

// Before query business rule (order = 100)
(function executeRule(current, previous /*null when async*/) {
    var shortDescription = current.getValue('short_description');
    if (shortDescription.length < 10) {
        current.short_description.setError('The description is too short.');
        current.setAbortAction(true);
    }
})(current, previous);

// Before query business rule (order = 200)
(function executeRule(current, previous /*null when async*/) {
    var shortDescriptionErrMsg = current.short_description.getError();
    if (shortDescriptionErrMsg) {
        // Some error was set in one of the previous business rules.
    }
})(current, previous);

/*** Overview - Update incident short description with escape characters and printing ***/
var inc = new GlideRecord('incident');
inc.query();
inc.next();
inc.short_description = 'Can\'t log into SAP from my laptop today'; 
inc.update();
gs.info("Short Description: "+inc.getElement('short_description').toString()); //without escape characters
gs.info("Escaped Short Description: "+inc.getElement('short_description').getEscapedValue()); // with escape characters

Short Description: Can't log into SAP from my laptop today
Escaped Short Description: Can\'t log into SAP from my laptop today

var fields = current.getFields();
for (var i = 0; i < fields.size(); i++) { 
  var field = fields.get(i);
  var css_style = field.getFieldStyle();  
  gs.print("CSS style" + "=" + css_style); 
}

// Query an incident record with both opened_at and sla_due populated
var incGr = new GlideRecord('incident');
incGr.addQuery('opened_at', '!=', '');
incGr.addQuery('sla_due', '!=', '');
incGr.setLimit(1);
incGr.query();

if (incGr.next()) {
    gs.info("Incident: " + incGr.getValue('number'));
    gs.info("Opened at: " + incGr.getValue('opened_at'));
    gs.info("SLA due: " + incGr.getValue('sla_due'));

    var duration = calcDateDelta(incGr.opened_at, incGr.sla_due);
    if (duration) {
        gs.info("Duration in seconds: " + duration.getNumericValue() / 1000);
        gs.info("Duration display value: " + duration.getDisplayValue());
    }
}

function calcDateDelta(start, end) {
    var realStart = start.getGlideObject();
    var realEnd = end.getGlideObject();

    // Use GlideDuration to calculate the difference between two GlideDateTime objects
    var startMS = realStart.getNumericValue();
    var endMS = realEnd.getNumericValue();
    var deltaMS = endMS - startMS;

    // Create a GlideDuration from the millisecond difference
    var duration = new GlideDuration(deltaMS);
    return duration;
}

Incident: INC0000031
Opened at: 2025-03-06 00:18:03
SLA due: 2025-03-06 08:18:03
Duration in seconds: 28800
Duration display value: 8 Hours

var grInc = new GlideRecord('incident');
grInc.get('sys_id','ef43c6d40a0a0b5700c77f9bf387afe3');
gs.info("Initial grInc - " + grInc.getDisplayValue());

var caller = grInc.getElement("caller_id");
doit(caller);

function doit(caller) {
  var now_GR = caller.getGlideRecord();
  gs.info("doit gr is - " + now_GR.getDisplayValue());
}

*** Script: Initial grInc - INC0000050
*** Script: doit gr is - INC0000050

/*
  getHTMLValueExt() This Function is used to get HTML Value of a field. It accepts 2 Parameters

a. maxChar- Number - The maximum number of characters to return.
b. nullSub - String - The value to return if the HTML value is null or empty.

*/


// get a cab meeting record by its sys_id
var gr = new GlideRecord('cab_meeting');
gr.addQuery('sys_id','7777777b6d2a20100sys70id534330f6');
gr.query();

if(gr.next()){
  var substituteString = 'Meeting Notes Unavailable';
  var maxLength = 50;
  gs.print(gr.meeting_notes.getHTMLValueExt(maxLength, substituteString));
}

// get a cab meeting record by its sys_id
var gr = new GlideRecord('cab_meeting');
gr.addQuery('sys_id','7777777b6d2a20100sys70id534330f6');
gr.query();

if(gr.next()){
  var substituteString = 'Meeting Notes Unavailable';
  var maxLength = 50;
  gs.print(gr.meeting_notes.getHTMLValueExt(maxLength, substituteString));
}

<p>Meeting note content.</p>

//gets all journal entries as a string where each entry is delimited by '\n\n'
var notes = current.work_notes.getJournalEntry(-1); 
//stores each entry into an array of strings
var na = notes.split("\n\n");  

for (var i = 0; i < na.length; i++)                 
  gs.print(na[i]);

var now_GR = new GlideRecord("sc_req_item");
now_GR.addQuery("request", current.sysapproval);
now_GR.query();
while(now_GR.next()) {
    var nicePrice = now_GR.price.toString();
    if (nicePrice != ) {
        nicePrice = parseFloat(nicePrice);
        nicePrice = nicePrice.toFixed(2);
    }
    template.print(now_GR.number + ":  " + now_GR.quantity + " X " + now_GR.cat_item.getDisplayValue() + " at $" + nicePrice + " each \n");
    template.print("    Options:\n");
    var variables = now_GR.variables.getElements();    
    for (var key in variables) {
      var now_V = variables[key];
      if(now_V.getQuestion().getLabel() != ) {
         template.space(4);
         template.print('     ' +  now_V.getQuestion().getLabel() + " = " + now_V.getDisplayValue() + "\n");  
      }
    }
}

var uiView = new GlideRecord("sys_ui_view");
uiView.get("fa776f6d97700100f309124eda2975bc");

gs.info("getLabel: " + uiView.getElement("title").getLabel());
gs.info("getLabelLang: " + uiView.getElement("title").getLabelLang("de"));

getLabel: Title
getLabelLang: Titel

var userRec = new GlideRecord("sys_user"); // GlideRecord to sys_user table

userRec.get("5137153cc611227c000bbd1bd8cd2005"); // Sys Id of user: Fred Luddy

var fields = userRec.getFields();

for (var i = 0; i < fields.size(); i++) {

    var field = fields.get(i);
    var name = field.getName(); // Name of the field
    var label = field.getLabel(); // Label of the field
    var value = field.getDisplayValue(); // Value of the field

    gs.info((Number(i) + 1) + ".\n" + "Field Label: " + label + "\n" + "Field Name: " + name + "\n" + "Field Value: " + value);

};

*** Script: 1.
Field Label: Country code
Field Name: country
Field Value: 
*** Script: 2.
Field Label: Calendar integration
Field Name: calendar_integration
Field Value: Outlook
...
*** Script: 47.
Field Label: First name
Field Name: first_name
Field Value: Fred
...
*** Script: 54.
Field Label: Last name
Field Name: last_name
Field Value: Luddy
...

var grINC = new GlideRecord('incident'); 
grINC.notNullQuery('caller_id'); 
grINC.query(); 
if (grINC.next()) { 

// Get a GlideRecord object for the referenced sys_user record 
var grUSER = grINC.caller_id.getRefRecord(); 
if (grUSER.isValidRecord()) 
  gs.print( grUSER.getValue('name') ); 

} 

// Get string of style field from Field Style record
var cssStyle = now_GR.state.getStyle();

if (current.approver.getTableName() == "sysapproval_approver") {
    if (current.approver == email.from_sys_id) {
        current.comments = "reply from: " + email.from + "\n\n" + email.body_text;

        // if it's been cancelled, it's cancelled.
        var doit = true;
        if (current.state == 'cancelled')
            doit = false;

        if (email.body.state != undefined)
            current.state = email.body.state;

        if (doit)
            current.update();
    } else {
        gs.log("Approval for task " + current.sysapproval.getDisplayValue() +
            " rejected because user sending email " + email.from +
            " does not match the approver " + current.approver.getDisplayValue());
    }
}

var grh = new GlideRecord('kb_knowledge');
grh.get('c85cd2519f77230088aebde8132e70c2');  // Knowledge record sys_id
var t = grh.text.getTextAreaDisplayValue(); // Text is HTML type field
var d = GlideXMLUtil.parseHTML(t); // Parse the HTML
var b = d.getDocumentElement().getTextContent().trim();
gs.info(b);

This article explains how to use automatic replies in Outlook 2010 for Exchange accounts.

Setting Up Automatic Replies

Click the 
File tab.
Click 
Automatic Replies.
Select 
Send automatic replies.
If desired, select the 
Only send during this time range check box to schedule when your out of office replies are active. If you do not specify a start and end time, auto-replies will be sent until you select the
 Do not send automatic replies check box.
On the 
Inside My Organization tab, type the response that you want to send to colleagues while you are out of the office.
On the 
Outside My Organization tab, select the 
Auto-reply to people outside my organization check box, and then type the response that you want to send while you are out of the office. Select whether you want replies sent to 
My contacts only or to 
Anyone outside my organization who sends you messages.

NOTE:
If you select 
My Contacts only in step 6, replies will be sent 
only to contacts that exist in your Contacts folder.



Using Rules With Automatic Replies
It is also possible to use rules to manage your messages while you are out of office. For example, you can create rules to automatically move or copy messages to other folders, to delete messages, to send custom replies, and so on.

Click the 
File tab.
Click 
Automatic Replies.
Click 
Rules, and then click 
Add Rule.
Under 
When a message arrives that meets the following conditions, specify the conditions that the message must meet for the rule to be applied. If you want to specify more conditions, click 
Advanced, enter or select the options that you want, and then click 
OK.
If you want to specify that this rule must be applied last, select the 
Do not process subsequent rules check box.
Under 
Perform these actions, select the actions that you want. You can select more than one action.
Click 
OK three times.

NOTES:

Automatic Replies rules can also be edited by following the above procedure.
To turn Automatic Replies rules on or off, in the Automatic Reply Rules dialog box, select or clear the check box of the rule that you want to turn on or off.

var now_GR = new GlideRecord('incident');
now_GR.get('9c573169c611228700193229fff72400'); //INC0000001
gs.info('Display Values');
gs.info('Opened at ' + now_GR.opened_at.getDisplayValue());
gs.info('Opened by ' + now_GR.opened_by.getDisplayValue());
gs.info('Priority ' + now_GR.priority.getDisplayValue());
gs.info('Values');
gs.info('Opened at ' + now_GR.opened_at.getValue());
gs.info('Opened by ' + now_GR.opened_by.getValue());
gs.info('Priority ' + now_GR.priority.getValue());

Display Values
Opened at 2022-02-01 15:09:51
Opened by Joe Employee
Priority 1 - Critical
Values
Opened at 2022-02-01 23:09:51
Opened by 681ccaf9c0a8016400b98a06818d57c7
Priority 1

var fields = new GlideRecord('sys_user');

fields.query();

var userFields = fields.getFields();

for (var num = 0; num < userFields.size(); num++) {
    var ed = userFields.get(num).getED();

    if (ed.hasAttribute("edge_encryption_enabled")) {
        gs.info(userFields.get(num).getName());
    }
}

*** Script: hashed_user_id
*** Script: federated_id

// Pass table name and userId to check if user has read access against given table name
checkAccess('incident', 'adela.cervantsz');

function checkAccess(tableName, userID) {

    var inc = new GlideRecordSecure(tableName);
    inc.get('$[sys_id]');

    var secureManager = GlideSecurityManager.get();

    //fetch a different user, using user_name field on the target user record
    var userObj = gs.getUser().getUserByID(userID); 
    secureManager.setUser(userObj);

    var access = 'record/incident/read';

    //check if user has right to access
    var canRead = secureManager.hasRightsTo(access, inc); 
    gs.info('canRead: ' + canRead);
}

canRead: false

if (current.start_date.changes() || current.end_date.changes() || current.assigned_to.changes()) { 
  if (!current.start_date.nil() && !current.end_date.nil() && !current.assigned_to.nil()) {
 gs.eventQueue("change.calendar.notify", current, current.assigned_to, previous.assigned_to);

}

var inc = new GlideRecord('incident');
inc.get('17c90efb13418700cc36b1422244b05d');
var timems = inc.calendar_duration.dateNumericValue();
timems = timems + 11*1000; 
inc.calendar_duration.setDateNumericValue(timems)
gs.info(inc.calendar_duration.getValue());

1970-01-01 00:01:38

if ((!current.u_date1.nil()) && (!current.u_date2.nil())) {
  var start = current.u_date1.getGlideObject().getNumericValue();
  var end = current.u_date2.getGlideObject().getNumericValue();
  if (start > end) {
    gs.addInfoMessage('start must be before end');
    current.setAbortAction(true);
    current.u_date1.setError('start must be before end');
  }
}

var now_GR = new GlideRecord("incident");

now_GR.addQuery("sys_id", "<sys_id_value>");
now_GR.query();

if(now_GR.next()){
  now_GR.work_notes.setJournalEntry("Content of the journal entry.", "abel.tuter");  
  now_GR.update();
}

var glideRecord = new GlideRecord('incident');
glideRecord.query('priority','1');
glideRecord.next();
glideRecord.short_description.setValue('Network failure');

var now_GR  = new GlideRecord('student');
now_GR.initialize();
now_GR.setValue('first_name', 'Joe');
now_GR.setValue('last_name', 'Smith');
now_GR.insert();

doit();

function doit() { 

  var now_GR = new GlideRecord('sys_user');
  now_GR.query();
  while (now_GR.next()) {
  if ((now_GR().length != now_GR.first_name.toString().trim().length) || (now_GR.last_name.toString().length 
         != now_GR.last_name.toString().trim().length)) {
      now_GR.first_name = now_GR.first_name.toString().trim();
      now_GR.last_name = now_GR.last_name.toString().trim();
      now_GR.autoSysFields(false);
      now_GR.update();
    }
  }

}