Questions tagged [search]
The search tag has no usage guidance.
268
questions
0
votes
1
answer
11
views
Show first name and then last name in activity search results
In my organization we have specific needs with the search for activities. In the activity search results we want to show the results of the "With" column first the First Name and then the ...
2
votes
1
answer
31
views
I have a randomly recurring problem in Search Builder. Why do the drop-down lists of options sometimes collapse horizonally?
Screen shot of the collapsed filter options.
CiviCRM 5.66.0 Joomla! 3.10.11
- 317
1
vote
1
answer
90
views
How can I add custom date range in CiviCRM date picker?
The standard Choose Date Range date picker allows to select from multiple presets, including Last 7 days, Last 30 days, Last 60 days.
Is there a way to configure my own preset (in this case last 35 ...
- 1,044
1
vote
2
answers
46
views
Common Issue with Quick Search Functionality After Upgrading Multiple CRMs
I have recently upgraded multiple CRM instances to version 5.67.0 their respective latest versions, and I'm encountering a common issue with the Quick Search functionality in all of them. Before the ...
- 426
1
vote
0
answers
26
views
Problem with Smart Group display pagination past 500 contacts
CiviCRM 5.66.0 / WordPress / PHP 8.1.24
There is a smart group with ~870 contacts. A user goes to view the contacts from the contacts shortcut on the Manage Groups page. When viewing the contacts at ...
- 11
0
votes
0
answers
15
views
Order search results by last login
I'm trying to search our CiviCRM database for contacts related to a specific other contact and order the results by date of their last CMS login. I've looked at Advanced Search, Search Kit, and Data ...
- 745
0
votes
0
answers
26
views
Allow Search using Enter key on search kit search form
Using search kit we can do Auto-Run and Button Click Search.
On Button search option, I Need to add functionality to search using Enter key too (just to avoid click button every time and do not want ...
- 323
0
votes
0
answers
7
views
Profile error when using search
The error message is:
"The requested Profile (gid=1) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR there is no Profile with that ID OR you do not have ...
- 365
1
vote
1
answer
24
views
How Do you Display a Street Address using Searchkit?
I am performing a search in searchkit and I want to display the primary address in the search results. I can easily add city state and zip, but I cant seem to add the street address fields. Instead a ...
- 3,352
0
votes
1
answer
22
views
Mutliple memberships search trouble
Occasionally I have a member that ends up with multiple memberships. I think these may be a result of duplicate merging. So a member may have an expired membership and a current membership.
I have ...
- 136
2
votes
1
answer
18
views
Tracking Repeat Attendees
I am looking to report on how many of our event attendees have previously attended an event, but I can't seem to find a way in search-kit.
Search for "contacts who have registered for [event x] ...
- 23
1
vote
1
answer
48
views
Search by 4 months ago on Membership
We have civi 5.53 and Wordpress.
I am wanting to deal with overdue memberships. We have an end date of the last day of the month. Start date doesn't work for us so using end date.
I can use the ...
- 161
1
vote
1
answer
40
views
How can I search for contacts without a specific Activity Type?
I have created an Activity Type "Ceremonial" to attach to Contacts via Cases, which I am using to track qualifications we have awarded, honours we have granted and Fellows that we have ...
1
vote
1
answer
49
views
How do I eliminate records in which a specific field is blank in a search?
I'm trying to eliminate records that do not have a mailing address from a list I want to export. So, how do I do a search to eliminate records in which the city field is blank?
- 11
0
votes
1
answer
19
views
Advanced Search returns contacts with current memberships even though Current Member set to "No"
When using Advanced Search and 'Display Results As' is set to "Contacts", I assumed that if I selected "No" for 'Current Member', it would not include contacts that had at least ...
- 826
2
votes
1
answer
94
views
Undefined array key "rows" in Search.tpl.php when entering "Manage Groups"
The PHP warning appears everytime when a user enters "Manage Groups" (/civicrm/group).
The full warning:
Warning: Undefined array key "rows" in include() (line 6 of sites/default/...
- 419
0
votes
1
answer
15
views
How to search for civi contacts who don't have a Joomla user account
Is there a way within the civiCRM GUI to search for just those contacts who do or do not have an associated Joomla user account?
- 535
0
votes
1
answer
37
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?
- 3,352
3
votes
2
answers
133
views
ERROR Class 'CRM_Search_Upgrader' not found since upgrading to 5.45.1 Joomla
When I try to navigate to "system status" nothing shows up now after upgrading to 5.45.1. I get a blank screen.
When I select "administrator" then select "extensions" I ...
- 153
0
votes
0
answers
24
views
ContactID List as URL Parameter
I am looking for a way to pass a comma separated list of contact ID's to Civicrm in a URL call and return the list like one can do with the Search Builder "in" clause.
The URL will be formed ...
- 1
0
votes
1
answer
33
views
Search builder fails In Group and Not In Group Search
This was run on your demo account using Search Builder. All the records selected are in both groups.
8 Contacts
Group(s) In Advisory Board ...AND...
Group Status 'Added' ...AND...
Group(s) Not In ...
2
votes
1
answer
70
views
Searching for contacts using a list of first/last names
I've got a list of names that I need to find the contact profiles for. I only have the first and last name, is there a way to search for a batch of people and show up as a list view rather than ...
- 91
0
votes
2
answers
54
views
Group search not available on all search screens except for search builder
Ever since Civi 5.35.2, group search does not populate for non-admin users. See discussion here: https://github.com/civicrm/civicrm-core/pull/19372. Before all groups would show. On multisite. Users ...
- 3,501
0
votes
0
answers
15
views
Why is CiviCRM 5.38 making search fields on a directory listing display using a "ui-spinner-input"?
I've got a site that displays a searchable directory of organisations using a CiviCRM profile. When I use the search facility ('Edit Search Criteria') the fields all appear to be displayed using a ...
- 3,935
1
vote
1
answer
55
views
Default Contact Search Profile
Why I cant see created profile in Default Contact Search Profile?
My created profile:
Settings:
- 39
2
votes
1
answer
29
views
Full text search through API
A client of my asked me to implement a Search functionality on their website, which interfaces with CiviCRM through the API. The 'Full text search' functionality of CiviCRM does exactly what is ...
- 21
1
vote
1
answer
19
views
Find contribution excluding certain financial types and sending email
I have around 30 financial types listed in CiviCRM.
I would like to find a list of contribution excluding 5 of those financial types and send an email. This is something needs doing often.
If I would ...
- 2,938
0
votes
1
answer
22
views
Searching for Test Contributions
I have just started making contributions in Test mode. I understand that "Test contributions are not visible on the Contributions tab, but can be viewed by searching for 'Test Contributions' in ...
- 317
1
vote
1
answer
25
views
Bring up contact by Amatuer Radio callsign rather than name
We have a database of Amateur Radio operators. One field is their callsign.
What I would like to do to make editing events faster, is instead of polling by their name, to add callsign to advanced ...
1
vote
1
answer
29
views
Can't proceed a simple search
Hi after a migration on Drupal 7.69 / CiviCRM 5.33.2 everything went fine except that now we can't perform a simple search https://domain.net/civicrm/contact/search?reset=1 when there should be ...
- 2,543
1
vote
1
answer
29
views
Changing display on CiviCase search results
Currently, when I search using Find Cases on CiviCase, the results are displayed in 9 columns: Client, Subject, Status, Case Type, My Role, Case Manager, Most Recent, Next Sched., Actions.
We don't ...
0
votes
0
answers
30
views
Assigning activity to an entire group without doing the search beforehand?
What would be the easiest way to a get the Record Activity screen prefilled with the contacts from a group without having to search before hand?
I wanted to add a link to the menu which would give me ...
- 867
1
vote
1
answer
31
views
List all Profiles in a group when using "Profile Search Form" as a Joomla menu item
I have a Job Postings profile that gets recorded on a contribution form. The user is then added to a "Job Postings" group. I'd like to have a Profile Search Form on a Joomla page (menu item) ...
- 371
2
votes
2
answers
47
views
Is there any way to search for contacts with special characters using other characters in the CiviCRM search?
E.g. ss = ß, ae = ä, ue = ü, oe = ö
Our language is German but English-speaking colleagues should be able to search for German contacts without having to copy a character from the character table. In ...
- 21
0
votes
2
answers
50
views
Enter Phone Number, Show Contact Details with API?
There is a system where we answer calls from our members. We save all of these calls by creating contact information on CiviCRM and create the conversation in an activity.
People answering the calls ...
- 426
1
vote
2
answers
48
views
How to save a search criteria?
is there a way to save the search criteria from a 'search builder' or 'advanced search' for future use without making it a smart group? TIA
- 21
0
votes
1
answer
30
views
How to export member type after an advanced search
I am doing an advanced search in our database.
Members Current - Primary
and a proximity search for these members to be within 100kms of a postal code.
my problem:
when I go to export my results I ...
0
votes
1
answer
20
views
Broken Search Builder
just upgraded to 5.28.3.
Thing is, my search builder is looking like this now - can't select a field anywhere :/
Any Ideas?
Thx & Regards
- 33
1
vote
1
answer
28
views
Smart group url parameter to search contributes
I'm using CiviCRM 5.27 on Wordpress and I'd like to save Civicrm page URL of contributes with smart group filter.
I tried this:
http://mysite.com/wp-admin/admin.php?page=CiviCRM&q=civicrm%...
- 131
1
vote
2
answers
57
views
Why are deleted contacts showing in search results?
I just upgraded a Drupal site to 5.27.1 and am noticing that when I do a search for contacts, contacts that are in the trash are also showing up in results (which did not happen before). I was able to ...
- 8,253
1
vote
0
answers
35
views
Profile listing shows all contacts regardless of permissions -- how to limit results to permissioned contacts only?
If I create a profile for search/listings, and provide access to that profile to some class of users, the profile results will include all contacts matching the search criteria, even though the ...
- 1,794
2
votes
0
answers
31
views
How to use a GROUP_BY / HAVING in extended Advanced Contact Search query?
Based on this solution, I'm trying to add a custom pan in advanced search in order to filter by Line Item Total Sum.
The context
I successfully manage to filter by Line Item Total with these fields:
...
- 191
1
vote
1
answer
70
views
how to search for contacts selected in contact reference fields
Civi 5.15.1, WordPress 5.4.1
Some of our contacts ask us to send our communications to someone else, a "designated contact" or DC. To accommodate them, we created custom Contact Reference fields for ...
- 159
3
votes
1
answer
33
views
Why does searching by contribution source use always the "Like" statement?
I'm currently using CiviCRM 5.21.1.
When I try to search for contributions by typing specific "Contribution Source" under "Contributions -> Find Contributions", it shows me all contribution records ...
- 31
2
votes
1
answer
58
views
Server transfer CiviCRM search problems
We have just transferred a Wordpress installation of CiviCRM 5.21.0 to a new server, but all of the search functions are failing. In advanced search, when I attempt to open for example, "Address", the ...
- 91
1
vote
1
answer
166
views
The requested Profile is disabled
Using 5.17.5 on Wordpress, I've got the dreaded error on a member search form: "The requested Profile (gid=10) is disabled OR it is not configured to be used for 'Profile' listings in its Settings OR ...
- 167
0
votes
1
answer
21
views
Mailings advanced search error - Invalid mysql syntax
I'm on Drupal 7.69 and CiviCRM 5.20.0.
As long as I remember I've been experiencing an error when I've tried to look up the bounced recipients of mailings through Advanced Search.
I can't look up ...
- 95
1
vote
1
answer
41
views
Can't search profile in Wordpress
I have created a new profile in CiviCRM that I want to use for searches of services offered by associate members. When I test the profile from CiviCRM it behaves as expected. If I embed the profile in ...
- 633
4
votes
1
answer
80
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
- 41
1
vote
1
answer
79
views
how to find contacts who have paid for their membership?
Civi 5.15.1, WP 5.3.2
My organization manually enters all memberships and membership payments using the Civi UI (we don't expose this functionality on our website). I need to create a smart group of ...
- 159