Beschreibung,Kommentare und Anhänge
| merge request id | 274 |
| Titel | fixed sorting for clients, organization units and roles |
| Beschreibung | LL-614 User-Liste: Filter Rolle und Sortieurng Rolle gehen nicht zusammen UserListe nach Rolle filtern und dann nach Rolle sortieren. Die Liste zeigt wieder alle User und alle Rollen an. Das eigentliche Problem ist die Methode UserRepository::orderByRelation, die macht Mist, wenn nach "Rollen", Mandanten, oder Organusationseinheiten sortiert wird |
| Status | merged |
| Created at | 2020-10-02T12:17:21.826Z |
| Updated at | 2020-10-07T09:40:41.588Z |
| Source branch | feature/LL-614-fix-role-filtering-in-admin-user-list |
| Target branch | develop |
| Author | Gregor Gabriel |
| Assignee | Sascha Immig |
| bekomme eine Fehlermeldung als Client (lokal): ``` SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'client_id' in where clause is ambiguous (SQL: select count(*) as aggregate from `users` left join `model_has_roles` on `users`.`id` = `model_has_roles`.`model_id` left join `roles` on `model_has_roles`.`role_id` = `roles`.`id` where `client_id` = 2 and `users`.`deleted_at` is null and `users`.`client_id` = 2) ``` | Sascha Immig | 2020-10-05T09:17:17.716Z |
added 1 commit
|
Gregor Gabriel | 2020-10-05T10:16:11.139Z |
| habe ich korrigiert | Gregor Gabriel | 2020-10-05T10:19:12.503Z |
| Bekomme in Filter und Liste Dopplungen | Sascha Immig | 2020-10-05T13:47:52.208Z |
added 1 commit
|
Gregor Gabriel | 2020-10-06T14:10:32.493Z |
| mentioned in commit 298354c2822f65fe725f279cb633b018a162c006 | Sascha Immig | 2020-10-07T09:40:39.982Z |
| merged | Sascha Immig | 2020-10-07T09:40:41.657Z |
| Title | Id | Author | Created at | Message |
| fixed ambiguous column in query building process | 5e06de37d455cc868930a0f86efebb45c6a7d819 | TUV\gabrielg | 2020-10-05T10:16:06.000Z | fixed ambiguous column in query building process |
| + fixed none distinct data sets | 69497dd3a6e554c1027b45b5ca6d9739903f919e | TUV\gabrielg | 2020-10-06T14:10:18.000Z | + fixed none distinct data sets + sorted insuperadmin role to other roles |
| fixed sorting for clients, organization units and roles | f8c5c3ffe1049d8ab6c88aa1da3cb98035645e9c | TUV\gabrielg | 2020-10-02T12:15:39.000Z | fixed sorting for clients, organization units and roles |