Unassigned, In Review, Accepted, Archived - Database

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

Moderators: jmacgreg, michael, John

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.
Posts: 15
Joined: Thu Feb 05, 2009 2:23 pm
Location: Atlanta, GA

Unassigned, In Review, Accepted, Archived - Database

Postby petienne » Fri Jan 29, 2010 9:20 am

I didn't want to make the thread subject "status" or "submission_progress" as those things seem to mean something specific, the definitions for which lead me to understand that they are not what I'm after.

What I am looking for is how the designations of Unassigned, In Review, Accepted, or Archived are captured within the database. From what I understand "status" has a potential of a binary value which indicate that it is either archived or not. In pursuit of determining which database fields might hold values that would represent unassigned, in-review, or accepted, I've been looking at these other fields within the "papers" table: "submission_progress" and "current_stage". From a related search I've found that "current_stage" is representative of whether it is the "abstract" or "presentation" which is in review (source). The same source also indicates that "submission_progress" is where values are stored related to what step of the submission process a paper is in, however my testing has yielded the result of papers both unassigned and in-review as a submission_progress value of "0".

My question is to verify my current understanding of these various fields and also specifically to ask how one might determine through a database query whether a paper is "unassigned" or "in review".

If someone has the info on hand, a quick summary of the submission_progress field (value & meaning pairs) could be very valuable and certainly appreciated.

In general, any information or resources with the above would be a great help. I've been running reports on a few of our ocs instances lately and these seem to be reoccurring questions.

- Patrick E.

Posts: 952
Joined: Mon May 05, 2008 10:29 am
Location: Vancouver, BC

Re: Unassigned, In Review, Accepted, Archived - Database

Postby mcrider » Thu Feb 11, 2010 1:20 pm

Hi Patrick,

The numbers showing up in the papers table correspond to constants defined in classes/paper/Paper.inc.php--The named constants are pretty self-explanatory so, take a look in there and that should clear things up.


Return to “OCS Technical Support”

Who is online

Users browsing this forum: No registered users and 1 guest