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
Hi @gunthermaier,
Have a look at the user_groups
family of tables.
Regards,
Alec Smecher
Public Knowledge Project Team
I did. There I find information about the different roles. But not the link between the copyeditor and the submission.
Best
Gunther
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
Now I found it. Many thanks.
Best
Gunther