From 0fd6e4b7e096b1e53763b46656d392b04c802158 Mon Sep 17 00:00:00 2001 From: Mark Wells Date: Thu, 18 Jul 2013 11:32:10 -0700 Subject: [PATCH] sales report: fix report class filtering under Pg 8.x, #24002 --- FS/FS/Report/Table.pm | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/FS/FS/Report/Table.pm b/FS/FS/Report/Table.pm index c5a6503c3..ffd2ac490 100644 --- a/FS/FS/Report/Table.pm +++ b/FS/FS/Report/Table.pm @@ -760,7 +760,9 @@ sub with_report_option { } elsif ( $num eq '0' ) { $comparison = "NOT EXISTS ($subselect)"; } else { - $comparison = "(SELECT COALESCE(string_agg(num, ','), '') FROM ( + #$comparison = "(SELECT COALESCE(string_agg(num, ','), '') FROM ( #Pg 9-ism + $comparison = "(SELECT COALESCE(array_to_string(array_agg(num), ','), '') + FROM ( $subselect ) AS x) = '$num'"; } -- 2.11.0