diff options
| author | Ivan Kohler <ivan@freeside.biz> | 2014-06-30 14:36:55 -0700 |
|---|---|---|
| committer | Ivan Kohler <ivan@freeside.biz> | 2014-06-30 14:36:55 -0700 |
| commit | 21ae7910a5ed55314b4507023c383d74bc2860bd (patch) | |
| tree | e4b8121d03779589eb7aa122870bae3b9699f109 | |
| parent | 7fbe3ae31ecee80d14c510e779ca9b2618ba2dff (diff) | |
use a separate table for freesidestatus for IVR imports, RT#39055
| -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 472e22062..e788712c4 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 '; |