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 ...
- 38.6k
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 ...
- 21.7k
4
votes
Accepted
How to search for contacts not in a group through the Search Builder
You could also use the custom search Include/Exclude, which lets you search for contacts who are not member of a group
- 2,251
4
votes
Search Builder - find one word amongst many
As @ErikH commented correcting the data format before import may be easier if %PAWS% doesn't work.
It looks like you're using ' - ' as your delimiter in that field, which appears to be a single value ...
- 1,499
4
votes
Search Builder - find one word amongst many
The %PAWS% should work.
Another option is, which depends on the number of groups you have.
Export all people of group PAWS to an excel with a unique identifier (external id or email address for ...
- 3,544
4
votes
"does not equal" operator not working
You have to watch out using the search builder when your search involves related entities. Searching for does not equal X on something doesn't exclude contacts with a related entity with a field's ...
- 7,442
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
...
- 38.6k
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,472
4
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 ...
- 38.6k
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
(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,...
- 38.6k
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
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 ...
- 12.9k
3
votes
building a group from a list of email addresses of contacts
If you are not able find a search method that results in the people you want to add to a group. And you have a list of email addresses of the people in the group. You can use the import feature.
The ...
- 2,826
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,183
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 ...
- 17.5k
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 ...
- 21.7k
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 ...
- 38.6k
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 -
- 6,936
2
votes
finding members without e-mail addresses
Rather than is empty try using is null in your search.
- 2,465
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
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
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,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
- 28.1k
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
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-...
- 149
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 ...
- 1,611
1
vote
searching custom field
You can use basic pattern valid in LIKE operator of sql where clause.
For Eg - Using %tech% would result in all three rows.
Similarly you can use [, ], and _ symbols.
To find more about search ...
- 6,936
Only top scored, non community-wiki answers of a minimum length are eligible