Redmine

I suppose the best would be an option in Redmine settings to allow or not the querying on locked users.

Jan Niggemann (redmine.org team member) wrote:

Scenario
User leaves company -> profile gets locked
User still has issues assigned, but it's not possible to set a filter "Assignee=UserWhoLeft"

Indeed, at least not using the UI. Using some URL mangling (see #4501, #8160 and #13443) you can still create a query using locked users as assignee.

Working example of formatted URL where user with ID 10 is locked...Working example of formatted URL where user with ID 10 is locked...

http://redmine.host.tld/projects/demoproject/issues?utf8=%E2%9C%93&set_filter=1
                                                   &f%5B%5D=status_id
                                                   &op%5Bstatus_id%5D=o
                                                   &f%5B%5D=assigned_to_id
                                                   &op%5Bassigned_to_id%5D=%3D
                                                   &v%5Bassigned_to_id%5D%5B%5D=10
                                                   &f%5B%5D=
                                                   &c%5B%5D=tracker
                                                   &c%5B%5D=status
                                                   &c%5B%5D=priority
                                                   &c%5B%5D=subject
                                                   &c%5B%5D=assigned_to
                                                   &c%5B%5D=updated_on
                                                   &group_by=

If it is decided that locked users are getting included in possible filter values, I'd strongly prefer to distinct them clearly (using HTML optgroup or so).

I think you should add this feature for more filters like autor, and all the filters with a user.

+1

This would really come in handy.

+1

+1

+1
We are missing locked users in the filters for time entries too. I think this is related to this issue, do you agree?

+1

+1
and agree as well with Henning Kroger regarding time_entries. If someone left from the company half way of a version and we want to display the timelog report for all issues related to the version. The timelog from the locked-user won't appear in the timelog report. The total hours spent for the released version won't be correct.

+1
and same remark regarding spent time on an issue (timelog report) - time logs should still show hours spent by users who are no longer active, since the time was spent (and paid) after all :).

Related to #24568.

Let's try fixing this behavior in 3.4.1 or version:3.5.0.

Marius BALTEANU wrote:

Let's try fixing this behavior in 3.4.1 or version:3.5.0.

I would support integration of this change into 3.5.0 if we also add a distinction between the locked users and the active users using a HTML optgroup.
I know several situations where the amount of locked users if way bigger than the number of active users. In these situations, application of the current proposed patch would make the author and assigned_to filters pretty hard to work with. WDYT?

Totally agree, I'll update the patch in order to group the assignee by status.

Marius BALTEANU wrote:

Mischa, something like that it is good enough?

Looking at the screenshots and after a quick scan of the patch content (with the tests) I'd say: LGTM!

Is there a permission to set, that all users can see the locked users in filters? atm only redmine admins can see them.

Christian Slam wrote:

Is there a permission to set, that all users can see the locked users in filters? atm only redmine admins can see them.

No, you can't see (yet) the locked users in filters regardless your user type or permissions. This feature is proposed for the next major Redmine version.

If you need the feature early, you can try apply the patch on your instance, but you need some technical skills to do that. If you need help, please use forums.

This implementation does not meet its purpose. In 4.1.1 only system administrator can see locked users on the list. Project members are not able to see locker users. This feature should be reopen.

New ticket: #39232.

Since we ran into the same problem, I wrote this script to find tickets owned by locked users, which runs from a cronjob and sends an email to somewhere. I hope this might be useful.

#!/bin/sh

disabled_users=$(echo 'select id from users where status = 3;' | mysql -N redmine)
for du in $disabled_users; do echo "select project_id, id, assigned_to_id from issues where assigned_to_id = $du and ( status_id = 1 or status_id = 2 or status_id = 4 or status_id = 14 or status_id = 28 or status_id = 38 );" | mysql -N redmine; done | \
while read project id user; do
  # First check if the project is still active.
  PS=$(echo "select status from projects where id = $project" | mysql -N redmine)
  if [ "$PS" = 5 ]; then
    continue
  fi
  PN=$(echo "select name from projects where id = $project" | mysql -N redmine)
  user=$(echo "select login from users where id = $user" | mysql -N redmine)
  echo "Ticket $id in project '$PN' is assigned to '$user'" 
done

#  ./opentickets_formeremployees 
Ticket 34352 in project 'Konstruktionslaufzettel (Pegasus)' is assigned to 'm.foobar'
Ticket 34358 in project 'Konstruktionslaufzettel (Pegasus)' is assigned to 'm.foobar'