How to delete a particular column data completely in the list of table?

mallikarjunared
Tera Contributor

I am able to delete data for a column following each and every row of that column one by one. If I want to delete the complete data for a particular column, I am not able to do it.

But I can update the empty column completely by dragging mouse with control key for that particular column.

Please suggest me how to delete it.

7 REPLIES 7

var mu = new GlideMultipleUpdate('incident');


mu.setValue('caller_id',   '');


mu.execute();



This clears all data for caller_id on incidents.   Please run it in a background script.


You are right Mike, through backgound scripting we are able to delete complete data of a particular field.


Thanks Mike,



My goal is to clear all the data in several fields of all knowledge base articles. One of the columns I am trying to clear the data on is the "meta" column in the "kb_knowledge" table. So would that script look like this?



varmu = new GlideMultipleUpdate('kb_knowledge');


mu.setValue('meta',   '');


mu.execute();