avoid repeated code for multiple gliderecord

Community Alums — Thu, 12 Sep 2024 16:26:56 GMT

Hello Team,

Some times in a code we have do multiple glideRecord in a script. Below code fuction will help you to avoid multiple glideRecord. Here you can pass field & value as initializeFields object. This code will check if a record is present on the table if not it will create and return the sysid.

// Helper function to retrieve or create a record in a table

function getOrCreateRecord(tableName, queryField, queryValue, initializeFields) {

var gr = new GlideRecord(tableName);

gr.addQuery(queryField, queryValue);

gr.query();

if (!gr.next()) {

gs.info("Subham: No record found in " + tableName + " for " + queryValue);

gr.initialize();

for (var field in initializeFields) {

gr[field] = initializeFields[field];

}

gr.insert();

} else {

gs.info("Subham: Record found in " + tableName + " with sys_id = " + gr.sys_id);

}

return gr.sys_id;

}

Thanks

question avoid repeated code for multiple gliderecord in Community Central forum

avoid repeated code for multiple gliderecord