10-06-2014 05:00 AM
Hi,
I have a situation where I was testing knowledge base and I have over 8000 tickets I want to delete.
Is there an easy way to do this rather than 100 at a time.
Thanks
Steve
Solved! Go to Solution.
10-06-2014 05:04 AM
Or, if you just want to clear out the whole table, do that in the Tables & Columns module, select your table, and then delete all records underneath the picker.
View solution in original post
10-06-2014 05:35 AM
MAke use of this function:
gs.sql('DELETE from incident where number=INC123456');
By simple .XLS sheet operation you can generate 800 lines of code as per above syntax,
Then run trhe same in back ground script.
