Hi, I need send a message about system upgrade for all managers.
What db sql can I do to select all emails from the journals managers?
You can send a email to different user role from OJS itself, is not necessary run any SQL statement to do so.
Logged as a Journal Manager follow this path:
Home > User > Journal Management > Roles (Click role you want send email)
Select all emails then click in button bellow send email
. It will open a form where you can custom your message.
Regards,
Israel Cefrin
Public Knowledge Project Team
Hi @israel.cefrin
thank you so much.
I have 80 journals in my OJS system. I would like to send an email to the managers of all journals as I will put the system under maintenance.
Is it possible to send this email to all managers at once?
Regards,
Adriano
I still need help here. Could someone help me, please?
I get using this:
select distinct email from users where user_id in
(select distinct user_id from roles where role_id = 16);