Hi,
When submitting an article, OJS has stage 3. “Enter Metadata”. I would like to query the database to find and list each metadata name and metadata value of a given submission based on submission_id or production_id. Any SQL query statement to achieve this?
Metadata_Name | Metadata_Value |
---|---|
Title | Value here |
Subtitle | Value here |
Abstract | Value here |
List of contributors | Value here |
Languages | Value here |
Supporting Agencies | Value here |
References | Value here |
We are using OJS OJS 3.3.0-13. Thanks in advance.
Obi