Revision 7e47ffd0
Von Bernd Bleßmann vor fast 12 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 115 | 115 |
|
| 116 | 116 |
if ($form->{"projectnumber"}) {
|
| 117 | 117 |
$query .= <<SQL; |
| 118 |
AND (pr.projectnumber ILIKE ?) OR EXISTS ( |
|
| 118 |
AND ((pr.projectnumber ILIKE ?) OR EXISTS (
|
|
| 119 | 119 |
SELECT * FROM orderitems oi |
| 120 | 120 |
LEFT JOIN project proi ON proi.id = oi.project_id |
| 121 | 121 |
WHERE proi.projectnumber ILIKE ? AND oi.trans_id = o.id |
| 122 |
) |
|
| 122 |
))
|
|
| 123 | 123 |
SQL |
| 124 | 124 |
push @values, "%" . $form->{"projectnumber"} . "%", "%" . $form->{"projectnumber"} . "%" ;
|
| 125 | 125 |
} |
Auch abrufbar als: Unified diff
Klammer um OR bei Filtern nach Projektnummer.
Fixt #2092