8 votes

Organisational search option

Like Jon said auto filtering the search using url param is in progress. But a work around for this until its available is to Create a smart group using advance search for each contact type. Grab ...
Pradeep Nayak's user avatar
8 votes

How to search for contacts by date added or date range added. Alternately: list contacts by date added

Under Search - Custom Searches - Date Added to CiviCRM. Also a variation is under Search - Advanced Search, and expand the Change Log tab.
Demerit's user avatar
  • 22.9k
7 votes
Accepted

Find contacts that have been moved out of a group

There IS a way to search for contacts removed from a group - but it's well-hidden. Go to Contacts menu » Manage Groups. Click the Contacts link next to the group you'd like to see deleted contacts ...
Jon G - Megaphone Tech's user avatar
5 votes

Organisational search option

Create the organizations as contact subtypes of the Organization type: Administer menu » Customize Data and Screens » Contact Types. Now you can easily filter on them during search. If you're ...
Jon G - Megaphone Tech's user avatar
5 votes
Accepted

How can I search contacts removed from a specific group?

I authored Subscription History Report and it's a good choice, but these days I would use Search Kit (an extension which ships with CiviCRM - Administer menu » System Settings » Extensions. From there,...
Jon G - Megaphone Tech's user avatar
5 votes
Accepted

How can I add custom date range in CiviCRM date picker?

You can add your own relative filters using existing ones Navigate to CiviCRM >> Administer >> System Settings >> Option Groups. Look for Relative Date Filters >> Edit Options ...
Pradeep Nayak's user avatar
4 votes
Accepted

Search Confusion

If you need to exclude all of those email options at once for an export or something I would search up those people, put them in a group, and exclude the group from your searches. To search up that ...
Eli Lisseck's user avatar
  • 1,499
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,557
3 votes

How can I search for upcoming birthdays?

There is an extension called "Birthdays By Month" which may prove helpful: BIRTHDAYS BY MONTH This extension lets you look up contacts that have a birthday on a given month. Once installed ...
Laryn's user avatar
  • 8,253
3 votes

Search extension for first name = last name (to purge spam submissions)

Now that I got my computer set up with buildkit, I had a chance to play further with civix and built a simple "first name = last name" search extension to test this out and practice the basics of ...
Laryn's user avatar
  • 8,253
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

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

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

How can I make a Custom Search do an initial search?

Even i wanted an easy way of doing this as well but the current architecture of CiviCRM doesn't allow it automatically. I could achieve this by copying few functions(see below) from ...
Pradeep Nayak's user avatar
3 votes
Accepted

Search for people who have NOT registered for an event using a custom search or data processor

SELECT cc.id, cp.id FROM civicrm_contact cc LEFT JOIN civicrm_participant cp ON cc.id = cp.contact_id AND cp.event_id = 1 WHERE cp.id IS NULL; You can confirm that this works by running this ...
Jon G - Megaphone Tech's user avatar
3 votes

search database to identify addresess

Welcome to this stack community. There are multiple ways you could get what you want. I would use the Search Builder functionality. You can find it in the main menu Search-> Search Builder. You ...
Marko's user avatar
  • 877
3 votes

How can I search contacts removed from a specific group?

How about using Subscription History Report
Pradeep Nayak's user avatar
3 votes
Accepted

Can you Change the Default Participant Search Profile?

I believe configurable search profiles are only available for Advanced Search, and then only when results are displayed as Contacts. From the inline help for Advanced Search: Views For Display ...
davejenx's user avatar
  • 2,365
2 votes

Why doesn't custom search enable "Actions" items for selected records after upgrade to 4.6.3?

In 2021 is the same problem. In custom search you can't enable actions. But I find solution. I looked to the js file which count checkboxes and I found out that you just need remove "crm-ajax-...
Vítek Maňásek's user avatar
2 votes
Accepted

Upcoming Birthdays custom search not working

The easiest way to do this is via the Upcoming Birthdays Report extension.
Jon G - Megaphone Tech's user avatar
2 votes

How to search active relationships (e.g) during past year?

Just stumbled across this old question, but Search Kit is now another option: see here
Aidan's user avatar
  • 13.4k
2 votes
Accepted

How do I create a Smart Group of Participants using a Custom Data Field in Events?

I checked in 4.4 and 4.6. It does not work in 4.4, but it does in 4.6. So, not sure about 4.5, but if you upgrade that far I advise to upgrade to 4.6 anyway, because then you are on the current LTS (...
Catorghans's user avatar
  • 3,544
2 votes
Accepted

Search extension for first name = last name (to purge spam submissions)

CiviCRM 5.69+ can do this with SearchKit. Entity is Contact. Under Where, select First Name, =, then change Value to Field. Then you can select Last Name.
Jon G - Megaphone Tech'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

Custom field data - maintaining uniformity

There are two options: Set your custom fields as a (multi) select if possible. Develop an extension that validates the input using a validateForm hook (or in jQuery)
ErikH - CiviCooP's user avatar
2 votes
Accepted

DB error: Unknown error in search

I think you might have mysql full group by mode on - 4.7 supports that (latest version is 4.7.19) but not 4.6. I think full group by is on by default or always on mysql 5.7 https://stackoverflow.com/...
user4278's user avatar
  • 1,021
2 votes

Update to 4.7.7 broke CiviCRM contact search

This is a regression that has been identified in 4.7.7 - thanks for spotting it. Progress on the issue, and a patch to resolve it, will be posted on the issue tracker here: https://issues.civicrm.org/...
John's user avatar
  • 1,922
2 votes

Searching for incomplete fields

Yes, you need to use the Search builder : Menu search -> Search builder. Then you can choose the record type, the field and most important the operator : you have empty or is null (not defined) ...
samuelsov's user avatar
  • 2,331
2 votes

Can you save an advanced activity search?

The key functionality to do this was added in CiviCRM 4.7.25, with CRM-20630. My understanding is that it's almost but not quite what you need. This allows you to pass variables through in the ...
Jon G - Megaphone Tech's user avatar
2 votes

Why are export field mappings not available for custom search results?

A work-around for this is: From the search results, create a new group. Go to Contacts » Manage Groups find your new group and click Contacts Choose Export Fields It is an annoying bug, but ...
artfulrobot's user avatar
  • 3,930

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