I am using OJS3 and I would like to get a report with the number of unpublished articles per assigned editor. That is something similar as has been available in OJS2 when assigning an editor to an unassigned submission.
I have looked in the OJS2 DB and followed that logic in the OJS3 DB and it looks like it doesn’t work. Mainly I have used the table edit_assignment, but that doesn’t work anymore.
So can you please advise how to get a list of editors with the numbers of assigned unpublished articles to each of them? I mean either the SQL statement or a suggestion with DB tables to use.