thanks for your responses, I checked again and I found that I asked a wrong question! I was supposed to ask about answer time. The answer time is not getting save in the database.
On Tue, Mar 10, 2009 at 11:41 AM, Anthony Francis <antho...@rockynet.com>wrote: > Tilghman Lesher wrote: > > On Monday 09 March 2009 01:28:49 pm Anthony Francis wrote: > > > Tilghman Lesher wrote: > > > On Friday 06 March 2009 11:24:46 pm Hooman Peiro wrote: > > > hi, > I'm working with asterisk on a project and I found a problem with > cdr_odbc. As we know, after answering each call a cdr event is raised > which is saved in cdr_csv and cdr_odbc. but here my point is on > cdr_odbc. some information, including start_time and end_time is given > by cdr event but the problem is that these two information(start_time > and end_time) is not getting save in cdr_odbc. I checked the source code > and I found that by default it's not doing so. I need to query these two > information, start time and end time, from cdr_odbc and I need your > help. > thanks > > > You are partially incorrect. The start time is indeed stored in the CDR, > although the column name is 'calldate'. As for the end time, it can be > derived by adding 'duration' (which is in whole seconds) to the > 'calldate' column. > > Another solution that allows for retrieving both columns with their > native names (or completely different names, whatever you map it to) is > to use cdr_adaptive_odbc in 1.6.0 and higher. > > > I have often thought, wouldn't it be better if the cdr config files > allowed you to specify column names i.e. > calldate => callstart_datetime > > Or whatever, the basic format being asteriskfieldname => db columnname. > > Just an idea.. > > > Which is how cdr_adaptive_odbc already works. ;-) > > > > Yeah I haven't moved to 1.6 yet :(. > > _______________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
_______________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users