Reply To: CDR filters are way to complicated

VitalPBX Community Support General Discussion CDR filters are way to complicated Reply To: CDR filters are way to complicated

    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