Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [search-builder]

The tag has no usage guidance.

0
votes
1answer
17 views

Search Builder is broken (Civi 5.4.0 / Drupal 7.59)

Search Builder is broken : I don't have any "Select field", but only "Select Record Type" and "Operator" (sorry for the image in french) : You can reproduce this bug on the demo configuration (...
1
vote
2answers
27 views

How to clean the Contacts and relevant Users

Though I use Captcha and reCaptcha, I have a lot of dummy users and Contacts which I can identify by the fact that their sort_name = display_name = email (or sort_name contains an "@"). How can I ...
2
votes
2answers
37 views

Regex search for a list of Contact IDs

I occasionally have a list of contacts outside of Civi but with CiviIDs that I want to search for in Civi, but aren't grouped in any easily accessible way (no common event, activity, tag, group, etc. ...
2
votes
0answers
23 views

how to report a bug - and here's a possible bug about groups and search builder

Just flagging this issue a little higher in people's awareness: On this issue, I made a comment about it perhaps being a bug? https://civicrm.stackexchange.com/a/24842/308 So, how do I report that ...
2
votes
4answers
144 views

After upgrade to 5.0.2 from 4.7.30 getting “DB Error: No such field” on queries

Since updating my CiviCRM 4.7.30 on WordPress 4.9.5, I am getting "DB Error: No such field" when doing queries through Advanced Search or Search Builder. Some of the problems where when I was trying ...
1
vote
1answer
31 views

How to search for all contacts without a tag? Registered for event

I need to find all contacts that are in our system without a tag AND are Individuals AND registered for a specific event. This is what I am doing: Contact -> Contact Type = Individual Participant -> ...
0
votes
1answer
12 views

creating a Smartgroup out of post held in an organization

I created an organization type called "Extension centers". Each extension center will have a post called President. I have already uploaded all the extension centers and the president details into ...
3
votes
1answer
47 views

Using Export Contacts from Search Builder w/ Field Mapping, mapped field's columns not exported

Website is running 4.7.25 over Drupal. I was able to replicate this on this demo site, which is running at version 4.7.28, as well: http://dmaster.demo.civicrm.org/civicrm Here are the steps to ...
0
votes
1answer
25 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?
1
vote
2answers
26 views

Filtering activities by Source Contact ID

I want to search for people who have an activity created by a specific person. Search Builder lists the 'Source Contact ID' field but doesn't populate the information nor filter things appropriately. ...
2
votes
1answer
39 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 ...
0
votes
0answers
37 views

Add new fields by jQuery / Ajax

Is there any way to add form fields on fly ? I am using module_hook_buildForm but these fields are not setting where I wanted to. Actually in search builder you will see fields are adding dynamically. ...
0
votes
2answers
42 views

Best way to search through multiple postcode regions

I'm in the UK where the postcode regions are - well not exactly designed for the digital age shall we say? I need to group everyone in our database into 7 regions that fit our organisation's needs but ...
1
vote
1answer
38 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
23 views

Using custom fields to store secondary addresses

As of now only primary address of a contact is searchable in advanced search. Search is not possible for other addresses of the same contact. So I want the other addresses of contact also searchable. ...
0
votes
1answer
29 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
35 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 ...
2
votes
0answers
19 views

How can i provide a search screen that will show participant information?

I am on Joomla and civiCRM 4.7 and I want to have a search screen available through a Joomla menu item for participant information. I'd like my staff to be able to search for registration items for ...
2
votes
0answers
21 views

Deleting saved searches created via Search Builder leaves data in various tables

When a saved search is created via Search Builder, a row is created in the civicrm_mapping table as well as in civicrm_saved_search table. If the smart group is then deleted via the UI, the rows in ...
0
votes
1answer
26 views

Search builder: searching for Not equals or Not In with tags or groups doesn't include Null

In Search Builder, if I search for contacts with a particular tag then the output returns the contacts with that tag. If I then invert the search using 'Not In' or 'Not equals' it shows all the ...
1
vote
1answer
23 views

Search criteria dropdown choices disappeared

I am using Search Builder to make custom searches. I want to search on a Membership field "Payment Method". After entering the operator = normally a small box appeared with a drop-down of the various ...
1
vote
2answers
22 views

finding members without e-mail addresses

