Questions tagged [custom-search]
The custom-search tag has no usage guidance.
1
vote
0answers
16 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 ...
0
votes
0answers
18 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 ...
2
votes
2answers
38 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 ...
1
vote
1answer
27 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 ...
2
votes
1answer
59 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 ...
2
votes
2answers
18 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 ...
1
vote
0answers
26 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 ...
3
votes
1answer
44 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!
0
votes
1answer
33 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?
2
votes
2answers
30 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 ...
2
votes
1answer
41 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 ...
2
votes
0answers
59 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 ...
1
vote
1answer
46 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 ...
0
votes
1answer
30 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 ...
1
vote
1answer
37 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 ...
1
vote
1answer
58 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 ...
0
votes
2answers
29 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 ...
1
vote
2answers
216 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 ...
2
votes
1answer
23 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 ...
2
votes
3answers
63 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 ...
2
votes
0answers
24 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 ...
2
votes
1answer
63 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, ...
1
vote
1answer
127 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 ...
1
vote
2answers
405 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 ...
2
votes
1answer
13 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 ...
8
votes
4answers
118 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 ...
1
vote
1answer
44 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?
0
votes
1answer
18 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 ...
0
votes
1answer
28 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 ...
0
votes
1answer
55 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).
...
3
votes
1answer
47 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 ...
2
votes
1answer
94 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 ...
0
votes
1answer
42 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 ...
1
vote
1answer
95 views
How can i solve search issue in civiCRM?
In Wordpress I create two forms: one for a teacher and a second for a student. I need to search for teacher data using the student search form. But I can't understand how to do it. Please give ...
3
votes
1answer
48 views
How do I create a Smart Group of Participants using a Custom Data Field in Events?
We use the Events module to offer three main types of classes: adult art classes, youth art classes, and professional development workshops. Students register online. What I would like to be able to ...
3
votes
2answers
73 views
Search extension for first name = last name (to purge spam submissions)
Some years back there was a forum discussion about a custom search to find contacts where the first name was equal to the last name, which is (or was) common for spam submissions that ended up ...
1
vote
0answers
20 views
Advanced Search/Smart Group returning wrong results based on participant role (CiviEvent participant roles overlap?)
We have a number of participant roles setup in CiviEvent, with IDs ranging from 1-10. This includes a "Participant" role with ID 1 and "Sponsor" role with ID of 10 (and various roles with IDs 2-9 in ...
5
votes
2answers
282 views
How can I search for upcoming birthdays?
Is there a way to find upcoming birthdays in version 4.7?
When I try to find people by birthday in the advanced search, it still searches for people whose birthday is in the current year (birth-date)....
1
vote
1answer
99 views
Extending default search for name to consult a custom field
How would it be possible to hook into civi's searches to always lookup a custom field when searching for name?
Background:
In our setup we handle big departments as distinct contacts. Their name is ...
1
vote
1answer
98 views
Custom Searches
I created a custom search a while back. I copied an existing search and added the fields/sql I needed for the custom search. Things were working fine until the last civi upgrade. Now I am getting this ...
0
votes
2answers
76 views
Custom search settings
I'm trying to set up a new custom search but when I try to run it I get told the search does not exist and " Please verify your custom search settings in CiviCRM administrative panel." I can't seem to ...
0
votes
1answer
64 views
Custom Search Problem - Unknown column contact_a.id in field list when tagging returned contacts
I'm running into almost the same problem that was detailed a couple years ago on the forums at https://forum.civicrm.org/index.php?topic=28829.0. When I run a custom search using the built in ...
7
votes
4answers
165 views
How to search active relationships (e.g) during past year?
We record volunteer relationships for our Volunteer contacts.
A contact is an active Volunteer of our organization if exists a relationship "volunteer for" and this relationship has no an "end date".
...
2
votes
1answer
21 views
building a group from a list of email addresses of contacts
I have a list of email addresses of contacts. I want to create a group out of those contacts. What would be the easiest way to do that on 4.5.3 ?
Note, the IN operator of the search builder doesn't ...
4
votes
3answers
641 views
How should I generate a report (or view) showing contacts and people they have relationships to?
I would like to create a view, or custom report, whoever is easier, to show the following:
-The names of all contacts in a specific group
-Some of their contact information
-The names of all contacts ...
2
votes
1answer
34 views
How can I search in the greeting fields?
I would like to do a search in the greeting field for all contacts with the greeting 'Dear%'. Neither with the search builder nor the contact search I was successfull. Can anyone help? Thanks!
1
vote
0answers
26 views
Javascript prevents search function!! Selecting result not enabling “Action” menu after upgrading to 4.6.4? [duplicate]
On 4.4 install it was working perfectly. Since I have upgraded to 4.6.4 from 4.4.16 When I do a search (Search ...Custom Searches ... Basic Search) and I get a list of contacts that is more than 1 ...
5
votes
2answers
111 views
Why doesn't custom search enable “Actions” items for selected records after upgrade to 4.6.3?
I have a custom search extension and it was working fine in 4.4.14.
Since I have upgraded to 4.6.3, "Actions" items only enabled for All records. But if I select certain records from result it does ...
3
votes
2answers
201 views
Upcoming Birthdays custom search not working
I have followed the instructions to install the "Upcoming Birthdays" customer search from here.
However, when I run this custom search, CiviCRM gives me blank screen. Our organization is using ...
1
vote
1answer
62 views
How to provide a default sort on a custom search?
There is a function helper
function all($offset = 0, $rowcount = 0, $sort = NULL, $includeContactIDs = FALSE, $justIDs = FALSE) {
// delegate to $this->sql(), $this->select(), $this->from(...
