OJS database tables to find articles belonging to a particular issue

Software Support
1

Hi,

I want to extract articles belonging to a specific issue. where can i find them in OJS database.

I am using OJS 3.2.1.2. I want to get a list of articles published in a specific issue and then changing publication date for the articles. I want it to be done through db.

Thanks

2

Hi @sohailkmu

In 3.2.1, publications are assigned to an issue in the publication_settings table, with a setting_name of issueId.

Regards,
Jason

3

Thanks alot for your kind response.

1 Like