Although this feels it could be a feature (and it has been requested here \#3579) when using the Move function it is possible to select a group as Responsible.

- Select a work package
- In “More Functions” select “Move”
- In “Change Properties” select the “Responsible” drop down menu
- BUG: You can see groups.


This breaks Work Package views in two ways when displaying work packages with Responsible set as groups:
\- nothing is displayed in “Responsible” column
\- clicking on “Sort” on the “Responsible” column triggers an internal error (see log below)

It is also possible to select a group to filter the “Responsible” field in a Query which actually works (i.e. The view correctly fiters with the correct group if it has been assigned through the Move function as described above.


Of course, I’d rather see \#3579 completed rather than groups being removed from the move function or query filters\!\!\!

### Log
*when clicking on Sort Responsible column when Responsible is a group*

``ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'responsible.lastname' in 'order clause': SELECT `work_packages`.`id` AS t0_r0, `work_packages`.`type_id` AS t0_r1, `work_packages`.`project_id` AS t0_r2, `work_packages`.`subject` AS t0_r3, `work_packages`.`description` AS t0_r4, `work_packages`.`due_date` AS t0_r5, `work_packages`.`category_id` AS t0_r6, `work_packages`.`status_id` AS t0_r7, `work_packages`.`assigned_to_id` AS t0_r8, `work_packages`.`priority_id` AS t0_r9, `work_packages`.`fixed_version_id` AS t0_r10, `work_packages`.`author_id` AS t0_r11, `work_packages`.`lock_version` AS t0_r12, `work_packages`.`done_ratio` AS t0_r13, `work_packages`.`estimated_hours` AS t0_r14, `work_packages`.`created_at` AS t0_r15, `work_packages`.`updated_at` AS t0_r16, `work_packages`.`start_date` AS t0_r17, `work_packages`.`parent_id` AS t0_r18, `work_packages`.`responsible_id` AS t0_r19, `work_packages`.`root_id` AS t0_r20, `work_packages`.`lft` AS t0_r21, `work_packages`.`rgt` AS t0_r22, `statuses`.`id` AS t1_r0, `statuses`.`name` AS t1_r1, `statuses`.`is_closed` AS t1_r2, `statuses`.`is_default` AS t1_r3, `statuses`.`position` AS t1_r4, `statuses`.`default_done_ratio` AS t1_r5, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11, `projects`.`summary` AS t2_r12, `projects`.`project_type_id` AS t2_r13, `projects`.`responsible_id` AS t2_r14, `projects`.`work_packages_responsible_id` AS t2_r15, `users`.`id` AS t3_r0, `users`.`login` AS t3_r1, `users`.`firstname` AS t3_r2, `users`.`lastname` AS t3_r3, `users`.`mail` AS t3_r4, `users`.`admin` AS t3_r5, `users`.`status` AS t3_r6, `users`.`last_login_on` AS t3_r7, `users`.`language` AS t3_r8, `users`.`auth_source_id` AS t3_r9, `users`.`created_on` AS t3_r10, `users`.`updated_on` AS t3_r11, `users`.`type` AS t3_r12, `users`.`identity_url` AS t3_r13, `users`.`mail_notification` AS t3_r14, `users`.`first_login` AS t3_r15, `users`.`force_password_change` AS t3_r16, `users`.`failed_login_count` AS t3_r17, `users`.`last_failed_login_on` AS t3_r18, `types`.`id` AS t4_r0, `types`.`name` AS t4_r1, `types`.`position` AS t4_r2, `types`.`is_in_roadmap` AS t4_r3, `types`.`in_aggregation` AS t4_r4, `types`.`is_milestone` AS t4_r5, `types`.`is_default` AS t4_r6, `types`.`color_id` AS t4_r7, `types`.`created_at` AS t4_r8, `types`.`updated_at` AS t4_r9, `types`.`is_standard` AS t4_r10, `enumerations`.`id` AS t5_r0, `enumerations`.`name` AS t5_r1, `enumerations`.`position` AS t5_r2, `enumerations`.`is_default` AS t5_r3, `enumerations`.`type` AS t5_r4, `enumerations`.`active` AS t5_r5, `enumerations`.`project_id` AS t5_r6, `enumerations`.`parent_id` AS t5_r7, `categories`.`id` AS t6_r0, `categories`.`project_id` AS t6_r1, `categories`.`name` AS t6_r2, `categories`.`assigned_to_id` AS t6_r3, `versions`.`id` AS t7_r0, `versions`.`project_id` AS t7_r1, `versions`.`name` AS t7_r2, `versions`.`description` AS t7_r3, `versions`.`effective_date` AS t7_r4, `versions`.`created_on` AS t7_r5, `versions`.`updated_on` AS t7_r6, `versions`.`wiki_page_title` AS t7_r7, `versions`.`status` AS t7_r8, `versions`.`sharing` AS t7_r9, `versions`.`start_date` AS t7_r10 FROM `work_packages` LEFT OUTER JOIN `statuses` ON `statuses`.`id` = `work_packages`.`status_id` LEFT OUTER JOIN `projects` ON `projects`.`id` = `work_packages`.`project_id` LEFT OUTER JOIN `users` ON `users`.`id` = `work_packages`.`assigned_to_id` LEFT OUTER JOIN `types` ON `types`.`id` = `work_packages`.`type_id` LEFT OUTER JOIN `enumerations` ON `enumerations`.`id` = `work_packages`.`priority_id` AND `enumerations`.`type` IN ('IssuePriority') LEFT OUTER JOIN `categories` ON `categories`.`id` = `work_packages`.`category_id` LEFT OUTER JOIN `versions` ON `versions`.`id` = `work_packages`.`fixed_version_id` WHERE (((statuses.is_closed=0) AND (work_packages.responsible_id IN ('41')) AND projects.id = 12 AND projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking'))) ORDER BY responsible.lastname, responsible.firstname, responsible.id, work_packages.root_id DESC, work_packages.lft ASC LIMIT 100 OFFSET 0):
app/controllers/work_packages_controller.rb:218:in `index'`` Begin of the deletion
End of the deletion