Can the submission dashboard not be case sensitive?
The search in the submissions list is not, in my tests, case-sensitive, and as far as I’m aware it never has been. @asmecher is it possible that the
LIKE %...% syntax is case-sensitive based on a sql type/version/configuration?
Also, is it possible for it to search the abstract, in addition to the author/ title/ submission ID?
This would be possible, but I am on the fence as to whether it is a good idea. The search is fairly “dumb”, in that it does not do any ranking by relevance. Restricting the matches to id, title and author ensures the results are always highly relevant. We make the assumption that, when searching in this context, searchers already know the submission they want, and recalling a word or two should bring it up immediately. Including the abstract in matches will increase the rate of false positives. This effect will be inflated on larger journals, but probably be pretty minimal in smaller journals. Without widespread testing (which PKP doesn’t have the resources for) or centralised behavioural tracking (which PKP rightfully avoids), it’s hard to make an informed choice here.
This is an area where our plugin architecture can be useful, but it requires some technical resources. It looks like it is possible for a plugin to modify the search query to include the abstract (though this hasn’t been done in practice yet). As a proof of concept, I’d be willing to try to work up an example plugin which did this. But you’d still need technical support from your service provider to install and enable the plugin. Is that something you have?
Finally, while the filters are super helpful, is there a way to sort by submission date or upcoming review deadline?
Submissions are always sorted by submission date, with the most recently submitted at the top. Adding better filters for tracking missed deadlines is planned. We haven’t yet had a request for filtering by pending deadlines, but perhaps your need would be adequately addressed with some of the other suggested filters: https://github.com/pkp/pkp-lib/issues/2612