Change clause of Mysql statement when filtering

fabianoheringer

Joined
Apr 30, 2010
Messages
4
Likes
0
Points
0
#1
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
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,901
Messages
130,885
Members
17,561
Latest member
marouen
Top