diff options
| author | Thomas Hackl <hackl@data-quest.de> | 2025-10-02 09:07:54 +0200 |
|---|---|---|
| committer | Thomas Hackl <hackl@data-quest.de> | 2025-10-02 09:07:54 +0200 |
| commit | 11ca5b13005a3338515aa49381e41fa5ef56f3a1 (patch) | |
| tree | 3363d11865823db492e814d083eb54e0aa359438 /lib | |
| parent | 0774229127611af4074d1d13fb3b72e1fff4264c (diff) | |
Resolve "JSON-API liefert zu viele Daten bei der Veranstaltungssuche"
Closes #5914
Merge request studip/studip!4510
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/classes/StudipSemSearchHelper.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/classes/StudipSemSearchHelper.php b/lib/classes/StudipSemSearchHelper.php index 754b650..5c7581c 100644 --- a/lib/classes/StudipSemSearchHelper.php +++ b/lib/classes/StudipSemSearchHelper.php @@ -206,10 +206,10 @@ class StudipSemSearchHelper { $join_sql[] = "JOIN `seminar_user` USING (`seminar_id`)"; $join_sql[] = "JOIN `auth_user_md5` USING (`user_id`)"; - $conditions[] = "( + $conditions[] = "(( CONCAT(`auth_user_md5`.`Nachname`, ', ', `auth_user_md5`.`Vorname`, ' ', `auth_user_md5`.`Nachname`) LIKE CONCAT('%', :lecturer_name, '%') OR `auth_user_md5`.`username` LIKE CONCAT('%', :lecturer_name, '%') - )"; + ) AND `seminar_user`.`status` = 'dozent')"; $sql_params['lecturer_name'] = $this->params['lecturer']; } |