---
sourceDocument: Xanadu API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/api-reference

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# GlideRecordUtil - Global

# GlideRecordUtil - Global {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 3 minutes to read

The GlideRecordUtil script include is a utility class for working with GlideRecords.

This script include is available in server-side scripts. For use cases, see [Using discovery script includes](https://www.servicenow.com/docs/access?context=c_ScriptIncludes&version=xanadu&pubname=xanadu-application-development&ft:locale=en-US).

## GlideRecordUtil - getCIGR(String sys_id) {#ariaid-title2}

Returns the GlideRecord object for the specified configuration item (CI) using just the
sys_id of the CI.
Use this method to quickly obtain a specific CI without knowing its associated
class/table.
{#r_GRU-getCIGR_S__table_ccv_mjw_4t__entry__3}

| Name | Type | Description |
|-|-|-|
| sys_id | String | Sys_id of the desired CI. |
[Table 1. Parameters]

{#r_GRU-getCIGR_S__table_ccv_mjw_4t} {#r_GRU-getCIGR_S__table_dcv_mjw_4t__entry__2}

| Type | Description |
|-|-|
| GlideRecord | GlideRecord object of the specified CI. |
[Table 2. Returns]

{#r_GRU-getCIGR_S__table_dcv_mjw_4t}  
The following example returns the GlideRecord object for the specified CI using just the
sys_id of the CI.

    var now_GR = new GlideRecordUtil().getCIGR("2dfd7c8437201000deeabfc8bcbe5d56");

## GlideRecordUtil - getFields(GlideRecord gr) {#ariaid-title3}

Returns an array of all the fields in the specified GlideRecord.
Note:  
If there is a field name which is the same as the table name, the getFields() method does not return the value of the field.
{#r_GRU-getFields_GR__table_llf_skw_4t__entry__3}

| Name | Type | Description |
|-|-|-|
| gr | GlideRecord | GlideRecord instance positioned to a valid record. |
[Table 3. Parameters]

{#r_GRU-getFields_GR__table_llf_skw_4t} {#r_GRU-getFields_GR__table_mlf_skw_4t__entry__2}

| Type | Description |
|-|-|
| Array | Field names for the specified GlideRecord. |
[Table 4. Returns]

{#r_GRU-getFields_GR__table_mlf_skw_4t}  

    var queryString = "priority=1^ORpriority=2";
    var now_GR = new GlideRecord('incident');
    now_GR.addEncodedQuery(queryString);
    now_GR.query();
    now_GR.next();

    var gRU = new GlideRecordUtil();
    var fieldList = gRU.getFields(now_GR);
    gs.info(fieldList);

Output: Line breaks added for presentation.

    sys_id,skills,closed_by,assigned_to,contract,category,escalation,state,reassignment_count,location,
    time_worked,order,due_date,number,upon_approval,sys_tags,sla_due,follow_up,reopen_count,notify,business_stc,
    caused_by,rejection_goto,assignment_group,comments_and_work_notes,incident_state,opened_at,parent_incident,
    business_service,wf_activity,calendar_duration,group_list,caller_id,comments,priority,sys_updated_by,
    variables,delivery_task,resolved_at,sys_updated_on,parent,active,opened_by,expected_start,watch_list,
    company,upon_reject,work_notes,sys_created_by,additional_assignee_list,approval_set,cmdb_ci,user_input,
    sys_created_on,close_code,contact_type,resolved_by,rfc,approval_history,activity_due,severity,child_incidents,
    ,subcategory,work_end,closed_at,close_notes,variables,business_duration,knowledge,approval,sys_domain_path,
    sys_mod_count,problem_id,calendar_stc,work_start,sys_domain,correlation_id,sys_class_name,short_description,
    impact,description,correlation_display,urgency,made_sla,delivery_plan,work_notes_list

## GlideRecordUtil - getGR(String baseTable, String sys_id) {#ariaid-title4}

Returns a GlideRecord instance for the given table, positioned to the given sys_id, and
of the right class (table).
This method is useful when you need to load a GlideRecord from a sys_id, but you don't know
what the actual table is (because it may be extended from the base table). This method
always returns a GlideRecord of the correct type base_table: the name of the base table that
the specified sys_id is in.
{#r_GRU-getGR_S_S__table_xt1_bkw_4t__entry__3}

| Name | Type | Description |
|-|-|-|
| baseTable | String | The name of the base table containing the sys_id. |
| sys_id | String | The sys_id of the desired record. |
[Table 5. Parameters]

{#r_GRU-getGR_S_S__table_xt1_bkw_4t} {#r_GRU-getGR_S_S__table_yt1_bkw_4t__entry__2}

| Type | Description |
|-|-|
| GlideRecord | The GlideRecord for the specified sys_id. |
[Table 6. Returns]

{#r_GRU-getGR_S_S__table_yt1_bkw_4t}  

    var now_GR = new GlideRecordUtil().getGR("cmdb_ci_computer", "2dfd7c8437201000deeabfc8bcbe5d56");

## GlideRecordUtil - getTables(String tableName) {#ariaid-title5}

Returns a Java ArrayList of the ancestors of the specified table name.
For example, given cmdb_ci_linux_server, this would return cmdb_ci_linux_server,
cmdb_ci_server, cmdb_ci_computer, cmdb_ci_hardware, cmdb_ci, and cmdbr.
{#r_GRU-getTables_S__table_n34_hnw_4t__entry__3}

| Name | Type | Description |
|-|-|-|
| tableName | String | Name of the table. |
[Table 7. Parameters]

{#r_GRU-getTables_S__table_n34_hnw_4t} {#r_GRU-getTables_S__table_o34_hnw_4t__entry__2}

| Type | Description |
|-|-|
| ArrayList | List of ancestors of the specified table. |
[Table 8. Returns]

{#r_GRU-getTables_S__table_o34_hnw_4t}  
The following example shows the ancestors of the cmdb_ci_linux_server table.

    var tables = new GlideRecordUtil().getTables("cmdb_ci_linux_server");
    gs.info("Tables returned: " + tables);

Output:

    Tables returned: [cmdb_ci_linux_server, cmdb_ci_server, cmdb_ci_computer, cmdb_ci_hardware, cmdb_ci, cmdb]

## GlideRecordUtil - mergeToGR(Object hashMap, GlideRecord now_GR, Object ignore) {#ariaid-title6}

Sets the fields in the specified GlideRecord with the field values contained in the
specified hashmap, unless that field name is in the ignore hashmap.
{#r_GRU-mergeToGR_O_GR_O__table_i1b_tmw_4t__entry__3}

| Name | Type | Description |
|-|-|-|
| hashMap | Object | An Object instance (being used as a hashmap), with properties named for fields and containing the fields' value. |
| GlideRecord | GR | The GlideRecord instance to receive the field values. |
| ignore | Object | An optional hashmap of field names to ignore. |
[Table 9. Parameters]

{#r_GRU-mergeToGR_O_GR_O__table_i1b_tmw_4t} {#r_GRU-mergeToGR_O_GR_O__table_j1b_tmw_4t__entry__2}

| Type | Description |
|-|-|
| void |   |
[Table 10. Returns]

{#r_GRU-mergeToGR_O_GR_O__table_j1b_tmw_4t}  
This example updates a computer record's name and os fields, but does not update the
sys_created_by field:

    var now_GR = new GlideRecordUtil().getGR("cmdb_ci_computer", "2dfd7c8437201000deeabfc8bcbe5d56");   
    var obj = {"name": "xyz", "os": "windows 2000", "sys_created_by", "aleck.lin"};
    var ignore = {"sys_created_by": true};
    new GlideRecordUtil().mergeToGR(obj, now_GR, ignore);
    now_GR.update();

## GlideRecordUtil - populateFromGR(Object hashMap, GlideRecord now_GR, Object ignore) {#ariaid-title7}

Populates the given hashmap from the given GlideRecord instance. Each field in the
GlideRecord becomes a property in the hashmap.
{#r_GRU-populateFromGR_O_GR_O__table_czg_4lw_4t__entry__3}

| Name | Type | Description |
|-|-|-|
| hashMap | Object | An object being used as a hashmap. |
| now_GR | GlideRecord | A GlideRecord instance positioned to a valid record. |
| ignore | Object | An optional hashmap of file names not to populate. |
[Table 11. Parameters]

{#r_GRU-populateFromGR_O_GR_O__table_czg_4lw_4t} {#r_GRU-populateFromGR_O_GR_O__table_dzg_4lw_4t__entry__2}

| Type | Description |
|-|-|
| void |   |
[Table 12. Returns]

{#r_GRU-populateFromGR_O_GR_O__table_dzg_4lw_4t}  

    var objectToPopulate = {};
    var now_GR = new GlideRecordUtil().getGR("cmdb_ci_computer", "2dfd7c8437201000deeabfc8bcbe5d56");
    var ignore = {"sys_created_on": true, "sys_updated_by": true};
    new GlideRecordUtil().populateFromGR(objectToPopulate, now_GR, ignore);
    // Now the objectToPopulate contains field/value pairs from the computer GlideRecord