Questions tagged [search-builder]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 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 ...
1
vote
0answers
26 views

Search Builder: Using "in" operator on a custom multi value field giving unexpected results

we encountered a problem when building searches using the "in" operator. While this should work as if making multiple where statements connected with or, we noticed that on one of our custom ...
0
votes
1answer
27 views

How to search for people not in any groups

I am trying to find people who are not in any groups (both regular and smartgroups) If I use Search Builder, search for contacts where GROUP is empty or is null it returns people who have no regular ...
0
votes
1answer
28 views

Unable to do a search using tag

When doing a contact search using tags from search builder Civi throws DB syntax error, this was working before until Civi upgraded to 5.35.1 Error: SELECT DISTINCT LEFT(contact_a.sort_name, 1) as ...
3
votes
1answer
55 views

Descrepancies in search result counts

I'm migrating to a new Drupal 9 install, and after a decade of using CiviCRM, I want to pare down the number of records. If I do a simple find contacts search with no criteria, I get 74144 results. I'...
1
vote
0answers
35 views

Help to analyse Civi Data. Counting activities and contacts when the field has more than one option

I have a query about analysing data from activities and contacts in Civi. I've tried to be very clear about what is being done and what has been tried, it's not a simple question so thankyou to anyone ...
5
votes
1answer
100 views

How to try out new 'Search Builder'?

I understand from other posts that the new Search Builder is included in 5.29 but is hidden. I'd like to give it a try - how can I access it?
1
vote
0answers
51 views

Search builder - Cant find find Participants in more than one event

Im trying to find people who have attended all 3 of our last 3 annual fund raising dinners. search for participants in "dinner 2018" - get results search for participants in "dinner 2019" - get ...
1
vote
1answer
13 views

Broken Help Link

https://docs.civicrm.org/user/en/stable/the-user-interface/searching Search Builder Help link is broken, referenced here:
1
vote
3answers
46 views

Update Multiple Contributions with Missing Attributes via Search Builder?

We have 300 or so contributions that are missing a custom field. We want to manually update those records. We are running a search for contributions that have a custom field but are missing the ...
1
vote
0answers
23 views

Search Builder broken with search for Member Since

Take a look at the screenshot below. I am searching for "Member since $date" and getting seriously broken results. CiviCRM 5.20.1 on Wordpress 5.3.2
3
votes
1answer
77 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 ...
2
votes
1answer
41 views

(version 5.13/5.14) Search Builder syntax error when "Groups" "is empty"

in the latest versions of CiviCRM (5.13.4 and 5.14) we can no longer search for contacts that are not included in any group through the search builder! First (at least until version 5.12) with this ...
0
votes
0answers
54 views

email search failure

I get this error when searching for any email address in advanced search or search builder. https://pastebin.com/6LRJDyt1 The 1-address alias is not defined, so it fails. In advanced search it does ...
2
votes
1answer
51 views

Neither Advanced Search nor Search Builder offer option to save as Smart Group

The documentation says I should be able to save a search as a Smart Group, but I don't see an option anywhere to do so. I've used both Advanced Search and Search Builder. Neither results screen offers ...
2
votes
1answer
57 views

When using search builder to find contacts that are in multiple specific groups (AND, not OR), 0 results returned

Let's say you have Group A & Group B, and two contacts, Contact A and Contact B. We want our search to find those contacts who are in both Group A AND Group B. For example, if Contact A is in ...
3
votes
2answers
76 views

Search builder does not display date picker for contacts

I am running Drupal 7.61 and CiviCRM 5.8.0. I have recently upgraded from 5.3.1 and when I use search builder to locate contacts using created date the date picker does not display. (See attached ...
1
vote
0answers
79 views

Regex broken in search builder

I'm looking for a bit of reassurance before reporting a bug(s) in the search builder. On my own site, we have a custom field 'Course Code' which we've previously used for regex searches in the search ...
2
votes
1answer
25 views

greater-than-or-equal-to value in search builder is not displaying

When creating a smart group I am no longer able to select the greater-than-or-equal-to value in the operator field. I tested it several times and the only time I can choose the greater-than-or-equal-...
0
votes
1answer
44 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
61 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 ...
0
votes
2answers
109 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 ...
2
votes
4answers
340 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 ...
2
votes
2answers
121 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. ...
3
votes
0answers
38 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 ...
1
vote
1answer
57 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
22 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 ...
0
votes
1answer
52 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
96 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
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 ...
1
vote
1answer
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 ...
0
votes
1answer
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 ...
0
votes
1answer
47 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. ...
1
vote
1answer
43 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
20 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
36 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
80 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
34 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
1answer
177 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
67 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 = ...
1
vote
2answers
32 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->...
5
votes
4answers
46 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
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?
2
votes
2answers
146 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 ...
3
votes
1answer
111 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
28 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
49 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
0answers
48 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 ...
3
votes
2answers
102 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
56 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 ...