Maybe it’s just me but getting basic reports using filters are not working or are very complicated, A basic report to show how many incomming calls we receive is impossible to get, the main number rings to a ring group so every extension is counted even though they don’t answer the call, if you apply Status Answered it’s still wrong because you see all the parked calls ? if you try to exclude 701 it does not work ?
Also in the CDR thier is a column “TO” but if you try to use this as a destination “exclude” it does not work
I think the most important is to understand how the MySQL conditions works, due, in the end, this what these filters generate.
For Example, if you need to find incoming calls for extensions 1000 and 1001, you can put in the filter
So, the “OR” condition may help you to match more that one value for the same field, in this case, the destination field. and the “AND” condition helps you to force your query match with specific conditions in order to retrieve the results.