Skip to main content
Share Your Experience: Take the 2024 Developer Survey
7 votes

Regex search for a list of Contact IDs

It's true - looking at the code, I can see that Search Builder expects an integer if you're searching on an integer field. An exception is made for using the IN operator, in which case it validates ...
Jon G - Megaphone Tech's user avatar
6 votes
Accepted

How to try out new 'Search Builder'?

Note if you install from a tar file the extension is not available until 5.30. Git/composer/buildkit installs have it in 5.29. Also the styling on the search page is messy until 5.31, and before then ...
Demerit's user avatar
  • 23.2k
5 votes
Accepted

How to search for all contacts without a tag? Registered for event

While a code-level fix is obviously preferable, the quick solution is to create two groups: Everyone who attended the event who has the tag. Everyone who attended the event. Then use the custom ...
Jon G - Megaphone Tech's user avatar
4 votes

Smart Group criteria disappearing or changing

There was a set of nasty bugs that fit the description of what you're talking about throughout 2015: https://issues.civicrm.org/jira/browse/CRM-18155 https://issues.civicrm.org/jira/browse/CRM-18435 ...
Jon G - Megaphone Tech's user avatar
4 votes
Accepted

Shortlisting contacts with complete address

You can use the search builder to search for empty fields, e.g. Steet-Address or ZIP Code. From the result, you could create a (smart) group and then exclude contacts in that group from the mailing.
Fabian's user avatar
  • 3,597
4 votes
Accepted

Regex search for a list of Contact IDs

Adding to the Suggestion of Jon G there is a simple extension to SearchBuilder that allows to paste ContactIDs into a separate field and converts those to an 'IN' query with comma separated values: ...
Thomas Schüttler's user avatar
4 votes
Accepted

(version 5.13/5.14) Search Builder syntax error when "Groups" "is empty"

This is a recent bug introduced by the fix to a different search issue, issue #726. A permanent fix will need to be found that doesn't break either scenario. However, to resolve your immediate issue,...
Jon G - Megaphone Tech's user avatar
4 votes
Accepted

Descrepancies in search result counts

When you search for Group(s) Not In 2021_keep, Search Builder may be interpreting it as "contacts who are in some group that's not 2021_keep". That's not what you want. Here are two three ...
Noah Miller's user avatar
  • 1,057
3 votes
Accepted

How to search contacts with certain prefix say, "Dr"?

This is job for the Search Builder that you can find in the Search menu Select Individual Select Individual Prefix Complete with = and the desired title. When the results are shown you can create a ...
Kainuk - CiviCooP's user avatar
3 votes
Accepted

new feature? - all addresses needs to be searchable

In the advanced search under the "Address Fields" you can choose "Address Location" which defaults to primary only. By selecting all of them you can search by any address type. answer taken from this ...
Parthibaraj Rajasekar's user avatar
3 votes
Accepted

Supplemental address should be searchable

It does sound like a reasonable feature request, and the good news is that it's already been implemented. The pull request was merged in March, so any version of CiviCRM from 4.7.18 upwards should ...
mickadoo's user avatar
  • 341
3 votes
Accepted

Search builder: searching for Not equals or Not In with tags or groups doesn't include Null

Search Builder is more 'raw' and I find end-users are best to avoid it! Search > Custom Searches > Include / Exclude Search will do what you want. Once you have the results you could save it ...
Aidan's user avatar
  • 13.5k
3 votes

Search builder does not display date picker for contacts

There was a small bug introduced in the last version where the calendar icon didn't show up in search builder date fields, but the actual datepicker still works fine. The screenshots and videos are ...
Coleman's user avatar
  • 18.7k
3 votes
Accepted

Neither Advanced Search nor Search Builder offer option to save as Smart Group

In the documentation here https://docs.civicrm.org/user/en/latest/organising-your-data/smart-groups/#creating-smart-groups at step 6 it says it's a choice in the actions dropdown. If you don't see ...
Demerit's user avatar
  • 23.2k
3 votes

Best way to go from an Excel list of Contact IDs to a Civi group

