post GlideRecord utility class in Developer articles https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/ta-p/2480002 <DIV class="lia-message-template-content-zone"> <P><FONT face="andale mono,times"><SPAN>In OOB, we have a useful utility, <STRONG>GlideRecordUtil() </STRONG>script include<STRONG style="color: #252525;">&nbsp;</STRONG>to work with GlideRecords. I've found two handy functions to fetch and update the record data.</SPAN> </FONT></P> <DIV> <UL> <LI><FONT face="andale mono,times"><SPAN>populateFromGR()</SPAN></FONT></LI> <LI><FONT face="andale mono,times">mergeToGR()</FONT></LI> </UL> <P><FONT face="andale mono,times"><U><STRONG>populateFromGR(object, gr, ignoreFields)&nbsp;</STRONG></U></FONT></P> <OL> <LI><FONT face="andale mono,times">This function can be used to get the full record data</FONT></LI> <LI><FONT face="andale mono,times">The data will be retrieved in an Object response</FONT></LI> <LI><FONT face="andale mono,times"><STRONG>Object</STRONG> : Pass the object variable to store the data, <STRONG>gr</STRONG> - Pass the GlideRecord instance, <STRONG>ignoreFields</STRONG> - An optional object parameter that can exclude fields in the final response.</FONT></LI> </OL> <P><FONT face="andale mono,times"><STRONG><U>Sample script</U></STRONG></FONT></P> <LI-CODE lang="javascript">var responseObject = {}; //hashmap object variable to store final response var getData = new GlideRecordUtil().getGR("change_request", "c83c5e5347c12200e0ef563dbb9a7190"); //pass the table name and Record sys_id to get the GlideRecord instance var ignoreFields = {"sys_created_on": true, "sys_updated_by": true}; //Pass the fields that you want to exclude in the final response new GlideRecordUtil().populateFromGR(responseObject, getData, ignoreFields); //The main function to retrieve the data gs.print(JSON.stringify(responseObject, null, 4)); //Decode the object</LI-CODE> <P><FONT face="andale mono,times"><U><STRONG>Output</STRONG></U></FONT></P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SaiKumarB_0-1676529856364.png" style="width: 400px;"><img src="https://www.servicenow.com/community/image/serverpage/image-id/240865i26716715E9B7284C/image-size/medium?v=v2&amp;px=400" srcset="/community/image/serverpage/image-id/240865i26716715E9B7284C/image-size/medium?v=v2&amp;px=400 1.0x, /community/image/serverpage/image-id/240865i26716715E9B7284C/image-dimensions/581x800?v=v2 2.0x" role="button" title="SaiKumarB_0-1676529856364.png" alt="SaiKumarB_0-1676529856364.png" /></span> <P>&nbsp;</P> <P><FONT face="andale mono,times"><U><STRONG>mergeToGR(object, gr, ignoreFields)</STRONG></U></FONT></P> <OL> <LI><FONT face="andale mono,times">This function can be used to update the record data</FONT></LI> <LI><FONT face="andale mono,times"><STRONG>object&nbsp;</STRONG>- Pass the field names and values, <STRONG>gr&nbsp;</STRONG>-&nbsp;Pass the GlideRecord instance, <STRONG>ignoreFields</STRONG> - An optional object parameter to ignore the fields.</FONT></LI> </OL> <P><FONT face="andale mono,times"><STRONG><U>Sample script</U></STRONG></FONT></P> <LI-CODE lang="javascript">var updateObject = {"category" : "Hardware"}; //Pass the field name and values var updateData = new GlideRecordUtil().getGR("change_request", "c83c5e5347c12200e0ef563dbb9a7190"); //Get the GlideRecord instance var ignoreFields = {"sys_created_on": true}; //These fields will not be updated new GlideRecordUtil().mergeToGR(updateObject , updateData, ignoreFields); //The main function picks the object as Input updateData.update(); //Update the record using GlideRecord instance</LI-CODE> <DIV> <DIV class="lia-align-left"><FONT face="andale mono,times"><U><STRONG>Output</STRONG></U></FONT></DIV> <DIV class="lia-align-left"><U></U><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="SaiKumarB_1-1676530550020.png" style="width: 400px;"><img src="https://www.servicenow.com/community/image/serverpage/image-id/240866i5A23A41CECEEED0B/image-size/medium?v=v2&amp;px=400" srcset="/community/image/serverpage/image-id/240866i5A23A41CECEEED0B/image-size/medium?v=v2&amp;px=400 1.0x" role="button" title="SaiKumarB_1-1676530550020.png" alt="SaiKumarB_1-1676530550020.png" /></span> <P>&nbsp;</P> <P><FONT face="andale mono,times">I hope you like my article<SPAN>&nbsp;</SPAN></FONT></P> <P><FONT face="andale mono,times">Kindly, Post comments if you have any queries</FONT><BR /><FONT face="andale mono,times">Thanks,</FONT><BR /><FONT face="andale mono,times">Sai Kumar B</FONT><BR /><FONT face="andale mono,times">Community Rising Star 2023 &amp; 2022</FONT></P> </DIV> <DIV class="lia-align-right">&nbsp;</DIV> </DIV> </DIV> </DIV> <P>&nbsp;</P> Thu, 16 Feb 2023 07:22:28 GMT Sai Kumar B 2023-02-16T07:22:28Z GlideRecord utility class https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/ta-p/2480002 <P><STRONG>Mighty GlideRecordUtil()</STRONG></P> Thu, 16 Feb 2023 07:22:28 GMT https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/ta-p/2480002 Sai Kumar B 2023-02-16T07:22:28Z Re: GlideRecord utility class https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2480088#M7033 <P>Good one. I can think of a possible usage of the seconde message:</P> <LI-CODE lang="javascript">var incidentGR = new GlideRecord('incident'); incidentGR.addEncodedQuery('state=1^caller_id=77ad8176731313005754660c4cf6a7de'); //David Miller var updateData = {"caller_id": "6816f79cc0a8016401c5a33be04be441"}; //Martin Ivanov new GlideRecordUtil().mergeToGR(updateData , incidentGR); incidentGR.updateMultiple();</LI-CODE> Thu, 16 Feb 2023 08:35:37 GMT https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2480088#M7033 Martin Ivanov 2023-02-16T08:35:37Z Re: GlideRecord utility class https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2480628#M7036 <P>Nice.</P> <P>&nbsp;</P> <P>More use cases identified here:&nbsp;<A href="https://docs.servicenow.com/bundle/tokyo-application-development/page/script/server-scripting/concept/c_ScriptIncludes.html#usingDiscoveryScriptIncludes" target="_self">https://docs.servicenow.com/bundle/tokyo-application-development/page/script/server-scripting/concept/c_ScriptIncludes.html#usingDiscoveryScriptIncludes</A>&nbsp;</P> Thu, 16 Feb 2023 15:26:13 GMT https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2480628#M7036 Allen Andreas 2023-02-16T15:26:13Z Re: GlideRecord utility class https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2482275#M7048 <P>&nbsp;</P> <P>Hello&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/305072">@Martin Ivanov</a>&nbsp;<BR /><BR /></P> <P>Thank you for reading my article and providing the solution that can help community users.</P> <P>&nbsp;</P> Sat, 18 Feb 2023 08:31:50 GMT https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2482275#M7048 Sai Kumar B 2023-02-18T08:31:50Z Re: GlideRecord utility class https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2482276#M7049 <P>Hello&nbsp;<a href="https://www.servicenow.com/community/user/viewprofilepage/user-id/221263">@Allen Andreas</a>&nbsp;<BR /><BR /></P> <P>Thank you for reading my article and providing reference to additional use cases.</P> <P>&nbsp;</P> Sat, 18 Feb 2023 08:33:08 GMT https://www.servicenow.com/community/developer-articles/gliderecord-utility-class/tac-p/2482276#M7049 Sai Kumar B 2023-02-18T08:33:08Z