Knowledgebase article 30

Call list subject additions


A bug in the DBadmin can prevent you from modifying call list subjects.

If your DBadmin is displaying bogus or nonexistant placed a call subjects, then the easiest thing to do is go around the DBadmin and insert the call list subjects directly into the database. The CW_OPTIONS table contains much miscellaneous data about how the menus work and what fields are in them. For this issue, ignore everything except for the rows which contain 'History PRC Subjects' as the OP_NAME column's value. To add a new call list subject, return all of the rows, locate the grouping of subjects (usually at the bottom).

Clicking on the lowest 'null' cells will allow you to add new values. The OP_KEY is important. It controls the order your call list subjects will appear. If you want to reorder them, you need to change the sequence of the OP_KEY field to reflect the order you desire. If i wanted to add a subject of 'Demo Given' to the call list dropdown, and my data was:

 OP_KEY       OP_NAME                                                 OP_VALUE                              OP_CODE

5870History PRC SubjectsWrong Number8004
5871History PRC SubjectsDo Not Call8004
5872History PRC SubjectsTalked To8004

 I would add a line with an OP_KEY of 5873, the OP_NAME of 'History PRC Subjects', the OP_VALUE 'Demo Given', and the OP_CODE 8004. The OP_NAME and OP_CODE fields have to match the rest of the call list subjects or they will not work.

 

Changing the order is as simple as changing 5870 to 5871 and 5871 to 5870.

 

The Options table can contain LDAP login network information. Do not modify any contents of the Options table besides the history subjects mentioned.
Group ContactWise Standard Support Last modified Nov 13, 2019 Type Public Viewed 2515