Change clause of Mysql statement when filtering

Discussion in 'General' started by fabianoheringer, Nov 12, 2010.

  1. fabianoheringer

    Joined:
    Apr 30, 2010
    Messages:
    4
    Likes Received:
    0
    Hi, I need to change the mysql clause when i make filter on Billing Report.

    Today he looking for date, disposition and dstchannel

    SELECT COUNT(*) FROM cdr WHERE calldate>='2010-11-12 00:00:00' AND calldate<='2010-11-12 23:59:59' AND disposition = 'ANSWERED' AND (dstchannel like '%DAHDI/1-%')

    I need to put to look for a userfield from cdr table..

    Anybody know what file to be modified to add this clause?

    Thanks
     

Share This Page