CiviCRM Community Forums (archive)

So was trying to find all people with mobile numbers, including odd ones where they have been put in Phone field. 02 is our mobile prefix. so step 1 find those beginning with 02 or just 2
--------
Found 1628 contacts
    * Phone LIKE 02%   ... AND ... Contact Type - 'Individual'
    * OR
    * Phone LIKE 2%   ... AND ... Contact Type - 'Individual'
-----
so far so good. then add any that maybe in Phone field (which I know happens)

Then I tried to include a search just for Mobile numbers in Home phone fields - and the OR query seems to fail since it drops from found=1628 to found=1. I can easily do a work around. Just wondering how the OR query gets overridden somehow.

So really reporting this in case it points at some deeper problem - or is it just that the system can't deliver both Primary and non-primary phone numbers - certainly the latter is a problem I think we have hit in the past doing exports

------------
Found 1 contact

    * Phone LIKE 02%   ... AND ... Contact Type - 'Individual'
    * OR
    * Phone LIKE 2%   ... AND ... Contact Type - 'Individual'
    * OR
    * Phone (Home) LIKE '02%'   ... AND ... Contact Type - 'Individual'