Answers.Body: <p>We wrote and used this a few years back but haven't had cause to try it recently - not sure if it offers what you want <a href="https://github.com/fuzionnz/civicrm_views_smartgroup" rel="nofollow noreferrer">https://github.com/fuzionnz/civicrm_views_smartgroup</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-04T17:31:28.657Z
Answers.Text: This does offer what I need, it totally works! (I did have to remember to add the newly created table in my settings file, it does not appear in the list on the Views Integration settings screen but it was two seconds of research to see I needed to add _civicrm_group_contact_union as another table)
Answers.UserDisplayName: RayWright
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-04T18:22:56.663Z
Answers.Text: Glad it is helping you. adding the table is only necessary for those with separate databases
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-16T19:21:48.767Z
Answers.LastActivityDate: 2021-02-16T19:21:48.767Z
Answers.UserDisplayName: petednz - fuzion
Answers.Body: <p>You can join to any CiviCRM table with the <a href="https://www.drupal.org/project/views_civicrm_expose_tables" rel="nofollow noreferrer">Views CiviCRM Expose Tables</a> module, so you can join to <code>civicrm_group_contact_cache</code>.</p>
  <p>I'm not savvy enough about smart groups to know when this is reliable - this table gets destroyed and regenerated on a regular basis, and may come up empty sometimes.  However, since this is for internal use, you could have some way to guarantee that the cache is full (e.g. by regenerating it as part of the user's workflow).</p>
  <p>Another option to consider is Search Kit, if you can upgrade to newer versions of CiviCRM.  It's very Views-like, and can give you a configurable set of columns.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-16T19:22:11.923Z
Answers.Text: We will be updating to the next ESR in March (5.35) - I will definitely be testing this out it looks amazing for empowering users to report in civi.
Answers.UserDisplayName: RayWright
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-02-16T18:50:27.623Z
Answers.LastActivityDate: 2021-02-16T18:50:27.623Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>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.) I'm wondering if there is a way to display smart group membership in views or, because of the nature of smart groups, this is just not possible.</p>
  <p>I'm in Drupal 7, CiviCRM 5.27.7, Views 7.x-3.23 and CiviEntity 7.x-2.2</p>
  <p>(Use case: I'd like to have a form where users can quickly pull up the membership of a group set to be used in a bulk mailing. The users could then review membership. While yes, this can be done in advanced search we were looking at a more Drupal style report where we can also easily display specific columns of information.)</p>
  
Tags: <drupal-views><smartgroups><civicrm-entity>
Title: Is it possible to view smart group membership in Views?
ThreadText: # Is it possible to view smart group membership in Views?
  
  (Asked by: username_0 on 2021-02-16)
  
  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.) I'm wondering if there is a way to display smart group membership in views or, because of the nature of smart groups, this is just not possible.
  
  I'm in Drupal 7, CiviCRM 5.27.7, Views 7.x-3.23 and CiviEntity 7.x-2.2
  
  (Use case: I'd like to have a form where users can quickly pull up the membership of a group set to be used in a bulk mailing. The users could then review membership. While yes, this can be done in advanced search we were looking at a more Drupal style report where we can also easily display specific columns of information.)
  
  **Tags:** drupal-views, smartgroups, civicrm-entity
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2021-02-16. Score: 1 | Accepted answer
  
  We wrote and used this a few years back but haven't had cause to try it recently - not sure if it offers what you want <https://github.com/fuzionnz/civicrm_views_smartgroup>
  
  > **Comments:**
  > **username_0**: This does offer what I need, it totally works! (I did have to remember to add the newly created table in my settings file, it does not appear in the list on the Views Integration settings screen but it was two seconds of research to see I needed to add _civicrm_group_contact_union as another table)  
  > **username_1**: Glad it is helping you. adding the table is only necessary for those with separate databases  
  
  ---
  
  ### Answer by username_2 on 2021-02-16. Score: 1
  
  You can join to any CiviCRM table with the [Views CiviCRM Expose Tables](https://www.drupal.org/project/views_civicrm_expose_tables) module, so you can join to `civicrm_group_contact_cache`.
  
  I'm not savvy enough about smart groups to know when this is reliable - this table gets destroyed and regenerated on a regular basis, and may come up empty sometimes. However, since this is for internal use, you could have some way to guarantee that the cache is full (e.g. by regenerating it as part of the user's workflow).
  
  Another option to consider is Search Kit, if you can upgrade to newer versions of CiviCRM. It's very Views-like, and can give you a configurable set of columns.
  
  > **Comments:**
  > **username_0**: We will be updating to the next ESR in March (5.35) - I will definitely be testing this out it looks amazing for empowering users to report in civi.  
  
  ---
  
  