List of all keywords used in some journal

Software Support
,
1

Hi,

Is possible to get a list of all keywords used in a specific journal?
I tried to write a sql query but I didn’t quite understand the database structure.

Regards,
Tarcisio Pereira

2

Hi @Tarcisio_Pereira,

The Article Report in Tools >Report Generator does return keywords as one of the columns of all the articles in the system.

Kind Regards,
Patricia M.
Public Knowledge Project Intern

3

Hi @pmangahis

In what version?
I’m using 3.1.1.2.
The columns I see are:
Submission ID, Title, Abstract, First Name (Author 1-19), Middle Name (Author 1-19), Last Name (Author 1-19), Country (Author 1-19), Affiliation (Author 1-19), Email (Author 1-19), URL (Author 1-19), Bio Statement (e.g., department and rank) (Author 1-19), Section title, Language, Editor Decision and Status.
The is no keywords.

Regards,
Tarcisio Pereira.

4

Hi @Tarcisio_Pereira,

This is included in ojs-3.1.2 and newer versions.

Kind Regards,
Patricia M.
Public Knowledge Project Intern

1 Like