You are viewing the PKP Support Forum | PKP Home Wiki

search on DB [RESOLVED]

Are you responsible for making OJS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher

Forum rules
What to do if you have a technical problem with OJS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a development question, try the OJS Development subforum.

search on DB [RESOLVED]

Postby cffneto » Mon Feb 11, 2008 9:56 am

i want make a search on DB to identify the reviewers, but i dont know how index review_id (table review_assignments) with the respective user. anyone help me with this problem?
Posts: 37
Joined: Wed Jul 04, 2007 9:22 pm

Re: search on DB

Postby smiri » Mon Feb 11, 2008 11:33 am

Hi There,

The user_id of the users table and reviewer_id of the review_assignments table are the same. So you can look up the user by looking up his reviewer_id(user_id) in the users table.

Posts: 183
Joined: Thu Sep 06, 2007 7:01 pm

Re: search on DB

Postby cffneto » Mon Feb 18, 2008 11:38 am

Posts: 37
Joined: Wed Jul 04, 2007 9:22 pm

Return to OJS Technical Support

Who is online

Users browsing this forum: No registered users and 3 guests