Questions tagged [custom-search]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
1 answer
27 views

Find Contacts Custom Searches Zip Code Range Search lists duplicates

I entered a range of zip codes and the selected records were duplicated. How do I go about reporting the issue to have my request analyzed for an error on my part or get bug fixed?
user avatar
0 votes
1 answer
22 views

Can you Change the Default Participant Search Profile?

I know you can change the default contact search profile but can you change the default participant search profile?
user avatar
  • 3,165
0 votes
2 answers
182 views

How can I search contacts removed from a specific group?

I need to find contacts that have been removed from a specific group to add them back again in. I can find using custom search if they're not in a group, but not if they were in a specific group. Is ...
user avatar
1 vote
1 answer
34 views

Custom field is set to searchable, but not turning up results in the public directory on the frontend. Wildcard set to "yes" Help?

I've created a public directory based on membership status. It displays information like org. name, phone, address, website, & products & services. The issue I'm having is that my custom field ...
user avatar
  • 103
2 votes
0 answers
14 views

How to pre-fill a civi proximity search profile on a map

We're using Google for geocoding, and when we use Civi's proximity search on a profile we get the very cool option in the search results to view the contacts on a map. When a user chooses this option ...
user avatar
  • 1,571
2 votes
1 answer
27 views

search database to identify addresess

we have about 1400 people in our database. All have email addresses and some have physical addresses. How can I sort/search so I can produce a list of those who have physical addresses? Once we have ...
user avatar
2 votes
2 answers
41 views

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

I need to search for all users who have not registered for an event. Five years ago, I asked the question, and the answer was to create a group of users who did register and then do an include/...
user avatar
0 votes
0 answers
12 views

Default sort field for a Custom Search?

I'm building a custom search and I would like it to have a default sort on (order by) a specific field other than the first field in the list. How can I provide a default sort field? This ...
user avatar
  • 753
0 votes
2 answers
29 views

Custom Search with No Input Parameters just Results

I'd like to create a custom search that goes directly to the results page, without asking the user for input parameters (the WHERE clause is hard-coded, no need for inputs). How can I do this?
user avatar
  • 753
0 votes
1 answer
21 views

How do I use a hidden column in a custom search template?

I have created a custom search based on relationships. Each row shows a contact and a related organisation in separate columns as well as other info. Each contact is automatically linked to the view ...
user avatar
  • 435
4 votes
1 answer
43 views

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

How to search for contacts by date added or date range added. Alternately: list contacts by date
user avatar
  • 41
2 votes
1 answer
69 views

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

I have created a custom search, and it works nicely. What I would really like though is to pass default values to the custom search and it doing the initial search with those values. The user can ...
user avatar
5 votes
2 answers
68 views

Organisational search option

I have three types of organisations: a. institution, b. supplier, c. corporate member. I am creating different menus for manipulating each one of these (requirement of our users). I would like to ...
user avatar
  • 113
2 votes
1 answer
45 views

Organisation relationship search

My organisation is primarily (but not solely) a network of other organisations, so on Civi we have lots of "organisation" contact types, and lots of individual contacts. Some of these individuals are ...
user avatar
3 votes
1 answer
37 views

How do I put saved searches or smart groups as menu options in WordPress?

Is it possible to make custom searches (smart groups) available from the custom menu. For instance, I am tracking elections (organizations) with custom fields for special elections, open races, ...
user avatar
  • 106
1 vote
2 answers
42 views

How do I search Contact Source?

I am getting people added to our database from Contact Source called Get Updates. I don't know what that is.
user avatar
1 vote
1 answer
41 views

Unable to use Price Set Details for Event Participants custom search if price set field option is disabled after a registrant has already selected it

Issue: After disabling an event price set field option that one or more participants had already selected in their registration, you are now unable to run the custom search "Price Set Details for ...
user avatar
1 vote
0 answers
23 views

Missing column headers on a custom search

