| Lines 161-167
          my %where = (
      
      
        Link Here | 
        
          | 161 |     'itembib.itemlost' => 0, | 161 |     'itembib.itemlost' => 0, | 
        
          | 162 |     'itembib.withdrawn' => 0, | 162 |     'itembib.withdrawn' => 0, | 
        
          | 163 |     'itembib.notforloan' => 0, | 163 |     'itembib.notforloan' => 0, | 
          
            
              | 164 |     'itembib.itemnumber' => { -not_in => \'SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL' } | 164 |     'itembib.itemnumber' => { -not_in => \'SELECT itemnumber FROM branchtransfers WHERE datearrived IS NULL AND datecancelled IS NULL' } | 
        
          | 165 | ); | 165 | ); | 
        
          | 166 |  | 166 |  | 
        
          | 167 | # date boundaries | 167 | # date boundaries | 
  
    | Lines 190-195
          my $holds = Koha::Holds->search(
      
      
        Link Here | 
        
          | 190 |     { %where }, | 190 |     { %where }, | 
        
          | 191 |     { join => 'itembib', distinct  => 1, columns => qw[me.biblionumber] } | 191 |     { join => 'itembib', distinct  => 1, columns => qw[me.biblionumber] } | 
        
          | 192 | ); | 192 | ); | 
            
              |  |  | 193 |  | 
        
          | 193 | my @biblionumbers = $holds->get_column('biblionumber'); | 194 | my @biblionumbers = $holds->get_column('biblionumber'); | 
        
          | 194 |  | 195 |  | 
        
          | 195 | my $all_items; | 196 | my $all_items; | 
            
              | 196 | -  |  |  |