CiviCRM Community Forums (archive)

Is there any way to get search, etc. to ignore expired memberships for a person if a current membership is available?

We recently ran a search to send an additional renewal reminder to expired members, however it also grabbed a number of people that already had renewed and had a current membership. This affects the monthly newsletter recipients as well as the editor has to manually remove expired memberships for those that have a current membership in the same list - it's very time consuming.

I thought there was some fix in the works to keep all memberships merged into a single record, to avoid situations like this? I understand that if they renewed with a different type of membership this may not be possible, but if the membership types are the same, it would be good to eliminate the duplicate records or at least avoid them.

Alternately if there's a way to create a report that does this, I'm all ears.

Lobo,

Yes, I've tried all kinds of searches but if there's a way to include an if/then statement in the search, I don't know it and haven't seen documentation for it.  What is needed is:

Search Members with status Expired or Grace
If member also has Membership with status Current then exclude all membership records from Search
Display Contacts meeting the criteria

Thoughts??

We'll have to find someone to do the coding, but if it works, I will definitely share.