List of new group subscribtion / unsubscription

[samuelsov]

I'd like to be able to create a report of all recent group subscription / unsubscription.
I think just adding a date in civicrm_group_contact that store the date of the latest status change should be enough to let people build search or report.

Also, not my priority but it could be good to also be able to see a trend of how many subscription / unsubscription there is in a group over time.
For this one, we might need to have a full history of the changes. It could be done with a table "civicrm_group_contact_history" with columns : id, foreign key to civicrm_group_contact,  state change, date of state change. If we do so, it could also answer the first need.

Does those changes make sense in the core or is it better to make an extension for it ?
Is there a better way to do it ?

[JonGold]

Hi samuelsov,

There's already a table that stores this, civicrm_subscription_history.  I think I have an extension that does this, let me know if you want me to post it on Github.

[samuelsov]

Thanks JonGold, i was not aware of this table.
Yes please, it could be good to share your extension on github.

If the table is already there, I think we should be able to do search or report on it so i think it should be added to core CiviCRM.

[JonGold]

Hi samuelsov,

Here you go! https://github.com/PalanteJon/org.cpehn.subscriptionhistory

[samuelsov]

Whoa, thanks a lot !