I’m having some issues searching for only outbound calls made through FreePBX/Asterisk.
I thought something like:
SELECT * FROM asteriskcdrdb.cdr WHERE dcontext=‘from-internal’ AND disposition=‘ANSWERED’ AND src=‘100’ AND calldate LIKE “2012-01-06 %”
would work, but it’s not. Ideas ?