How can I select all journal managers email in ojs

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?

Hi @Adriano_Jose

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.

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?


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);