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
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.

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
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.

Alec Smecher
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