Author Topic: Date Ranges for Smart Groups in Search Builder (Read 1671 times)

vwishrad · August 20, 2009, 01:58:31 pm

I am trying to build a smart group of donors in CiviCRM. I’m using Search Builder and I would like to create a dynamic group that pulls people into the smart group based on their giving history. For example, I’d like to create a smart group for donors who made a gift within the last 24 months. Rather than create a static range --for example all donors with gift between 08/19/2007 and 08/19/2009 – I would rather base the select off the current date. I’m thinking it might look something like CURRENTDATE-24 months. I’m not sure how to make that work in Search Builder.

Any thoughts?

Donald Lobo · August 20, 2009, 04:38:25 pm

search builder does not support that. Your best bet would be to write a custom search (http://wiki.civicrm.org/confluence/display/CRMDOC/Custom+Search+Components) that does it, and build a smart group based on this custom search. You can potentially modify ContributionAggregate for this.

If you do so, please publish your custom search code, so others can benefit. Better yet, patch Contribution Aggregate so that we can incorporate this into core

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: Date Ranges for Smart Groups in Search Builder (Read 1671 times)

vwishrad

Date Ranges for Smart Groups in Search Builder

Donald Lobo

Re: Date Ranges for Smart Groups in Search Builder