How can I search for organisations that share a part of the name (i.e. 'embassy of') but then add more attributes with OR
? So, for example:
'embassy of' AND ('the US' OR 'the UK')
CiviCRM Stack Exchange is a question and answer site for administrators and users of the CiviCRM Constituent Relationship Management software. It only takes a minute to sign up.
Sign up to join this communityHow can I search for organisations that share a part of the name (i.e. 'embassy of') but then add more attributes with OR
? So, for example:
'embassy of' AND ('the US' OR 'the UK')
(EDITED) You could use a combination of eg a smart group for Orgs with name contains 'embassy of', and then Tag every record that has 'the US', then search for contacts that are in Embassy group and US Tag and set 'search operator' to AND "Search Operator Determines whether your criteria are combined with AND statements, or combined with OR statements. For example, you may want to find all individuals who are in the Volunteers group AND who have a Volunteer Training activity recorded for them. In this case use the AND operator. If you need to find everyone who is in the Volunteers group OR has a Volunteer Training activity recorded, use the OR operator."
Try the search builder:
Include contacts where first name="john" and last name="doe" +also include contacts where first name="john" and last name="coltrane"
should get you the list you want
Based on the revised question you should: