Hello
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 (2.2.2.0) 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.
SQL query
Moderators: jmacgreg, michael, jheckman, barbarah, btbell, bdgregg, asmecher
Forum rules
Developer Resources:
Documentation: The OJS Technical Reference and the OJS API Reference are both available from the OJS Documentation page.
Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.
Bugzilla: You can access our Bugzilla report tracker here.
Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.
Questions and discussion are welcome, but if you have a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a technical support question, try the OJS Technical Support subforum.
Developer Resources:
Documentation: The OJS Technical Reference and the OJS API Reference are both available from the OJS Documentation page.
Git: You can access our public Git Repository here. Comprehensive Git usage instructions are available on the wiki.
Bugzilla: You can access our Bugzilla report tracker here.
Search: You can use our Google Custom Search to search across our main website, the support forum, and Bugzilla.
Questions and discussion are welcome, but if you have a workflow or usability question you should probably post to the OJS Editorial Support and Discussion subforum; if you have a technical support question, try the OJS Technical Support subforum.
3 posts
• Page 1 of 1
Re: SQL query
by joaquincf » Mon Mar 23, 2009 2:57 am
I've found the table. It's "published_articles".
Bye
Bye
- joaquincf
- Posts: 49
- Joined: Thu Feb 26, 2009 8:39 am
Re: SQL query
by 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...
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...
- swing
- Posts: 83
- Joined: Tue Oct 09, 2007 2:59 am
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest