1

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 Jan 27 '16 at 21:39
  • If that works i will convert to an answer – petednz - fuzion Jan 27 '16 at 21:40
  • Damn, Pete. Should have thought of that - so obvious. Giving it a try now. Will respond back if this works. – Alex Katayama Jan 27 '16 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. – Alex Katayama Jan 27 '16 at 22:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.