I have 130 members that pay annually on 90 of them I have added "expired subscription for 2009" on 50 of them I have also added "expired subscription for 2010" I want to be able to filter on all users that have:- "Having no active or expired subscription to:" "2009 membership" and "Having no active or expired subscription to:" "2010 membership" which I guess should show around 40 - 70 members. However, if I use the filter "Having no active or expired subscription to:" "2009 membership" I get back ALL 130 members and the same if I search for "Having no active or expired subscription to:" "2010 membership" using amv4.2.6 Please can you tell me how I can search for members that have NO active / expired memberships for either years? Also, if I want to search on an AGE field, how can I search for members LESS than or OLDER than a certain value????
bump. Alex please incorporate this WITHOUT requiring the use of a SQL statement. This goes back all the way to: http://www.amember.com/forum/threads/email-expired-memberships.11576/ http://www.amember.com/forum/posts/45349/ http://www.amember.com/forum/posts/45351/ http://www.amember.com/forum/threads/expired-export-only-accounts-with-no-active.13306/ http://www.amember.com/forum/threads/mailing-labels.4940/ You could try some of the options in the above threads. Like the following: Code: select * from amember_members where member_id in (select distinct(member_id) from amember_payments where product_id in (2,20) and completed = 1) and member_id not in (select member_id from amember_payments where product_id in (2,20) and begin_date <= now() and expire_date >=now() and completed =1) and unsubscribed=0 It will select members who have products 2 or 20 and don't have active subscriptions to product 2 or 20
Dear beenyuk1, there was fixes for this function, please upgrade to latest 4.2.11 vacc_webmaster, this is already implemented in v4, look at "Advanced" search conditions for members. The query you specified is OK, but it will not work in v4, as database structure has changed.
thanks alex, can you let me know if there is a specific file(s) that need to be updated for the search function fixes, as i am hesitant about doing a FULL upgrade as I have some specific custom tweaks added to certain files.
I am afraid partial upgrade will add more problems than it may solve. What exactly have you customized? May be I will show you the way to move it to a module or a custom plugin?
I've had to customise so much it hurts. worldpay config currency config dashboard layout custom code added to wordpress layout pages removing popup windows/modals I'll go through the fies and see if I can manually update each file....