SNOW-CAD Working with Data — All Questions With Answers

if (!gr.isNewRecord()) {
  gr.setAbortAction(true);
  gs.addErrorMessage('Update not allowed');
}

{
  "import_set": "ISET001",
  "staging_table": "u_cmdb_ci_computer_staging",
  "target_table": "cmdb_ci_computer",
  "field_map": [
    {"source": "u_name", "target": "name"},
    {"source": "u_serial_number", "target": "serial_number"},
    {"source": "u_model_id", "target": "model_id", "coalesce": true}
  ]
}

{"name":"Mandatory short description","table":"incident","field":"short_description","mandatory":true,"conditions":{"op":"and","conditions":[{"field":"state","op":"=","value":"1"}]}}

{
    "name": "incident.update",
    "table": "incident",
    "rules": [
        {
            "type": "condition",
            "script": "current.state == 3 && gs.hasRole('itil')"
        }
    ],
    "action": "update"
}

{
  "name": "Enforce Mandatory for VIP",
  "table": "incident",
  "conditions": [
    {
      "condition": "caller_id.name = 'VIP'",
      "mandatory": "short_description"
    }
  ]
}

var gr = new GlideRecord('incident');
gr.addQuery('active', true);
gr.addQuery('priority', '1');
gr.setLimit(10);
gr.query();
while(gr.next()) {
  gs.info(gr.number);
}

function transformEntry(source, target) {
    if (source.u_department != '') {
        target.department = source.u_department;
    }
}