OJS development discussion, enhancement requests, third-party patches and plug-ins.
Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher
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.
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: 10015
- 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