Hi all, In the CDR report I would like to filter search to display all the calls that has a null value (blank) for the "Dst. Channel" field. I try to input space, <null>, $null$, but it display error. Just left the field blank will display ALL. So what is the correct value to be inputted as null or blank? Thanks for the help :) BR, Anam. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120816/197f9477/attachment.htm>
Raj Mathur (राज माथुर)
2012-Aug-16 03:07 UTC
[asterisk-users] How to input NULL in CDR report
On Thursday 16 Aug 2012, Satria Anamarta wrote:> Hi all, > In the CDR report I would like to filter search to display all the > calls that has a null value (blank) for the "Dst. Channel" field. > I try to input space, <null>, $null$, but it display error. Just left > the field blank will display ALL. > > So what is the correct value to be inputted as null or blank? > > Thanks for the help :)If the CDR is in an RDBMS: select ... where dstchannel is null ... Regards, -- Raj -- Raj Mathur || raju at kandalaya.org || GPG: http://otheronepercent.blogspot.com || http://kandalaya.org || CC68 It is the mind that moves || http://schizoid.in || D17F