I can't delete section - how to find article which block section?

Hi,
when i trying delete section i see:
“Before this section can be deleted, you must move articles published within it into other sections.” i Read in other case: “If you want to keep published articles in that section, it cannot be deleted.”
How i can find article or papers in the archive (rejected papers)?Thanks,

Karol

Hi @karol,

What version of OJS are you using?

Thanks,
Amanda Stevens
Public Knowledge Project Team

Hi Amanda,

I using 2.4.8-3. Regards,

Karol

Try: User Home → Editor → Archives → filter to “In Section”.

Clinton,

Thank You, i checked this, but in section to delete i see “No Submissions” in:

  • UNASSIGNED
  • IN REVIEW
  • IN EDITING
  • ARCHIVES

but still when i trying delete section, i can’t do this. Any other idea? Maybe direct in database? Or Maybe when i upgrade to Ojs 3.X then problem could be resolve? Thanks,

Karol

To query the database directly, find the section_id from the sections table:

select journal_id, section_id, setting_value from sections join section_settings using (section_id) where setting_name = 'title';

Then use that section_id to find matching articles:

select article_id from articles where section_id = ?

The article_id is the “Submission ID” to query/filter in the editorial interface.

1 Like

Clinton,

it was very helpfully. Thank You,

Karol