I have a filtering issue I'm trying to deal with:

I created a custom Drupal view so a client can do membership reports. The client requires the ability to do membership reports based on dates (range or specific).

For example - she wants a report of everyone who has expired in the last 45 days. She puts in that date range. She gets her report.

The problem is that it will include people who expired with that date range, but it will also include those who have renewed and are actual current members.

I've tried using aggregation, but it doesn't seem to print these results using the CSV views module.

  • Right. When they renew it creates a separate Membership record. Could you filter out those Membership records by specifying that the Start Date must be less than -45 days
    – petednz - fuzion
    Commented Jan 27, 2016 at 21:39
  • If that works i will convert to an answer
    – petednz - fuzion
    Commented Jan 27, 2016 at 21:40
  • Damn, Pete. Should have thought of that - so obvious. Giving it a try now. Will respond back if this works. Commented Jan 27, 2016 at 21:42
  • This is close - Current/Expired duplicates are filtered out. Unfortunately, it filters out the Current membership information, and leaves the Expired membership information so now they won't know if that person's current membership is expired or not (is that too convoluted). Thanks for pointing me in the right direction. Essentially, whatever the most current membership is so be displayed. Commented Jan 27, 2016 at 22:04


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.