Using 'Active' to count members.

I use the 'subscribed' flag in the database to create reports for our organization, testing for a '1' in the field.

Our renewal notices are finally going out on a regular basis, and I now realize that if someone renews before their expiration date, a secondk 'Active' subscription is created. It seems like there needs to be another value in that field like 'paid ahead' or 'future'.

Or is there another way I should be extracting this data?

Hi Derrick

Not sure what version of the extension you are using. If you are using latest version, you can use these fields:

plan_main_record = 1
plan_subscription_status = 1

Basically, in Membership Pro, one subscriber can have multiple subscription records for each plan which he subscribed, however, plan_main_record and plan_subscription_status will store the correct subscription status of the subscriber for that plan

Give it a try, it should be what you need

Tuan

I haven't updated yet, but I wanted to confirm that there is a way after the update to extract the subscription information for a single user that has three records with

1. a record with 'to_date' <= today: 'published' = 2 (expired)
2. a record with 'from_date' < today <=' to_date'; published = 1 (active)
3. a record with 'from_date > today and 'to_date' > today; published = 1 (active)

what is the value of the two new fields for these three records? Particularly 2 and 3.

Hi Derrick

1. plan_main_record = 1

2. plan_subscription_status <=> published

3. plan_subscription_from_date <=> from_date

4. plan_subscription_to_date <=> to_date

Look at the data from #__osmembership_subscribers and you should understand what I am talking about

Tuan

I haven't downloaded the new version, so I can't look at the new database file. - and I don't have a clue what your response meant. (it's probably me).

Asked another way,
A person subscribed for a year and their subscription ends in a week.
That person renews today and a new subscription record is established.

Assume that every individual in the database has that subscription history and there are 300 individuals, therefore 600 records.
Is there a field that I can test and count that will return 300 subscriptions?

(Currently, testing for the value '1' in the 'published' field will return 600 subscriptions.)

A related question is, when I download the new version and it has a field that indicates subscriptions that are active ONLY today, will that field be updated for the 300 'active ONLY today' subscriptions?