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 '16 at 0:02
  • we do have some code for this now but are still testing. – petednz - fuzion Sep 24 '16 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 - CEDC.org Oct 15 '16 at 4:22
  • hey laryn - keen to get testing/ feedback/ improvements on this if/when you can – petednz - fuzion Nov 8 '16 at 2:32

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 '16 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 '16 at 8:17
  • ..and I thought it was a nice rendition of the view on a t-shirt :( - thanks Gents :) – Marsh Apr 9 at 9:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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