Questions tagged [smartgroups]

The tag has no usage guidance.

23 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
117 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 ...
3
votes
0answers
61 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 ...
3
votes
1answer
95 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 ...
2
votes
1answer
37 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 ...
2
votes
0answers
30 views

Problems with Smart Group Updating

CiviCRM 5.8.2 / Drupal I have defined a Smart Group based upon a custom field (recipient) = 1, to be used as a smart mailing list. (I use VBO to set this field to 1 for my selected recipients, and ...
2
votes
0answers
28 views

Wrong Group counter showing on Contact tab

It can be reproduced in dmaster following the next steps: Go into dmaster Create a Smart Group Add "Manually" a Contact in the Smart Group Go to the Contact (the counter in the Group Tab shows a ...
2
votes
0answers
33 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 ...
2
votes
0answers
18 views

Greater flexibility on visibility of names/descriptions for groups on subscribe/unsubscribe pages

I guess this is something of feature request cum support request. The naming of groups, and the descriptive text used for them has always been used primarily, in my usage at least over the last decade ...
2
votes
0answers
47 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 ...
1
vote
0answers
20 views

How to create smart Group based on BuddyPress profile field data?

We have a WordPress site with BuddyPress, and a few thousand members around the world. Our BuddyPress profile fields include "City", which is saved in wp_bp_xprofile_data (and assigned a geocode saved ...
1
vote
0answers
28 views

Contacts not appearing in a smart group

We have a smart group which returns 1,521 records. One contact which ought to be appearing in it isn't. When I go in to the smar group settings there is an unfinished selection line, when I delete ...
1
vote
1answer
37 views

Want to display in a profile that a particular contact is part of a smart group related to their membership type

We have created a member dashboard in Drupal which displays a civicrm profile with civicrm membership details. Since I could not display membership type in the profile, I created a smart group which ...
1
vote
0answers
39 views

Manage Groups broken in 4.7.10 (and possible workaround)

We upgraded civifrom 4.6.2 to 4.7.10 (on WP) everything worked fine except for accessing the manage groups page. When trying to add a contact to an existing group we got the msg “Error one of the ...
1
vote
0answers
24 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 ...
1
vote
0answers
116 views

Smart Group create/alter via API

What would be the best way of batch Smart Group creation using Relationships data, where Organisation name, taken from Individual Relationship data, should become a Smart Group title and all ...
0
votes
0answers
13 views

Created smartgroup not available for selection

If I do not have the permission to manage groups, I do have the option to create a smartgroup which I cannot access once created. Is this correct?
0
votes
1answer
56 views

deleting groups

under contacts, manage groups, delete; the following notiThis group currently has 35 members in it. Deleting this group will NOT delete the member contact records. However, all contact subscription ...
0
votes
2answers
95 views

Cannot update Smart Groups after upgrade to 5.6.1

After upgrading to 5.6.1, I've discovered that the option to edit the smart group search is missing. Steps: Contacts->Manage Groups Click on Settings beside a group At bottom of screen in 5.6.0 ...
0
votes
1answer
57 views

View and subscribe to Public Smart Mailing groups using {action.subscribeUrl}?

I'd like to use {action.subscribeUrl} so email recipients can view and subscribe to public mailing lists. However, it does not show public Smart group mailing lists. Is there a way to show Smart ...
0
votes
0answers
16 views

Search Irregularities

We are on WP 4.9.4 and Civi 4.7.29 multisite. There is incorrect behavior when trying to do a search on a smart group that is combining a activity type field and a custom field. We have 750 search ...
0
votes
0answers
25 views

Smart group selecting more contacts than match criteria

I've tried to test v4.7.13 smart groups with relative dates after the bug is supposedly fixed: Is it a bug that Relative Dates are broken in Search and Smart Groups? Now, I create an Activity today ...
0
votes
0answers
33 views

Unknown column civicrm_relationship.is_active while child smart group edit (create temporary table fails)

There are a parent Smart Group which contains several "child" Smart Groups. All was working a while, until at some time point it starts throw an error, something like [debug_info] => CREATE ...
0
votes
0answers
35 views

CiviMail - copied mailings incorrectly “remember” recipients

We have a smart group we want to send a mailing to. The mailing (on the first tab) indicates "~458 recipients". But the smart group itself says it currently has 244 contacts. The smart group is the ...