You would need to know issue id and publication id.
Probably, the easiest way to identify it is with the browser’s developer tools.
If Google Chrome, right mouse click on the issue in the list - in the dropdown menu choose inspect. There would be an HTML code of the element:
<a href="http://ojs-3.2.1.test/index.php/psp/$$$call$$$/grid/issues/back-issue-grid/edit-issue?issueId=12" id="cell-12-identification-edit-button-5f630cd3ab462" title="Edit" class="pkp_controllers_linkAction pkp_linkaction_edit pkp_linkaction_icon_">Vol. 4 No. 3 (2019): Test Title for the Issue </a>
Inside the link the query part (
?issueId=12) points the internal issue id.
The same for the publication - on the publication page, the
aria label attribute of the
tablist div (menu of the publication with tabs on the left), contains the id of the publication that you can see with dev tools:
<div role="tablist" aria-label="Publication details for version 174" class="pkpTabs__buttons">
Another way can be finding all that by a submission id, which appears in the URL, e.g.:
208 here is the submission id.
To find current publication id run this query in the database:
SELECT current_publication_id FROM submissions WHERE submission_id = '208'
In my case, it returns
Then, using this id, find issue id:
SELECT setting_value FROM publication_settings WHERE publication_id = '174' AND setting_name = 'issueId'
issues table look at the
published column status of the issue:
SELECT published FROM issues WHERE issue_id = '12'
publications table look for the
status column of the publication:
SELECT status FROM publications WHERE publication_id = '174'