<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Tilghman Lesher wrote:
<blockquote
cite="mid:200903091127.10236.tilghman@mail.jeffandtilghman.com"
type="cite">
<pre wrap="">On Friday 06 March 2009 11:24:46 pm Hooman Peiro wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap=""><!---->
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.
</pre>
</blockquote>
I have often thought, wouldn't it be better if the cdr config files
allowed you to specify column names i.e.<br>
calldate => callstart_datetime<br>
<br>
Or whatever, the basic format being asteriskfieldname => db
columnname.<br>
<br>
Just an idea..<br>
<br>
Anthony Francis<br>
</body>
</html>