Can you do import with update flag and on preview screen you can add contacts to group. or using URL you can do /civicrm/task/add-to-group?reset=1&cids=119,122,137
Pradeep Nayak's user avatar
2 votes
Accepted

Search Builder One of parameters is not of the type MysqlColumnName

I just tried to replicate this problem on the demo site but couldn't. I would recommend upgrading to Civi 4.7.9, and if you still have the problem, you can do two things: Try to replicate it on the ...
Jon G - Megaphone Tech's user avatar
2 votes

finding members without e-mail addresses

This seems to be working fine on dmaster. Which version are you using? Make sure you have filled the details properly. See below for an example -
jitendra - fuzion's user avatar
2 votes

finding members without e-mail addresses

Rather than is empty try using is null in your search.
DaveD's user avatar
  • 2,465
2 votes

Filtering activities by Source Contact ID

Search Builder seems to be broken for this functionality, you may report that as an issue in the issue tracker: https://issues.civicrm.org/. My understanding is that you want to search within the ...
Thomas Schüttler's user avatar
2 votes

How to search for all contacts without a tag? Registered for event

Thank you for your question that allowed me to test Jon's solution and now find an alternative solution that seems to me even simpler: The new SearchKit allows you to do what you want easily. The ...
Alain Rihs's user avatar
2 votes
Accepted

How to search for contacts without a specific relation?

The search builder should be able to give you this as it has a larger range of search operators available to you. Head to Search > Search builder and then use the criteria: Contacts > Current ...
Matt Lind's user avatar
  • 151
2 votes

After upgrade to 5.0.2 from 4.7.30 getting "DB Error: No such field" on queries

It should be fixed in the latest rc (5.2) https://download.civicrm.org/latest From ChaosBuster: Was able to install the latest at this time, 5.1.2, and I am now able to query with the Search Builder ...
user4278's user avatar
  • 1,021
2 votes

Update Multiple Contributions with Missing Attributes via Search Builder?

Try creating a Profilewith the necessary Contribution fields and then accessing it via Actions (Bulk update) from the Find Contributions page
petednz - fuzion's user avatar
  • 28.3k
2 votes

How to search for people not in any groups

You could use the Custom search include/exclude? Thats normally the way I would try to find everyone who is not in a group/segment.
Parvez Saleh's user avatar
  • 2,396
1 vote

How to clean the Contacts and relevant Users

You could use Search > Search Builder and search for Individuals whose First Name and Last Name are NULL (when this is the case, Civi will use the email address as the Display Name), select all of the ...
Tamar Meir - Cividesk's user avatar
1 vote

After upgrade to 5.0.2 from 4.7.30 getting "DB Error: No such field" on queries

This may be a bug in 5.0.0. The Drupal Demo site (and our 5.0.0 + Drupal 7 site) fails with a similar message if you try to do a search builder search for Contacts > group = or <>. In our site, the ...
Andyg8's user avatar
  • 1,611
1 vote
Accepted

creating a Smartgroup out of post held in an organization

One solution. Create a new Relationship Type of 'President is/of'. Use that relationship to link your Presidents to the Extension Centres (can be done in bulk via Actions from a Search). Then do an ...
petednz - fuzion's user avatar
  • 28.3k
1 vote

Using Export Contacts from Search Builder w/ Field Mapping, mapped field's columns not exported

There is a JIRA issue for this 'oversight' and has been assigned to one of the Fuzion team to work on as part of a community 'pay-back/investment/pay-forward'.
petednz - fuzion's user avatar
  • 28.3k
1 vote

Best way to search through multiple postcode regions

Yes, I agree that RegEx is a good way to solve this. Here's my Search Builder RegEx to select all contacts with postcodes in Scotland, for example: ^(AB|DD|DG|EH|FK|G|HS|IV|KA|KW|KY|ML|PA|PH|TD|ZE)[0-...
David Hepper's user avatar
1 vote
Accepted

Best way to search through multiple postcode regions

In the end I used Search Builder with regular expressions on the post code field. It was quite efficient once I'd learnt the syntax for regex's!!! In case it's helpful for anyone else, here's some ...
Andyg8's user avatar
  • 1,611

Only top scored, non community-wiki answers of a minimum length are eligible