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 ...
- 39.4k
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 ...
- 24k
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 ...
- 39.4k
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: ...
- 1,113
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.
- 3,627
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
...
- 39.4k
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,...
- 39.4k
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 ...
- 1,057
4
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
- 34.5k
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 ...
- 3,193
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 ...
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 ...
- 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 ...
- 13.6k
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 ...
- 19k
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 ...
- 24k
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 -
- 7,191
2
votes
finding members without e-mail addresses
Rather than is empty try using is null in your search.
- 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 ...
- 1,113
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 ...
- 39.4k
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 ...
- 53
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 ...
- 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 ...
- 1,031
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
- 28.6k
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.
- 2,396
1
vote
How to clean the Contacts and relevant Users
You can use Search Builder to make Smart Group for contacts where Sort Name like @ and First Name null
Name or Email LIKE - '%@%' ...AND...
First Name Is Null ...AND...
Contact Type = Individual
But ...
- 28.6k
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 ...
- 2,079
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 ...
- 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 ...
- 28.6k
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'.
- 28.6k
1
vote
Accepted
Search builder participants - relative start dates and event types
I think a patch for this is now being pushed to core for 4.6 and 4.7. Thanks to the Fuzion team!
- 1,611
Only top scored, non community-wiki answers of a minimum length are eligible