@@ -, +, @@ inventory results - Check you have in default framework an item subfield mapped with items.withdrawn - Create a biblio with default framework - Create an item with barcode='000AAA1', callnumber='ZZZAAA1' and withdrawn=0 - Create an item with barcode='000AAA2', callnumber='ZZZAAA2' and withdrawn=1 - Go to inventory tool : /cgi-bin/koha/tools/inventory.pl - Enter item callnumber between 'ZZZ' and 'ZZZZ' - Submit - Go to inventory tool : /cgi-bin/koha/tools/inventory.pl - Enter item callnumber between 'ZZZ' and 'ZZZZ' - Check 'Export to CSV file' - Submit - Open exported file --- C4/Items.pm | 2 +- koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt | 4 ++++ tools/inventory.pl | 4 ++-- 3 files changed, 7 insertions(+), 3 deletions(-) --- a/C4/Items.pm +++ a/C4/Items.pm @@ -1034,7 +1034,7 @@ sub GetItemsForInventory { my ( @bind_params, @where_strings ); my $select_columns = q{ - SELECT items.itemnumber, barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, stocknumber + SELECT items.itemnumber, barcode, itemcallnumber, title, author, biblio.biblionumber, biblio.frameworkcode, datelastseen, homebranch, location, notforloan, damaged, itemlost, withdrawn, stocknumber }; my $select_count = q{SELECT COUNT(*)}; my $query = q{ --- a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt +++ a/koha-tmpl/intranet-tmpl/prog/en/modules/tools/inventory.tt @@ -246,6 +246,7 @@ $(document).ready(function(){