From d1cd59d481286fc1dcd5aae5c1d09b41c5f3a729 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bernd=20Ble=C3=9Fmann?= Date: Fri, 22 Apr 2022 15:49:20 +0200 Subject: [PATCH] Volltext-Suche Auftrag: Kosmetik: Formatierung SQL-Statements --- SL/OE.pm | 29 ++++++++++++++++++++++++++--- 1 file changed, 26 insertions(+), 3 deletions(-) diff --git a/SL/OE.pm b/SL/OE.pm index 2a283d2e3..4ce1b1035 100644 --- a/SL/OE.pm +++ b/SL/OE.pm @@ -331,10 +331,33 @@ SQL $query .= ' AND ('; $query .= join ' ILIKE ? OR ', @fulltext_fields; $query .= ' ILIKE ?'; - $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 ?)|; - $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 ?))|; - $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 ?)))|; + + $query .= <{fulltext})) for 1 .. (scalar @fulltext_fields) + 5; } -- 2.20.1