clear out field multiple update

[roxaneamanda1]

Hi,

I would like to do a multiple update and clear out the contents of a field but unfortunalty I get a message stating

Multiple update checked 1,636 records but no update data was provided

Can anyone help me please?

Thanks

[solutioningnow]

Hi,

You can try the background script in dev/qa instance first. if everything works well, than only do the same in Production.

Please mark answer as correct/helpful, if it was really helpful 🙂

Regards,

Solutioner

Enhance Knowledge NOW@ www.solutioningnow.com

http://www.solutioningnow.com/

[Subhajit1]

Write a Background script.....something like this:-

var gr=new GlideRecord('sys_user');

//Put your filter conditions here-the filters by which you reached the 1635 figure

gr.query();

while(gr.next())

{

gr.fieldname='';//if this is not a Mandatory field

gr.update();

}

You can also do this using an Import Set,setting your UserID field(Unique field on User table) to coalecse

[roxaneamanda1]

Hi, I have figured out that I can shift+highlight and then do a list edit to clear out a field on multiple items.

Thanks everyone

[janwillem]

Hi

this CAN be done with update all / update selected just fill in the field you want to clear : NULL in upppercase

Regards Jan Willem

[stevedag]

I confirm that Jan Willem Driesens has the solution:   NULL in uppercase in the field you want to empty while you're doing an udpdate all.

Steve