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 that

From what I can tell, this stale issue in JIRA is as far as it went towards integrating Civi Smart Groups into Views.

A lot of the discussion occurred in this forum post.

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.

  • another year passes and this is the latest i find (virtual loop)
    – petednz - fuzion
    May 27, 2016 at 0:02
  • we do have some code for this now but are still testing.
    – petednz - fuzion
    Sep 24, 2016 at 7:51
  • Just Googled and found this page again as I ran into this once more. :) Glad to hear there is some movement anyway!
    – Laryn
    Oct 15, 2016 at 4:22
  • hey laryn - keen to get testing/ feedback/ improvements on this if/when you can
    – petednz - fuzion
    Nov 8, 2016 at 2:32

1 Answer 1


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.

  • For us lay folk "materialised views" means basically a cached resultset as a view.
    – petednz - fuzion
    Nov 8, 2016 at 20:31
  • 1
    Yes, but it also means you can create indexes against the view — otherwise the table is created on the fly without indexes.
    – Torrance
    Dec 4, 2016 at 8:17
  • ..and I thought it was a nice rendition of the view on a t-shirt :( - thanks Gents :)
    – Marsh
    Apr 9, 2021 at 9:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.