About the sorting, take a look at the official redmine issue tracker,
with the Filters directly below the navigation:
http://www.redmine.org/projects/redmine/issues
You can kinda what you could do with basic sql, what to show, what not
and how to group. You can also save those queries in different ways:
public for everyone, just for me.. (see the Custom queries in the right
sidebar)
It also allows further customization in terms of what the table should
show. Would you like to see the assignee, the project or is there a
custom field you would like to get a hold in directly (like the
resolution in this case).
You can also select multiple issues from the list and with a right click
quickly assign those or use any of the other many features
https://i.imgur.com/Z3VgEtq.png
So if you have tons of issue with man laying around for months/years, I
bet redmine comes in handy with keeping the amount of issues clear.
I for one find it rather difficult to work with tags once you exceed the
30th open ticket/issue.
Regarding App, well there are a few for redmine but non of them work
perfect, especially not with many custom fields and custom requirements.
E.g. I have a field that only shows up and is only a requirement once
the status of the ticket is set to closed, the apps can't deal with that
although it is a basic redmine feature.
Which brings us to another nice feature. Redmine allows you to define
workflows. So you can define what a group can do. E.g. the reporter can
only set the status to new, can only use tracker x and can only use the
priority "undefined". Then you have a project manager that is able to
sort the issue in if all required information is included, give it a
proper priority, adjust the tracker, set the expected time requirement,
assign the responsible department/group/person, include more
information, rewrite the description to be more clear and short and set
the status to filed.. I hope that gives you an idea of the main/most
powerful features.
Overall we can say that those are mainly useful if you have a high
amount of issues/tickets, if you have a lot of co-workers, if you have a
strict hierarchy or want it to be super tidy. I would also prefer it
above clockingIT with public issue reports, because I can keep them out
of the filters until they are useful and clear.
The reasons I'm thinking about using jobsworth for a new project is that
I don't have a big need for most of those highly powerful tools redmine
offers.