Questions tagged [smartgroups]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
9 votes
2 answers
956 views

Creating a public Members directory with CiviCRM in Wordpress using Profiles

I'm trying to create a public Members directory with CiviCRM in Wordpress using Profiles. First i created a "Smart Group" through Search that lists all the members filtered as i wanted - i've called ...
user avatar
8 votes
6 answers
243 views

Search for contacts within Geocoded regions/borders

My organisation needs to search for contacts within the regions/borders of England, Scotland, and Wales. This is important as our communications relate to elected representatives within devolved ...
user avatar
8 votes
4 answers
254 views

CiviMail and Smart Groups: when does CiviCRM identify the actual list of email recipients?

If I set up a mailing to a smart group, and schedule it to go out one month from today, will CiviMail send to the contacts in the smart group as they are defined at the point when I create the mailing,...
user avatar
  • 3,664
7 votes
2 answers
281 views

Can I create a Smart Group programatically?

I'm setting up our system to match up contacts with the geographical regions covered by our different chapters. I've gotten to the point of using the built in geocoding, along with polygon ...
user avatar
  • 870
7 votes
1 answer
149 views

How to disable cache refresh on Manage Groups page

The Manage Groups page in Civi 4.5+ displays counts of contacts in each group, and in the process refreshes the smart group contact cache. We've turned off this cache elsewhere as it takes 10mins to ...
user avatar
  • 1,960
7 votes
2 answers
191 views

Preventing slow performance with smart groups

After doing some research (Capacity Planning), it appears as if Civi slows down when there are a lot of smart groups or if the smart groups are children of other groups. What should be some good ...
user avatar
  • 367
7 votes
1 answer
183 views

CiviMail: What is the expected behaviour when unsubscribing from a mailing sent to a parent group?

I'm sure I remember reading somewhere ages ago that when unsubscribing from a mailing sent to a parent group, the contact would be removed from all of the child groups that they belong to that are ...
user avatar
  • 141
6 votes
1 answer
263 views

How to use Smart Groups with relative dates?

How can I setup a Smart Group to include members based on relative dates (e.g. last Activity)? When I try to use relative date, e.g. Yesterday in advanced search, it correctly finds users with ...
user avatar
  • 1,012
6 votes
2 answers
156 views

Create a membership list with employee name

I have a public directory list that is created based on a relationship with an organization that is set-up as a smart group. I have a profile that lists the organizations that are included in the ...
user avatar
5 votes
1 answer
84 views

How can I create a smart group with no matching contacts?

Is there a way via the UI to create a smart group with no matching contacts in the database? For example, our database does not currently have any contacts where the city is "Cottonwood," but I'd like ...
user avatar
  • 75
5 votes
2 answers
127 views

How Smart Groups Work

What updates a smart group? Is it all based on the cron/scheduled job that runs updating the group members based on specific criteria? Additionally are hidden smart groups updated when the cron/...
user avatar
  • 471
5 votes
2 answers
65 views

Should smart groups be highlighted so users are aware they are smart and so avoid corrupting them?

One of my users has corrupted most of their smart groups by manually adding & deleting contacts. Talking to the user, she was not aware of what was a smart group and what was a regular group. in ...
user avatar
  • 4,263
5 votes
1 answer
40 views

Presales / Functionality Question

Presales Question… I’m trying to determine which features can be turned on & off with this CRM system, so I have a couple of questions I need to ask based on the scenario that I’m trying to solve ...
user avatar
5 votes
3 answers
556 views

What do I do when rebuild Smart Group Cache fails?

(Sorry, was hoping to not have to start a new Question but instead comment on another's but StackExchange doesn't allow it unless you have 50 points of privileges.) CiviCRM 4.6.0 Joomla 3.4.1 I am ...
user avatar
  • 811
5 votes
1 answer
75 views

Deadlocked queries cause an instant error for end-users, but are retried in other circumstances

We have a lot of smart groups, and consequently a lot of deadlocks. There's already code in Civi that detects deadlock Exceptions, and then retries the query a few times. This is really helpful - I ...
user avatar
  • 1,960
5 votes
2 answers
272 views

Deadlocks in Rebuild Smart Group Cache

Sorry in advance for my lack of familiarity with civi, I'm not the most experienced member of the team. We seem to be running into a problem with the Rebuild Smart Group Cache job where the cpu will ...
user avatar
  • 103
4 votes
3 answers
589 views

