Avaya Support Forums

Avaya Support Forums (http://support.avaya.com/forums/index.php)
-   Contact Center Applications (http://support.avaya.com/forums/forumdisplay.php?f=3)
-   -   cms (http://support.avaya.com/forums/showthread.php?t=11011)

cc12 02-25-2016 08:37 AM

cms
 
Hi,

Would it be possible to delete random skills in bulk directly from the database through a sql query ,giving a string of skills to be removed( selecting specific database tables that have skill as the attribute) ?
Is it recommended ?

shaikht 02-26-2016 12:55 AM

Hi,

Yes it can be done. You need to query synonyms table for same.

Below values will be seen in table. Select your value(skill number) to create SQL:

acd_no 1
item_type split
item_name training
value 23
descr
standard

I hope it helps.


All times are GMT -7. The time now is 07:41 PM.