Where may I check if user want to "be notified of new publications and announcements"?

[Michevole]

Hello, I use OJS 3.3.0-6.

My manager want to inform our authors about something. We will use an external bulk email service as MailChimp. I can export the users registered as author from the database, it’s ok.

But I want to be GDPR compliant, so I would keep in my list only the users who checked the following option during the registration:
Yes, I would like to be notified of new publications and announcements.

Is there an entry in database about opt-in/opt-out? Or, where may I check if user want to “be notified of new publications and announcements”?

Thanks

[israel.cefrin]

Hi @Michevole

You can check the table notification_subscription_settings . Any user_id with value blocked_emailed_notification on the column setting_name doesn’t want to receive mail notifications.

Best,
Israel