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?
I’m recently trying to learn how the OJS works so I might be frequenting here
Best Regards,
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?
I’m recently trying to learn how the OJS works so I might be frequenting here
Best Regards,
Greetings,
the title for specific article can be called in .tpl file:
{$article->getLocalizedTitle()|escape}
Hi @shenwilly,
What version of OJS are you asking about?
Regards,
Alec Smecher
Public Knowledge Project Team
@asmecher My workplace’s OJS is using version 2.4.3
@Vitaliy Thanks!
Where exactly is the data located in the server, though?
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
@asmecher I see! Much appreciated!