L’exemple suivant montre comment déterminer si l’utilisateur dispose des autorisations nécessaires pour créer des entrées pour les trois enregistrements les plus récents de la table Problème [problem].

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);
  }
}

Sortie :

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

L’exemple suivant montre comment obtenir une liste des enregistrements d’incidents actifs avec un champ Description brève lisible.

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);
    }
}

Sortie :

*** 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

L’exemple suivant montre comment obtenir une liste d’enregistrements d’incidents actifs avec un champ Description brève accessible en écriture.

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);
    }
}

Sortie :

*** 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

L’exemple suivant, tiré d’une règle métier, montre comment créer un événement dans EventQueue si la valeur du champ assigned_to change. Pour un exemple complet, reportez-vous à .Sample scripts from the change events business rule

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());

Sortie : 98000

L’exemple suivant montre comment obtenir la valeur de l’attribut tree_picker dans la colonne de la location table User [sys_user] en tant que chaîne.

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"));
}

Sortie :

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

L’exemple suivant montre comment utiliser la table de base pour le champ Groupe d’affectation d’un enregistrement d’incident.

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()); 
};

Sortie :

The Base Table for the field Assignment Group is - task

L’exemple suivant montre comment obtenir des valeurs booléennes de l’attribut ignore_filter_on_new pour deux champs.

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"));
 }

Sortie :

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();

L’exemple suivant montre comment obtenir l’étiquette de choix pour les enregistrements de demande de changement avec la valeur de priorité a Normal.

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()); 
}

Sortie :

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

L’exemple suivant montre comment trouver le champ parent du champ Élément de configuration à l’aide de la méthode getDependent( ).

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();
  }

Sortie :

company

L’exemple suivant montre comment déterminer si un champ nommé model_id a une table dépendante.

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");
        }
    }
}

Sortie :

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); 
}

L’exemple suivant montre comment afficher les deux enregistrements actifs les plus récents dans la table Incident [incident].

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"));
}

Sortie :

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

L’exemple suivant montre comment obtenir le texte d’origine et le texte traduit en allemand à partir du champ de titre Accepter (vue de l’interface utilisateur).

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"));

Sortie :

getDisplayValue: Accept
getDisplayValueLang: Akzeptieren

L’exemple suivant montre comment obtenir les valeurs de l’attribut make à partir de la colonne de stockage d’attributs dynamiques u_inc_dynamic_schema sur la table d’incidents.

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());
}

L’exemple suivant montre comment récupérer l’objet d’espace de noms configuré pour la colonne de stockage d’attributs dynamiques inc_dynamic_schema sur la table d’incidents.

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());
}

Sortie :

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

L’exemple suivant montre comment renvoyer le nom de l’espace de noms de l’attribut dynamique.

// 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());
}

Sortie :

number,short_description,active

Cet exemple permet d’obtenir les champs et les descripteurs de champ pour l’enregistrement actuel.

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);
}

Sortie

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

Cet exemple montre comment définir une erreur sur l’élément short_description, puis relire l’erreur.

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.'
}

Sortie :

The description is too short.

Cet exemple montre comment l’utiliser getError() dans un appel de fonction.

// 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);

L’exemple suivant montre comment utiliser la méthode getEscapedValue() pour afficher le contenu d’un champ de description brève d’incident avec des caractères d’échappement.

/*** 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

Sortie :

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); 
}

L’exemple suivant montre comment calculer la durée entre la date d’ouverture et la date d’échéance de l’accord sur les niveaux de service (SLA) d’un enregistrement d’incident.

// 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;
}

Sortie :

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());
}

Sortie

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

L’exemple suivant montre comment obtenir le contenu HTML d’une note de réunion.

/*
  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));
}

L’exemple suivant montre comment obtenir le contenu HTML d’une note de réunion.

// 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");  
      }
    }
}

L’exemple suivant montre comment obtenir le texte de l’étiquette d’origine et sa traduction allemande du titre Accepter (vue de l’interface utilisateur).

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"));

Sortie :

getLabel: Title
getLabelLang: Titel

L’exemple suivant montre comment obtenir le nom et d’autres valeurs de chaque champ dans un enregistrement sys_user.

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);

};

Sortie. Les résultats comprennent 62 champs et ont été tronqués avec des points de suspension (...) pour économiser de l’espace.

*** 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());
    }
}

L’exemple suivant récupère la valeur d’affichage d’un article de la base de connaissances.

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);

Sortie :

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.

L’exemple suivant récupère la valeur d’un champ spécifié dans la base de données.

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());

Sortie :

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

L’exemple suivant montre comment obtenir des champs de la table Utilisateur [sys_user] avec l’attribut edge_encryption_enabled .

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());
    }
}

Sortie :

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

L’exemple suivant montre comment déterminer si un utilisateur a les droits de lecture d’une table spécifique.

// 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);
}

Sortie :

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());

Sortie :

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');
  }
}

L’exemple suivant montre comment ajouter une note de travail et son auteur à un enregistrement.

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();
}

Définir la valeur en transmettant une chaîne.

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

Définissez la valeur transmettant un objet.

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();
    }
  }
 
}