diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2015-02-03 07:18:45 -0800 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2015-02-03 07:18:45 -0800 |
| commit | aeb90ade381fc3d5477db0334048c2af623fccfe (patch) | |
| tree | d1540f5ccef513d10193c124fa6aeaae743ba107 /FS/bin | |
| parent | 167dbdad01e2c1b62fd9be43cc05212e8c874a02 (diff) | |
| parent | d9edf24e9d3e1fd87a23359a7679ef6d6637c00d (diff) | |
contacts can be shared among customers / "duplicate contact emails", RT#27943
Diffstat (limited to 'FS/bin')
| -rw-r--r-- | FS/bin/freeside-cdrd | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/FS/bin/freeside-cdrd b/FS/bin/freeside-cdrd index 45d58789d..a3c67f919 100644 --- a/FS/bin/freeside-cdrd +++ b/FS/bin/freeside-cdrd @@ -120,10 +120,10 @@ while (1) { sub _shouldrun { my $extra_sql = - ' AND 0 < ( SELECT COUNT(*) FROM cust_pkg - WHERE cust_pkg.pkgpart = part_pkg.pkgpart - AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 ) - ) + ' AND EXISTS ( SELECT 1 FROM cust_pkg + WHERE cust_pkg.pkgpart = part_pkg.pkgpart + AND ( cust_pkg.cancel IS NULL OR cust_pkg.cancel = 0 ) + ) '; my @part_pkg = |