Discussion

CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation

Comments: 3 - Last Comment by lphelps 51 days ago  
Posted 63 days ago
 
 

Custom columns in common_event_call that have been added to the main event information dialog in Calltaker/Dispatcher are not being written to the database during event creation. In the event info dialog, if I populate data in a COTS field (e.g. common_event_call.clname) and a custom field (e.g. gender) then both fields create/update fine in the database (config records appear to be correct). However, if I populate data ONLY in a common_event_call custom field in the event info dialog then literally nothing happens, the trigger to insert a new record in common_event_call table doesn't occur. Same issue occurs for updating an existing event.

I'm running CAD 9.4 Q1 2019 and a colleague had this same issue and ended up transferring his custom common_event_call columns to the common_event table.

Point your RSS reader here for a feed of the latest messages in this topic
RE: CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation
Posted 61 days ago in response to: gmenezes
 
   
 

I logged an SR for this against 9.3 MR5: 1-1798057381, there's a CR-E: 1-UP3GD8 with status Deferred Accepted, so I'm guessing it's probably never going to be 'fixed'.  

We put all our custom columns against common event instead.

RE: CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation
Posted 53 days ago in response to: lphelps
 
   
 

Thanks Louise, much appreciated! I need to improve my Siebel search skills! ;-)

I've moved the custom columns to the common_event table also.

p.s. Small world, was on a coffee break with two of your former colleagues down here in Melbourne (Richard and MJ) running this issue by them just before seeing your reply!

RE: CAD 9.4 - custom columns in common_event_call table not inserting/updating in event creation
Posted 51 days ago in response to: gmenezes
 
   
 

We like to share our CAD knowledge with the colonies :-) And MJ was too grumpy so we gave him back!


Add a Comment

Please sign in on the right menu to comment.  If you do not have an account, please Join now.