CiviCRM 5.6.1 Drupal: 7.59 I have a problem with my custom search outside of core, but i was able to replicate issue on "Proximity Search" which comes in core. Steps to reproduce: Go to Proximity ...
user avatar
0 votes
0 answers
57 views

Can I pass parameters in the url to a custom search?

I got a custom search which takes one parameter, group. This search gives us back the people in the group plus a custom status. I'd like to be able to add a number of menu items that would run the ...
user avatar
  • 2,913
2 votes
2 answers
94 views

Can I customise the columns on the 'Find Participants' page?

I'd like to customise the columns on the 'Find Participants' page. I want to swap 'fee level' and 'amount' for 'employer' and 'job title'. Have I missed something obvious in Civi's customisation ...
user avatar
  • 63
1 vote
1 answer
50 views

Proximity search doesn't always work for towns

I'm noticing that the proximity search doesn't seem to work quite as well on towns as it does for postcodes. I've seen this behaviour sporadically. For some contacts it's not an issue, for others it ...
user avatar
  • 1,571
2 votes
1 answer
95 views

HTTP Error 500 during search request - CiviCRM 5.1.1

I have a new installed CiviCRM 5.1.1 property on my server. My current system configuration is: Wordpress 4.9.6 The problem: I importet a few contacts but I realized that besides using the search ...
user avatar
  • 23
2 votes
2 answers
36 views

Custom Search Include/Exclude error message

Using Civi linked to joomla web to manage our membership and various mailing lists. I would like to be able to use a custom search function to find, for example, individuals who are not members, or ...
user avatar
1 vote
0 answers
30 views

Mixing Contact sub-type with Individual data in Profile?

I have a profile containing first name, last name, employer, and contact sub-type. When I load the profile in the front-end and click on search, I'm able to see everyone. On the first screen, I'm ...
user avatar
3 votes
1 answer
93 views

Find contacts that have been moved out of a group

Working with Advanced Search and Search Builder but I can't figure out how to find contacts that were moved out of a group. Civi version 4.7.1 on Drupal. Thanks!
user avatar
  • 45
0 votes
1 answer
53 views

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

I want to search contacts with prefix "Dr." and if possible make it as a smart group. How to achieve these?
user avatar
2 votes
2 answers
49 views

Negative searches: volunteers WITHOUT relationship to supervisor

I need to get a list of Volunteers (contacts) who DON'T have a supervisor (relationship) ...I've tried Advanced Search and looking for relationships, and I've just tried Search Builder. I can put the ...
user avatar
2 votes
1 answer
46 views

Shortlisting contacts with complete address

How do I search in the contacts search / Advanced search that I get only contacts with complete postal address? I have many contacts in civicrm. Some have only city and country names, which is not ...
user avatar
3 votes
1 answer
149 views

Multi-value Custom fields not showing up for export

I have created custom fields for individuals. When I am trying to export data, those which are single value custom fields, I am able to export. While Multi-value Custom fields are not showing up for ...
user avatar
1 vote
1 answer
68 views

searching custom field

I have a custom field for storing educational data. A person's degree is stored as either Btech or B.Tech or B.Tech. so what should I give in search option so that I can get all 3 in my result in a ...
user avatar
0 votes
1 answer
31 views

new feature? - all addresses needs to be searchable

In the latest releases of civicrm 4.7.18 onwards ,we can see the supplemental fields are searchable which is a very good feature. However, one can have multiple addresses and civicrm allows to add ...
user avatar
1 vote
1 answer
45 views

Supplemental address should be searchable

I want the supplemental address fields to be searchable under at least "advanced search". Right now the text entered in "supplemental address" can never be used for searching and retrieving. how do i ...
user avatar
3 votes
2 answers
106 views

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

When using custom searches such as the Include/Exclude search, the resulting contacts can be exported, but there's no option given to select the fields. Fields to be included in the export file are ...
user avatar
0 votes
2 answers
37 views

Custom field data - maintaining uniformity

I want to add Educational information of individuals as custom field set. However I want the data to be entered to be uniform. In our organization, different people will enter data into civiCRM. Some ...
user avatar
1 vote
2 answers
283 views

