Hi Raj,<div>Thanks for your reply :)</div><div><br></div><div>I forgot to mention, it's on a GUI mode<br><br><div class="gmail_quote">On Thu, Aug 16, 2012 at 10:07 AM, Raj Mathur (राज माथुर) <span dir="ltr"><<a href="mailto:raju@linux-delhi.org" target="_blank">raju@linux-delhi.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Thursday 16 Aug 2012, Satria Anamarta wrote:<br>
> Hi all,<br>
> In the CDR report I would like to filter search to display all the<br>
> calls that has a null value (blank) for the "Dst. Channel" field.<br>
> I try to input space, <null>, $null$, but it display error. Just left<br>
> the field blank will display ALL.<br>
><br>
> So what is the correct value to be inputted as null or blank?<br>
><br>
> Thanks for the help :)<br>
<br>
</div></div>If the CDR is in an RDBMS:<br>
<br>
select ... where dstchannel is null ...<br>
<br>
Regards,<br>
<br>
-- Raj<br>
--<br>
Raj Mathur || <a href="mailto:raju@kandalaya.org">raju@kandalaya.org</a> || GPG:<br>
<a href="http://otheronepercent.blogspot.com" target="_blank">http://otheronepercent.blogspot.com</a> || <a href="http://kandalaya.org" target="_blank">http://kandalaya.org</a> || CC68<br>
It is the mind that moves || <a href="http://schizoid.in" target="_blank">http://schizoid.in</a> || D17F<br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</blockquote></div><br></div>