[asterisk-bugs] [JIRA] (ASTERISK-23770) calldate missing from contrib/ast-db-manage/cdr

[Matt Jordan (JIRA)]

    [ https://issues.asterisk.org/jira/browse/ASTERISK-23770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=218351#comment-218351 ] 

Matt Jordan commented on ASTERISK-23770:
----------------------------------------

That's because {{cdr_odbc}} is weird, strange, and uses non-standard CDR columns. No other module uses {{calldate}}, nor should any other module use {{calldate}}. As such, the recommended SQL columns in the contrib script really shouldn't be updated to include it.

The preferred module to use for ODBC CDRs is {{cdr_adaptive_odbc}}. Not only would it not have this problem, but if you _really_ wanted a calldate column, you could add one and map the standard fields to it.

> calldate missing from contrib/ast-db-manage/cdr
> -----------------------------------------------
>
>                 Key: ASTERISK-23770
>                 URL: https://issues.asterisk.org/jira/browse/ASTERISK-23770
>             Project: Asterisk
>          Issue Type: Bug
>      Security Level: None
>          Components: Contrib/General
>    Affects Versions: 12.2.0
>            Reporter: Stephen More
>
> cdr/cdr_odbc.c shows:
> "INSERT INTO %s "
>                 "(calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,"
>                 "lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield) "
>                 "VALUES ({ts '%s'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)", table, timestr);
> There is no calldate defined in contrib/ast-db-manage/cdr



--
This message was sent by Atlassian JIRA
(v6.2#6252)