You are viewing the PKP Support Forum | PKP Home Wiki

SQL query

OJS development discussion, enhancement requests, third-party patches and plug-ins.

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.

SQL query

Postby joaquincf » Fri Mar 20, 2009 3:16 am


I need to select all articles of an issue from the ojs database.

I want to do it from an external application, using the ojs ( database but I don't know which tables I need to use and the relationship between them. I've been trying but I don't see any relationship between articles and issues into the database tables.

Could you tell me how can I do this sql query?

Thanks in advance.
Posts: 49
Joined: Thu Feb 26, 2009 8:39 am

Re: SQL query

Postby joaquincf » Mon Mar 23, 2009 2:57 am

I've found the table. It's "published_articles".

Posts: 49
Joined: Thu Feb 26, 2009 8:39 am

Re: SQL query

Postby swing » Mon Mar 23, 2009 3:16 am

hi joaquincf,

you will find the article-issue relationships in the table 'published_articles'. depending on what information you would like to get/present you could also need the following tables: issues, issue_settings, sections, section_settings, articles, article_settings, article_authors, article_galleys. the look at the code in the 'DAO'-classes in the directory 'classes/article/' could help (it's probably best to start with 'PublishedArticleDAO.inc.php').
i hope this helps...
Posts: 157
Joined: Tue Oct 09, 2007 2:59 am

Return to OJS Development

Who is online

Users browsing this forum: No registered users and 3 guests