What's the SQL query for article's title?

Software Support
1

Hello,

After I take a look at the OJS SQL database, I didn’t seem to found a table that contains articles’ submission title. Any insights? :slight_smile:

I’m recently trying to learn how the OJS works so I might be frequenting here :blush:

Best Regards,

2

Greetings,

the title for specific article can be called in .tpl file:

{$article->getLocalizedTitle()|escape}

3

Hi @shenwilly,

What version of OJS are you asking about?

Regards,
Alec Smecher
Public Knowledge Project Team

4

@asmecher My workplace’s OJS is using version 2.4.3

@Vitaliy Thanks!

Where exactly is the data located in the server, though?

5

Hi @shenwilly,

For OJS 2.4.x, you can get the article title e.g. using:

SELECT setting_value FROM article_settings WHERE setting_name='title' AND locale='en_US' AND article_id=123;

…where en_US is the locale for the title (en_US is U.S. English), and 123 is the article ID.

Regards,
Alec Smecher
Public Knowledge Project Team

6

@asmecher I see! Much appreciated! :slight_smile: