diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-06-30 14:36:54 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-06-30 14:36:54 -0700 |
| commit | d5c89b967ff6685e3e7ff363a563102f8b7ef420 (patch) | |
| tree | 7e721c28ebcd400487a331946969267b8170e1e0 /FS/FS/cdr | |
| parent | dd671563e488044645ab388468f7b2f82fb15fc4 (diff) | |
use a separate table for freesidestatus for IVR imports, RT#39055
Diffstat (limited to 'FS/FS/cdr')
| -rw-r--r-- | FS/FS/cdr/Import.pm | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/FS/FS/cdr/Import.pm b/FS/FS/cdr/Import.pm index 472e220..e788712 100644 --- a/FS/FS/cdr/Import.pm +++ b/FS/FS/cdr/Import.pm @@ -83,7 +83,7 @@ sub dbi_import { #my @cols = values %{ $args{column_map} }; my $sql = "SELECT * FROM $table "; # join(',', @cols). " FROM $table ". $sql .= 'LEFT JOIN '. $args{status_table}. - ' USING ( '. $args{primary_key}. ' )' + " ON ( $table.$pkey = ". $args{status_table}. ".$pkey )" if $args{status_table}; $sql .= ' WHERE freesidestatus IS NULL '; |