OJS development discussion, enhancement requests, third-party patches and plug-ins.
Moderators: jmacgreg, btbell, michael, bdgregg, barbarah, asmecher
The OJS Technical Reference
and the OJS API Reference
are both available from the OJS Documentation
You can access our public Git Repository here
. Comprehensive Git usage instructions are available on the wiki
You can access our Bugzilla report tracker here
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
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.
- Posts: 74
- Joined: Tue Nov 06, 2012 10:22 am
- Location: Argentina
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.
Public Knowledge Project Team
- Posts: 8599
- Joined: Wed Aug 10, 2005 12:56 pm
Return to OJS Development
Who is online
Users browsing this forum: Exabot [Bot] and 2 guests