OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



update metadata " abstract "

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.

update metadata " abstract "

Postby cristianviza » Tue Jun 24, 2014 9:24 am

Hello everybody people.
Today I want update using a sql query a " abstract " metadata in particular article. For example article id: 10000, in the journal id=1000, in issue id = 10.
I should used "update" but I fail to assemble the entire query.
Regards Cristian
cristianviza
 
Posts: 75
Joined: Tue Nov 06, 2012 10:22 am
Location: Argentina

Re: update metadata " abstract "

Postby asmecher » Tue Jun 24, 2014 9:50 am

Hi Cristian,

You can use...
Code: Select all
UPDATE article_settings SET setting_value='new abstract here' WHERE article_id=10000 AND setting_name='abstract' AND locale='en_US';
Note that you also need to specify the locale -- e.g. en_US for U.S. English.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8844
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