diff options
| -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'"; } |