› VitalPBX Community Support › General Discussion › CDR filters are way to complicated › Reply To: CDR filters are way to complicated
-
- May 29, 2020 at 4:15 pm
Gary,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
Condition Search By Value Exclude Mode AND Destination 1000 No Exactly OR Destination 1001 No Exactly AND Call type Incoming No Exactly 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.
0