Query missed calls

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?

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