CiviCRM Community Forums (archive)

Is there any way to search contacts by aggregate contribution amount?  I can't seem to find this functionality in CiviCRM (currently using version 1.8.11536).

I'd like to be able to extract a list of contacts that have contributed over a certain threshold in aggregate contributions.  Using the advanced search feature seems to restrict the search criteria to individual contributions.

Alternatively, is there any way to create a custom field and populate it with an aggregate contribution amount?

Thanks for any help!

You can potentially accomplish this by writing some code to populate a predefined custom field in the contact (and making that custom field searchable). You can then write a cron job to recompute the totals on a daily basis.

Think I'll try this one first.

Thanks!

I've had limited time to work on this in the past few days, but I believe that I now have a workable solution figured out.  It's not the most elegant solution in the world, but I think it will get the job done.

I should be finished testing it tomorrow, and I had planned on posting the code in this forum thread.

I'll post the code here so you can take a look at it and tell me what you think.

Cheers!