Revision 45ee0662
Von Bernd Bleßmann vor mehr als 2 Jahren hinzugefügt
| SL/OE.pm | ||
|---|---|---|
| 333 | 333 |
$query .= ' ILIKE ?'; |
| 334 | 334 |
$query .= qq| OR EXISTS (SELECT files.id FROM files LEFT JOIN file_full_texts ON (file_full_texts.file_id = files.id) WHERE files.object_id = o.id AND files.object_type = 'sales_order' AND file_full_texts.full_text ILIKE ?)|; |
| 335 | 335 |
$query .= qq| OR EXISTS (SELECT notes.id FROM notes WHERE notes.trans_id = o.id AND notes.trans_module LIKE 'oe' AND (notes.subject ILIKE ? OR notes.body ILIKE ?))|; |
| 336 |
$query .= qq| OR EXISTS (SELECT follow_up_links.id FROM follow_up_links WHERE follow_up_links.trans_id = o.id AND trans_type = 'sales_order' AND EXISTS (SELECT notes.id FROM notes WHERE trans_module LIKE 'fu' AND trans_id = follow_up_links.follow_up_id AND (notes.subject ILIKE ? OR notes.body ILIKE ?)))|; |
|
| 336 | 337 |
$query .= ')'; |
| 337 |
push(@values, like($form->{fulltext})) for 1 .. (scalar @fulltext_fields) + 3;
|
|
| 338 |
push(@values, like($form->{fulltext})) for 1 .. (scalar @fulltext_fields) + 5;
|
|
| 338 | 339 |
} |
| 339 | 340 |
|
| 340 | 341 |
if ($form->{parts_partnumber}) {
|
Auch abrufbar als: Unified diff
Volltext-Suche Auftrag: auch in Wiedevorlagen suchen