DB error: Unknown error in search

Using both WP & Drupal with different databases. CiviCRM version : 4.6.28 Drupal version 7.54 Wordpress version :4.7.4 I am trying to use the search option given in CiviCRM. It fails in both ...
user avatar
2 votes
1 answer
33 views

Could an extension add fields to the standard Find Contributions form?

A client would like to search for contributions by payment processor. The built-in search forms don't include a payment processor field, although the data exists within the Civi database. As the ...
user avatar
  • 1,012
3 votes
3 answers
103 views

How can I save Search results with preserving Views For Display Contacts (defined in Profile)?

I have a smart group which I would like to display with specific info in custom columns. I can do Advanced search, select this group and choose predefined Profile in Views For Display Contacts. Then ...
user avatar
  • 1,012
2 votes
0 answers
36 views

Tags in Search Columns

I wanted to include the tags field in a search profile, so they can be shown in the list of search results. But it is not possible because the option "column in search results" is not available with ...
user avatar
  • 43
2 votes
1 answer
112 views

Current members in expired membership search results

In our database, if expired members 'renew' (or rejoin) after their grace period, on their contact page, on the memberships tab, it shows both an expired membership and a current one. That is correct, ...
user avatar
  • 1,159
1 vote
1 answer
185 views

Relationships Search other than via Advanced Search?

Is there an option to find the related contacts (e.g. employee of) of an organization other than with the advanced search? We seem to have an error/bug in our advanced search. It shows the correct ...
user avatar
  • 81
1 vote
2 answers
698 views

Custom Search Unknown column 'contact_a.id' in 'field list'

I'm trying to code a custom search (CiviCRM 4.7.11 - WordPress) and I keep getting Unknown column 'contact_a.id' in 'field list' I built the search by civix as per docs and that created a contact ...
user avatar
2 votes
1 answer
14 views

Searching for incomplete fields

Is it possible to search for a list of records for which a specific field has not been completed? For example, if the options in the custom field are 'yes' or 'no', is it possible to find which ...
user avatar
  • 21
8 votes
4 answers
230 views

Can you save an advanced activity search?

After using Advanced Search to create a pretty detailed search on activities, I need to save it. If my search results were contacts, I could create a smart group based on the search which would ...
user avatar
1 vote
1 answer
49 views

How to search for contacts without a specific relation?

I'm trying to figure out how to search for contacts (individuals) that do not have a "Current Employeer" relation. Is that possible?
user avatar
  • 958
0 votes
1 answer
22 views

How to locate household for event participant

We organize a yearly week where children come to our community center to play and have fun. All children are entered and linked to their household, which is also where we put all contact-information ...
user avatar
  • 197
0 votes
1 answer
66 views

How can I specify which location type address to use for a proximity search

I collect both home and work address data for contacts. I assume - although I've not yet tested it - that the default location type is used when a proximity search is carried out. I have work address ...
user avatar
  • 3,673
0 votes
1 answer
119 views

How do I find users who haven't opened any bulk mail from me recently?

Bounce handling is broken on my site, and so I'm trying to clean my list through several steps. I'd like to get a list of users who have not opened any mailings in the recent past (say six months). ...
user avatar
3 votes
1 answer
60 views

How do I find users who have resubscribed via {action.resubscribeUrl}?

As a matter of ensuring consent is up to date, and because our bounce handling is broken, I have asked my newsletter subscribers to either resubscribe, unsubscribe or opt out. The unsubscribe and ...
user avatar
2 votes
1 answer
100 views

Update to 4.7.7 broke CiviCRM contact search

I update to CiviCRM 4.7.7 from 4.7.6 and immediately got errors for my contact search. The contact search in the upper left corner, Find contacts, and Advanced Search. The error I get is: @import ...
user avatar
0 votes
1 answer
50 views

Search Confusion

I do not understand how to run searches & be sure that anyone who does not have an email address or has opted out of emails in any way is not included. How do I segment the database, to run ...
user avatar