From 58ff4d6ad00a9f776a504a18ba9ce6757847774f Mon Sep 17 00:00:00 2001
From: Moritz Bunkus <m.bunkus@linet-services.de>
Date: Tue, 12 Aug 2008 14:34:39 +0000
Subject: [PATCH] =?utf8?q?COALESCE(0,=20...)=20ist=20immer=200.=20Deswegen?=
 =?utf8?q?=20wurden=20in=20der=20Aufgabenliste=20jeder=20Eintrag=20als=20P?=
 =?utf8?q?reisanfrage=20und=20nicht=20als=20Angebot=20oder=20Preisanfrage?=
 =?utf8?q?=20dargestellt.=20Fix=20f=C3=BCr=20Bug=20844.?=
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

---
 SL/OE.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/SL/OE.pm b/SL/OE.pm
index 5c6cec658..81b9b0ab7 100644
--- a/SL/OE.pm
+++ b/SL/OE.pm
@@ -201,7 +201,7 @@ sub transactions_for_todo_list {
 
   $query       =
     qq|SELECT oe.id, oe.transdate, oe.reqdate, oe.quonumber, oe.transaction_description, oe.amount,
-         CASE WHEN (COALESCE(0, oe.customer_id) = 0) THEN 'vendor' ELSE 'customer' END AS vc,
+         CASE WHEN (COALESCE(oe.customer_id, 0) = 0) THEN 'vendor' ELSE 'customer' END AS vc,
          c.name AS customer,
          v.name AS vendor,
          e.name AS employee
-- 
2.20.1