Answers.Body: <p>There is a module in development here <a href="https://github.com/fuzionnz/civicrm_views_smartgroup" rel="nofollow noreferrer">https://github.com/fuzionnz/civicrm_views_smartgroup</a></p>
  
  <p>It comes in two flavours (as separate branches) — a simple and complex variety — that differ only in their implementation. For small databases, the simple version is recommended and is more robust. The complex version speeds up Views and is required for large databases with lots of group contacts, but pays a penalty in being less robust. Unfortunately, mysql's lack of materialised views makes this necessary.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-08T20:31:26.770Z
Answers.Text: For us lay folk "materialised views" means basically a cached resultset as a view.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-04T08:17:07.460Z
Answers.Text: Yes, but it also means you can create indexes against the view — otherwise the table is created on the fly without indexes.
Answers.UserDisplayName: Torrance
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-04-09T09:51:51.973Z
Answers.Text: ..and I thought it was a nice rendition of the view on a t-shirt :(   
  
  - thanks Gents :)
Answers.UserDisplayName: Marsh
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-11-08T01:59:35.217Z
Answers.LastActivityDate: 2016-11-08T20:29:20.900Z
Answers.LastEditDate: 2016-11-08T20:29:20.900Z
Answers.UserDisplayName: Torrance
Body: <p>Taking the liberty of creating this new ticket since the previously similarly titled (since retitled by me) <a href="https://civicrm.stackexchange.com/questions/8642/drupal-views-and-smart-groups">post</a> was not really addressing the issue.</p>
  
  <p><a href="https://civicrm.stackexchange.com/users/26/laryn-cedc-org">Laryn</a> is correct when he said on the above post that </p>
  
  <blockquote>
    <p>From what I can tell, <a href="https://issues.civicrm.org/jira/browse/CRM-13835" rel="nofollow noreferrer">this stale issue in JIRA</a> is as far as it went towards integrating Civi Smart Groups into Views.</p>
  </blockquote>
  
  <p>A lot of the discussion occurred in this <a href="https://forum.civicrm.org/index.php?topic=25479.15" rel="nofollow noreferrer">forum post</a>. </p>
  
  <p>I am hoping a current project will help/force us to get back to this. But at this point the question is has anyone else either worked on this, or need this and could help fund us to deliver it.</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-27T00:02:34.623Z
Comments.Text: another year passes and this is the latest i find (virtual loop)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-09-24T07:51:10.627Z
Comments.Text: we do have some code for this now but are still testing.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-10-15T04:22:24.553Z
Comments.Text: Just Googled and found this page again as I ran into this once more. :) Glad to hear there is some movement anyway!
Comments.UserDisplayName: Laryn
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-11-08T02:32:24.813Z
Comments.Text: hey laryn - keen to get testing/ feedback/ improvements on this if/when you can
Comments.UserDisplayName: petednz - fuzion
Tags: <drupal-views><smartgroups>
Title: Can Drupal Views filter contacts based on Smart Groups
ThreadText: # Can Drupal Views filter contacts based on Smart Groups
  
  (Asked by: username_0 on 2016-04-15)
  
  Taking the liberty of creating this new ticket since the previously similarly titled (since retitled by me) [post](https://civicrm.stackexchange.com/questions/8642/drupal-views-and-smart-groups) was not really addressing the issue.
  
  [username_1](https://civicrm.stackexchange.com/users/26/laryn-cedc-org) is correct when he said on the above post that
  
  > From what I can tell, [this stale issue in JIRA](https://issues.civicrm.org/jira/browse/CRM-13835) is as far as it went towards integrating Civi Smart Groups into Views.
  
  A lot of the discussion occurred in this [forum post](https://forum.civicrm.org/index.php?topic=25479.15).
  
  I am hoping a current project will help/force us to get back to this. But at this point the question is has anyone else either worked on this, or need this and could help fund us to deliver it.
  
  **Tags:** drupal-views, smartgroups
  
  > **Comments:**
  > **username_0**: another year passes and this is the latest i find (virtual loop)  
  > **username_0**: we do have some code for this now but are still testing.  
  > **username_1**: Just Googled and found this page again as I ran into this once more. :) Glad to hear there is some movement anyway!  
  > **username_0**: hey laryn - keen to get testing/ feedback/ improvements on this if/when you can  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-11-08. Score: 3 | Accepted answer
  
  There is a module in development here <https://github.com/fuzionnz/civicrm_views_smartgroup>
  
  It comes in two flavours (as separate branches) — a simple and complex variety — that differ only in their implementation. For small databases, the simple version is recommended and is more robust. The complex version speeds up Views and is required for large databases with lots of group contacts, but pays a penalty in being less robust. Unfortunately, mysql's lack of materialised views makes this necessary.
  
  > **Comments:**
  > **username_0**: For us lay folk "materialised views" means basically a cached resultset as a view.  
  > **username_2**: Yes, but it also means you can create indexes against the view — otherwise the table is created on the fly without indexes.  
  > **username_3**: ..and I thought it was a nice rendition of the view on a t-shirt :(     - thanks Gents :)  
  
  ---
  
  