How to delete a particular column data completely in the list of table?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-31-2014 11:17 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2015 12:15 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-25-2015 01:51 AM
You are right Mike, through backgound scripting we are able to delete complete data of a particular field.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-25-2015 05:31 AM
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();