Update of Smart Group cache

I am on CiviCRM 4.6.2 on WordPress and recently noticed that Smart Groups are not updated. If I look at contacts in a Smart Group it will say one number. But if I then click on Edit Smart Group ...
user avatar
  • 163
4 votes
1 answer
247 views

How do the Rebuild Smart Group Cache scheduled job and the Smart group cache timeout setting interact?

According to the UI (Administer > Customize Data and Screens > Search Preferences) the 'Smart group cache timeout' setting allows you to specify "the number of minutes to cache smart group contacts". ...
user avatar
4 votes
2 answers
250 views

Can't update smart group counts

My smart groups show unknown counts. Debugging shows this when I click "update smart group counts". Wordpress 5.0.3, Civi 5.9.0, PHP 7.2.14 #0 /var/www/sln/wordpress/wp-content/plugins/civicrm/...
user avatar
  • 101
4 votes
2 answers
342 views

How to retrieve all contacts belonging to a smart group

Given the ID of a smart group, what API/BAO/whatever do I need to use to retrieve all contacts belonging to that group? I've been looking through the source code all morning and can't seem to find ...
user avatar
  • 172
4 votes
3 answers
409 views

Manually adding/removing contacts in a Smart Group

If you manually add/remove contacts to a Smart Group will they remain in the group when the group updates?
user avatar
4 votes
2 answers
55 views

How to exclude contacts from a mailing who share an email with a group of contacts?

If I'm sending out emails asking for donation, I exclude all the contacts who have donated recently with a smart group. Unfortunately, because we have many contacts who share an email (generally ...
user avatar
  • 1,569
4 votes
1 answer
312 views

Can Drupal Views filter contacts based on Smart Groups

Taking the liberty of creating this new ticket since the previously similarly titled (since retitled by me) post was not really addressing the issue. Laryn is correct when he said on the above post ...
user avatar
  • 27.1k
4 votes
1 answer
130 views

Does CiviRules work with smart groups?

I've tried to create a rule where an email gets sent when a contact is "added" to a smart group. By "added" I mean the condition that smart group is based upon is met. As far as I can tell it doesn'...
user avatar
  • 2,913
4 votes
1 answer
312 views

SOLVED!! DB Error: no such table ERROR searching erroneous ACL table

I have read other related questions but I do not see a match with my mistake. Civicrm version 4.7.31 Drupal 7.67 MySQL 5.6.42 PHP7.1 After migrating from civicrm 4.5.8 and php5.6 everything works fine ...
user avatar
  • 41
3 votes
2 answers
80 views

Can you search for only manually added members of a smart group?

Is there any way to search or sort the manually added members of a smart group (versus the smart members)? It seems like there should be, but I don't see any option anywhere. It isn't possible to sort ...
user avatar
  • 1,569
3 votes
1 answer
66 views

Smart Group relative date criteria not saving

There is a history of a bug in which Smart Groups do not store the proper relative date ("Next 60 days") criteria, but rather convert the relative date into a hard date ("3 Jan 2018" to "4 Mar 2018"). ...
user avatar
3 votes
1 answer
81 views

Smart Group DB error

