diff options
| author | Elmar Ludwig <elmar.ludwig@uni-osnabrueck.de> | 2023-08-10 12:37:24 +0000 |
|---|---|---|
| committer | Elmar Ludwig <elmar.ludwig@uni-osnabrueck.de> | 2023-08-10 12:37:24 +0000 |
| commit | 5b8d54a68cd98f67462b7f2877ac3463ec84a636 (patch) | |
| tree | f21b49385526544d95b04fc47ae080218c132452 | |
| parent | 7e33043f5145421eb033dd6f95b0914bb2f7dd5d (diff) | |
drop sub-select, re #2870
Merge request studip/studip!2025
| -rw-r--r-- | lib/models/StudipStudyArea.class.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/models/StudipStudyArea.class.php b/lib/models/StudipStudyArea.class.php index 74c50a7..6134fda 100644 --- a/lib/models/StudipStudyArea.class.php +++ b/lib/models/StudipStudyArea.class.php @@ -364,7 +364,7 @@ class StudipStudyArea extends SimpleORMap implements StudipTreeNode public static function search($searchTerm) { return self::findBySql( - "sem_tree_id IN (SELECT sem_tree_id FROM sem_tree WHERE name LIKE :searchTerm ORDER BY priority)", + "name LIKE :searchTerm ORDER BY priority", ['searchTerm' => "%$searchTerm%"] ); } |