diff options
| author | Mark Wells <mark@freeside.biz> | 2013-07-18 11:31:58 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-07-18 11:31:58 -0700 |
| commit | 856fe5e70c55f191f29db24c7ca8ae6f952de736 (patch) | |
| tree | 5170b2fc72e8b8aa297dcdb2562a7f2e3f77805b /FS | |
| parent | 8633817a4dd2dc892e6ce4367c886501224f07b2 (diff) | |
sales report: fix report class filtering under Pg 8.x, #24002
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/Report/Table.pm | 4 |
1 files changed, 3 insertions, 1 deletions
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'"; } |