Viewing some Smart groups (not all) causes DB error. [error] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) [...
user avatar
3 votes
1 answer
70 views

Smart Group dropping search criteria on save

I've searched the archives and see there are a number of posts pertaining to smart groups not saving criteria, but it seems those were bugs addressed in updates, and we are running the latest version ...
user avatar
  • 549
3 votes
1 answer
112 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 ...
user avatar
  • 1,569
3 votes
1 answer
309 views

Why do Smart Groups now give database errors?

I just updated from 4.6.3 to 4.6.5, on Joomla. I have a number of Smart Groups which worked fine before, but now inconsistently fail to load contacts or settings, giving a database error instead. ...
user avatar
  • 870
3 votes
1 answer
133 views

When the smart group cache is regenerated, are disabled smart groups regenerated?

I work with a CiviCRM install with about 400 smart groups - but only about 30 of them are enabled. I'm seeing slow performance - I'm wondering if anyone knows definitively whether my disabled smart ...
user avatar
3 votes
2 answers
108 views

Discrepancy between # of contacts in smart group vs # of contacts in smart group mailing

Using Drupal 7.67 and CiviCRM 5.13.5. We run volunteer inductions, and send an email to all people who have attended volunteer inductions (as per CiviEvent) after the induction. We only run ...
user avatar
  • 544
3 votes
1 answer
70 views

Caldera Forms and Smart Groups

I want to have a newsletter signup form that has a dropdown field that a non-signed in user can select from. I want their selection to assign them to a smart group for later use in bulk mailings. What'...
user avatar
  • 31
3 votes
1 answer
93 views

Is there any reason to not run the scheduled job Clean-up Temporary Data and Files every hour?

I discovered some problems with Smart Groups that use IN search criteria for custom fields not showing counts. I have the scheduled job Rebuild Smart Group Cache running. However, only after running ...
user avatar
3 votes
1 answer
82 views

A Smart Group of Contacts

We made around 100 contacts at a recent conference. How can I set up a smart group of these contacts that are not currently in our database?
user avatar
3 votes
1 answer
73 views

Can I search "Added By/Modified By" with a contact ID instead of a name?

First, I'm French and my english is not good, sorry. currently using CiviCRM (4.6.10) production coupled with Joomla (3.5.0) (thanks to this forum), I currently have a problem with the smart group ...
user avatar
  • 31
3 votes
2 answers
50 views

Is it possible to view smart group membership in Views?

I have a view set up to display the content of groups but it only works for viewing manual group membership, not smart groups. (I have the form set to require input rather than the basic form style.) ...
user avatar
  • 2,416
3 votes
3 answers
112 views

System status - disabled/deleted fields on Smart Groups (5.24)

After upgrading to 5.24 I get the above message in system status. I've disabled and re-enabled all smart groups but the message persists and I can't find any redundant custom fields. The message ...
user avatar
  • 4,263
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
  • 96
3 votes
1 answer
40 views

How to Create a Smart Group before Anyone Belongs to it?

The usual way to create a Smart Group is : Select (via Advanced Search) the contacts who meet the Search Criteria Create the pertaining Smart Group But is it possible to create a Smart Group before ...
user avatar
3 votes
1 answer
301 views

Quick explanation of 'hidden smart groups' and why they're included in my mailing uninvited?

I haven't been able to find information on these hidden smart groups anywhere using google or this forum. Perhaps because they are hidden on purpose? I'm wondering what these groups are, and why, ...
user avatar
  • 1,489
3 votes
1 answer
105 views

Why can't Smart Groups be assigned the Access Control group type?

I'm using CiviCRM 4.5.8 and WordPress. I want people to only access the data for their state. I was going to use ACL to do that. I set up a smart group for Wisconsin, but there's no check box for ...
user avatar
  • 733
3 votes
4 answers
73 views

CiviCRM for selection and subscription to paid online content

Consider this case: We manage a very very long hiking trail across many states. It's divided in 20 sections. To get the digital maps, section coordinator contacts, section emergency alerts, section ...
user avatar
  • 31
3 votes
4 answers
443 views

Smart Groups - cannot get smart groups to refresh

I have read as much as I can about smart groups but I am having problems that I am not able to solve. I have a smart group which shows the same SQL as an Advanced Search but they produce different ...
user avatar
3 votes
1 answer
80 views

How can I automatically add a Capability or additional Role in WordPress based on the data stored in CiviCRM?

* EDIT * We have a multi record custom data group with a field called "Status". When this field changes value to "Completed" we want people to see specific pages in WordPress. I have tried to setup a ...
user avatar
  • 696
3 votes
0 answers
62 views

Edit smart group criteria resets Group(s) to Administrators

I just found this issue on the latest 4.6.21 release but was able to reproduce on 4.6.18 as well. When I create a new smart group: Search -> Advanced Search -> Choose any group but ...
user avatar
  • 96
3 votes
1 answer
96 views

Attributes of dumb groups

In the table civicrm_group, I've noticed that even my non-smart groups have the fields where_clause, where_table, and select_table filled in. These don't seem necessary and cause a fair amount of ...
user avatar
  • 1,047
2 votes
2 answers
256 views

Can a user removed from smart group manually be added back automatically if criteria is satisfied?

I have a requirement, where I need to Limit Scheduled Reminders to Only Members with Active and Grace Status(which is a smart group) But If I remove a user manually from Member with Active And ...
user avatar
  • 831
2 votes
3 answers
196 views

How to show Users their Membership status so that even users without a membership status get to see the block

We have a client we would like to show the current logged in users membership status in a Drupal View alongside other contact fields. As the user may not have a membership yet at all then this can't ...
user avatar