[asterisk-users] How to input NULL in CDR report

[Raj Mathur ( राज माथुर )]

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