[Koha-patches] [PATCH] Bug Fixing : export would export no biblios when
Henri-Damien LAURENT
henridamien.laurent at biblibre.com
Wed Aug 26 01:40:28 CEST 2009
IndependantBranches set and user is kohaadmin
I think we can escape defaulting to the userenv Branch with
restricting the list to the user branch
---
tools/export.pl | 5 +++--
1 files changed, 3 insertions(+), 2 deletions(-)
diff --git a/tools/export.pl b/tools/export.pl
index f60fcd6..66d1acc 100755
--- a/tools/export.pl
+++ b/tools/export.pl
@@ -80,8 +80,8 @@ if ($op eq "export") {
($itemtype && C4::Context->preference('item-level_itypes'));
my $query = $items_filter ?
"SELECT DISTINCT biblioitems.biblionumber
- FROM biblioitems,items
- WHERE biblioitems.biblionumber=items.biblionumber "
+ FROM biblioitems JOIN items
+ USING (biblionumber) WHERE 1"
:
"SELECT biblioitems.biblionumber FROM biblioitems WHERE biblionumber >0 ";
@@ -123,6 +123,7 @@ if ($op eq "export") {
$query .= (C4::Context->preference('item-level_itypes')) ? " AND items.itype = ? " : " AND biblioitems.itemtype = ?";
push @sql_params, $itemtype;
}
+ warn "$query, @sql_params";
my $sth = $dbh->prepare($query);
$sth->execute(@sql_params);
--
1.6.0.4
More information about the Koha-patches
mailing list