OJS development discussion, enhancement requests, third-party patches and plug-ins.
Moderators: jmacgreg, michael, jheckman, barbarah, btbell, bdgregg, asmecher
The OJS Technical Reference
and the OJS API Reference
are both available from the OJS Documentation
You can access our public Git Repository here
. Comprehensive Git usage instructions are available on the wiki
You can access our Bugzilla report tracker here
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
I am currently writing new reports as requested by some clients, and find myself doing a lot
of "needle in haystack" kind of searches for stuff in the database.
I just cannot seem to be able to find Article "title" in the database, in any of the article_ tables.
Where is this string stored, which table/field?
- Posts: 39
- Joined: Thu Mar 06, 2008 12:28 am
Since OJS 2.2, we moved multilingual-capable fields into the article_settings table. To get the title of an article:
- Code: Select all
SELECT a.article_id, s.locale AS title_locale, s.setting_name AS article_title FROM articles a, article_settings s WHERE a.article_id = s.article_id AND s.setting_name = 'title goes here';
This was done so that we could support metadata in any combination of languages.
Public Knowledge Project Team
- Posts: 5925
- Joined: Wed Aug 10, 2005 12:56 pm
Return to OJS Development
Who is online
Users browsing this forum: No registered users and 2 guests