I'm trying to create a report of members who are expired who have not provided an e-mail address so I can mail them a form. In search builder I am using "membership status"=expired, contacts->...
1
vote
1answer
118 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 ...
2
votes
1answer
48 views

Search Builder Issue

I have a problem with Search Builder on my CiviCRM. I just wanted to check how many contacts i have in my db outside of Italy. It should be a simple search: Record Type = Contacts Field type = ...
5
votes
4answers
43 views

How to perform searches with groups of OR statements joined by AND statements

Search Builder in CiviCRM allows groups of AND statements to be connected by OR statements, but not the other way around. That is, I can perform a search like: (X AND Y AND Z) OR (A AND B AND C) ...
1
vote
1answer
39 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?
3
votes
1answer
90 views

Smart Group criteria disappearing or changing

We've been using a number of smart groups created via the search builder and from time to time, the smart group criteria disappear or are changed. For instance, we had five similar smart groups based ...
1
vote
1answer
25 views

Search Builder One of parameters is not of the type MysqlColumnName

Drupal 7.43 / CIVICRM 4.7.7 I am trying to find contacts with no emails (any type eg/ Home, Other) using Search Builder. Using either IS EMPTY or IS NULL, I end up with no result but get a DB error. ...
2
votes
0answers
36 views

Smart groups and date checks

I am trying to create a smart group that always returns the list of contacts whose membership end date is the end of the previous year or earlier (these are lapsed members and we need to chase them ...
2
votes
2answers
108 views

Search builder participants - relative start dates and event types

I'm trying to setup a search that finds participants for: a specified event type, with events that have started within a variety of time periods relative to today: I need to be able to find events ...
2
votes
0answers
24 views

search builder fails with date field in localized civicrm instance

My CiviCRM instance (4.6.11 embedded in Drupal 7.41 in Google cloud) is localized for French language with date format dd/mm/yyyy (31/12/2009). When using a date field in search builder, comparison is ...
4
votes
2answers
81 views

“does not equal” operator not working

We're trying to set up a search that includes contacts with one tag but excludes ones with another tag. Yet the "does not equal" operator does not appear to be functioning. Any ideas what the issue ...
4
votes
4answers
50 views

Search Builder - find one word amongst many

I'm in the process of testing CiviCRM for managing our non-profit contacts. I'm in the process of testing the import function. We already have our current contacts organised into groups. When I ...
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 ...
1
vote
2answers
180 views

How to search for contacts not in a group through the Search Builder

I'm trying to search for contacts who do NOT belong to a given group. I'm using the Search Builder. For Record Type, I select Contacts. Then for Field, I select Group(s). Then I select the ≠ operator....
2
votes
0answers
77 views

Custom fields with advance search and search builder returning wrong results

We have a custom fields to define our contacts regions as tick box for the region, after we upgraded to CivicRM 4.6.8 when we search using this custom field to find the client in a particular region ...
1
vote
2answers
35 views

Strange behaviour with activity type in search builder

One of our users reported a strange phenomenon when using search builder. I recreated this on the demo site. When searching for activity type = Meeting I don't get results: When searching for ...
2
votes
0answers
48 views

How can I select soft credit fields when exporting contributions?

We just upgraded to CiviCRM 4.6.6 (under Joomla! 3.4.4, PHP Version 5.4.44, MySQL 5.6.23) from CiviCRM 4.5.2. The fields Soft Credit For and Soft Credit Amount no longer appear in the drop-down list ...
1
vote
1answer
55 views

How do I search for contacts with “not empty” multiple records field?

today I realized that the search builder does not provide access to custom multiple-record-fields. Thus I'm wondering how it's possible to search for contacts having at least one record of such field. ...
2
votes
1answer
33 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
3answers
77 views

Different search results in Adv Search vs Search Builder

We upgraded yesterday from 4.5.8 to 4.6.5 (with Drupal 7.38). We have a number of custom fields for Individuals which are type multi-select (child's grade in school, marital status, etc.). When we ...
0
votes
1answer
57 views

Problems with Search Builder: Trying to find records with empty Country field

I know I have contacts with no Country - this was something we came across recently when a colleague tried to use the proximity search and known contacts didn't appear. I've used Batch update to ...
1
vote
1answer
54 views

Search builder operators do not work for Preferred Communication Method

You can reproduce this yourself on the demo site: Search Builder > Contacts > Preferred Communication Method = Phone Returns the exact same results as Search Builder > Contacts > ...