From 3f4e0e6834a35d8bfca9b1e14fb51306f049e7f5 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Sun, 29 May 2011 20:30:27 -0400 Subject: [PATCH] Switch authority startwith index back to the pre-checking-deletedness version Signed-off-by: Mike Rylander --- Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm | 14 ++++---------- 1 file changed, 4 insertions(+), 10 deletions(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm index ff3d5584e1..1f0a46ae60 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/SuperCat.pm @@ -1660,11 +1660,8 @@ sub authority_tag_sf_startwith { my $before = $_storage->request( "open-ils.cstore.json_query.atomic", { select => { afr => [qw/record value/] }, - from => { 'afr', 'are' }, - where => { - '+afr' => { tag => \@ref_tags, subfield => $subfield, value => { '<' => $value } }, - '+are' => { deleted => 'f' } - }, + from => 'afr', + where => { tag => \@ref_tags, subfield => $subfield, value => { '<' => $value } }, order_by => { afr => { value => 'desc' } }, limit => $ref_limit, offset => $offset, @@ -1677,11 +1674,8 @@ sub authority_tag_sf_startwith { my $after = $_storage->request( "open-ils.cstore.json_query.atomic", { select => { afr => [qw/record value/] }, - from => { 'afr', 'are' }, - where => { - '+afr' => { tag => \@ref_tags, subfield => $subfield, value => { '>=' => $value } }, - '+are' => { deleted => 'f' } - }, + from => 'afr', + where => { tag => \@ref_tags, subfield => $subfield, value => { '>=' => $value } }, order_by => { afr => { value => 'asc' } }, limit => $ref_limit, offset => $offset, -- 2.11.0