claloano
(Claudio Pelosi)
1
query missed calls
I am about to create a filter to individiare missed calls
obviously I lean “asteriskcdrdb” table “CDR”
the point is to find the right query to highlight only those calls that nobody answered …
someone has an idea or has already dealt with the problem?
claloano
(Claudio Pelosi)
2
guys already made
I hope to serve someone else
SELECT *
FROM cdr
WHERE channel LIKE '%SIP/%'
AND disposition='NO ANSWER’
AND DATE(calldate
) = DATE(CURDATE())
GROUP BY calldate