It looks like you're passing the where a reference to an array, dont you want:

my $pager = __PACKAGE__->pager(
   where         => \%where, 
   abstract_attr => {logic => 'and'}
);
[download]