question Re: How to update Read only Custom field to Null for 100 of records in alm_hardware Table in Fix scr in Developer forum

How to update Read only Custom field to Null for 100 of records in alm_hardware Table in Fix script?

VIKAS45 — Tue, 26 Mar 2024 05:23:29 GMT

How to update Read only Custom field to Null for 100 of records in alm_hardware Table using Fix script or any other Method?

Re: How to update Read only Custom field to Null for 100 of records in alm_hardware Table in Fix scr

Deepak Shaerma — Tue, 26 Mar 2024 05:41:09 GMT

Hi @VIKAS45

Step 1: Navigate to Background Script Scripts - Background
Script:

var tableName = 'alm_hardware'; var customFieldName = 'u_custom_field'; // REPLACE with your field name var gr = new GlideRecord(tableName); gr.query(); // Execute the query to retrieve the records var count = 0; while (gr.next()) { gr.setValue(customFieldName, ''); // Set the field value to null (empty string in this context) gr.setWorkflow(false); // Optionally, skip business rules, if necessary gr.update(); // Update the record count++; } gs.info(count + ' records updated in ' + tableName);

Note: Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me..
- Keep Learning ‌‌
Thanks & Regards
Deepak Sharma

Re: How to update Read only Custom field to Null for 100 of records in alm_hardware Table in Fix scr

Basheer — Tue, 26 Mar 2024 06:02:53 GMT

Hi @VIKAS45

You can use either fix scripts or background scripts or you can even schedule it

below is the sample code

var almAsset= new GlideRecord("alm_hardware"); almAsset.query(); while (almAsset.next()) { almAsset.customFieldName= " "; almAsset.update(); }

Re: How to update Read only Custom field to Null for 100 of records in alm_hardware Table in Fix scr

Deborah Brown L — Tue, 26 Mar 2024 06:05:31 GMT

Hi @VIKAS45 ,

Can use a background script or fix script.

please find the script below,

var gr = new GlideRecord('alm_hardware');

//gr.addQuery('state','in use'); // write the query

gr.query();

gr.autoSysFields(false); //// so that the records don't have system updates

gr.setLimit(100); // so it won't run for other records

while (gr.next()) {

gr.fieldname = ''; // Set the field value to null

gr.setWorkflow(false); // Necessary if you are updating a bulk records

gr.update(); // Update the record

}

Re: How to update Read only Custom field to Null for 100 of records in alm_hardware Table in Fix scr

abhishekdalvi — Tue, 26 Mar 2024 06:24:09 GMT

Hi @VIKAS45 ,

You can use background script or fix script.

var gr_hardware = new GlideRecord("alm_hardware"); gr_hardware.addEncodedQuery(""); // Add your encoded query here which filters your required records gr_hardware.query(); while (gr_hardware.next()) { gr_hardware.autoSysFields(false); // this will prevent updating updated by and updated field, use if required. gr_hardware.setWorkflow(false); // skip business rules gr_hardware.setValue(customFieldName, ''); // Set the field value to null gr_hardware.update(); }

Note: Please Mark this Helpful and Accepted Solution. If this Helps you to understand. This will help both the community and me.

Thank you!