- summary: Vendor rating enhancement --> Vendor Rating SQL cleanup
When rating it selects for each trunk, why ...
shouldn't just a single query i.e. select * from cdr where uniqueid='1184039113.30' be enough?
SELECT * FROM cdr where lastapp = 'Dial' AND vendor = 'none' AND (dstchannel LIKE 'Zap/g1/%' OR dstchannel LIKE 'Zap[g1/]%' OR lastdata LIKE 'Zap/g1/%' OR lastdata LIKE 'Zap[g1/]%') AND uniqueid = ' 1184039113.30' AND disposition = 'ANSWERED'
SELECT * FROM cdr where lastapp = 'Dial' AND vendor = 'none' AND (dstchannel LIKE 'SIP/ipaddress%' OR dstchannel LIKE 'SIP[ ipaddress]%' OR lastdata LIKE 'SIP/ipaddress%' OR lastdata LIKE 'SIP[ipaddress]%') AND uniqueid = '1184039113.30' AND disposition = 'ANSWERED'
SELECT * FROM cdr where lastapp = 'Dial' AND vendor = 'none' AND (dstchannel LIKE 'SIP/ipaddress%' OR dstchannel LIKE 'SIP[ipaddress]%' OR lastdata LIKE 'SIP/ipaddress%' OR lastdata LIKE 'SIP[ ipaddress]%') AND uniqueid = '1184039113.30' AND disposition = 'ANSWERED'
SELECT * FROM cdr where lastapp = 'Dial' AND vendor = 'none' AND (dstchannel LIKE 'SIP/ipaddress%' OR dstchannel LIKE 'SIP[ ipaddress]%' OR lastdata LIKE 'SIP/ipaddress%' OR lastdata LIKE 'SIP[ipaddress]%') AND uniqueid = '1184039113.30 ' AND disposition = 'ANSWERED'
SELECT * FROM cdr where lastapp = 'Dial' AND vendor = 'none' AND (dstchannel LIKE 'SIP/ipaddress%' OR dstchannel LIKE 'SIP[ ipaddress]%' OR lastdata LIKE 'SIP/ipaddress%' OR lastdata LIKE 'SIP[ipaddress]%') AND uniqueid = '1184039113.30' AND disposition = 'ANSWERED'
SELECT * FROM cdr where lastapp = 'Dial' AND vendor = 'none' AND (dstchannel LIKE 'SIP/ipaddress%' OR dstchannel LIKE 'SIP[ipaddress]%' OR lastdata LIKE 'SIP/ipaddress%' OR lastdata LIKE 'SIP[ ipaddress]%') AND uniqueid = '1184039113.30' AND disposition = 'ANSWERED'
SELECT * FROM cdr where lastapp = 'Dial' AND vendor = 'none' AND (dstchannel LIKE 'SIP/ipaddress%' OR dstchannel LIKE 'SIP[ ipaddress]%' OR lastdata LIKE 'SIP/ipaddress%' OR lastdata LIKE 'SIP[ipaddress]%') AND uniqueid = '1184039113.30 ' AND disposition = 'ANSWERED'