OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Article Title in Database

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

Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, 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.

Article Title in Database

Postby marlonvanderlinde » Tue Sep 23, 2008 3:50 am

Hi

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?

Kind regards
Marlon
marlonvanderlinde
 
Posts: 39
Joined: Thu Mar 06, 2008 12:28 am

Re: Article Title in Database

Postby asmecher » Tue Sep 23, 2008 8:36 am

Hi Marlon,

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.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 9063
Joined: Wed Aug 10, 2005 12:56 pm


Return to OJS Development

Who is online

Users browsing this forum: No registered users and 1 guest