View | Details | Raw Unified | Return to bug 23019
Collapse All | Expand All

(-)a/C4/ImportBatch.pm (-3 / +2 lines)
Lines 265-271 sub GetImportBatch { Link Here
265
    my ($batch_id) = @_;
265
    my ($batch_id) = @_;
266
266
267
    my $dbh = C4::Context->dbh;
267
    my $dbh = C4::Context->dbh;
268
    my $sth = $dbh->prepare_cached("SELECT b.*, p.name as profile FROM import_batches b LEFT JOIN import_batches_profile p ON p.id = b.profile_id WHERE import_batch_id = ?");
268
    my $sth = $dbh->prepare_cached("SELECT b.*, p.name as profile FROM import_batches b LEFT JOIN import_batch_profiles p ON p.id = b.profile_id WHERE import_batch_id = ?");
269
    $sth->bind_param(1, $batch_id);
269
    $sth->bind_param(1, $batch_id);
270
    $sth->execute();
270
    $sth->execute();
271
    my $result = $sth->fetchrow_hashref;
271
    my $result = $sth->fetchrow_hashref;
Lines 1024-1030 sub GetImportBatchRangeDesc { Link Here
1024
1024
1025
    my $dbh = C4::Context->dbh;
1025
    my $dbh = C4::Context->dbh;
1026
    my $query = "SELECT b.*, p.name as profile FROM import_batches b
1026
    my $query = "SELECT b.*, p.name as profile FROM import_batches b
1027
                                    LEFT JOIN import_batches_profile p
1027
                                    LEFT JOIN import_batch_profiles p
1028
                                    ON b.profile_id = p.id
1028
                                    ON b.profile_id = p.id
1029
                                    WHERE b.batch_type IN ('batch', 'webservice')
1029
                                    WHERE b.batch_type IN ('batch', 'webservice')
1030
                                    ORDER BY b.import_batch_id DESC";
1030
                                    ORDER BY b.import_batch_id DESC";
1031
- 

Return to bug 23019