OJS OCS OMP OHS

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
The Public Knowledge Project Support Forum is moving to http://forum.pkp.sfu.ca

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.

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?
cffneto
 
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.

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

Re: search on DB

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

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


Return to OJS Technical Support

Who is online

Users browsing this forum: Bing [Bot] and 1 guest