Identify submissions assigned to a copyeditor in the database

Software Support
#1

Hi,
in order to keep track of payments we need to make to copyeditors, I would like to identify which paper has been assigned to which copyeditor in the database. I use OJS3. I found in table “roles” that copyeditors have role_id 8192 and that, for example, user 614 is a copy editor. I know from OJS that this copyeditor is assigned to submission number 111. But, where can I find this information in the database? Which table stores this information? I looked through all of them (I think), but could not find this link.

Many thanks
Gunther

#2

Hi @gunthermaier,

Have a look at the user_groups family of tables.

Regards,
Alec Smecher
Public Knowledge Project Team

#3

I did. There I find information about the different roles. But not the link between the copyeditor and the submission.

Best
Gunther

#4

Hi @gunthermaier,

Try the user_user_groups table for user assignments (journal-wide), and stage_assignments for user group, stage, and submission associations (submission-specific). The full set of interrelated tables are described in lib/pkp/xml/schema/rolesAndUserGroups.xml.

Regards,
Alec Smecher
Public Knowledge Project Team

#5

Now I found it. Many thanks.
Best
Gunther