From 8fe840ca0e54d999617c5770009e02d83439ff1d Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 25 May 2012 14:00:44 -0400 Subject: [PATCH] Repair tpac QueryParser bookbag/container filter The container() filter SQL now JOINs on m.source instead of mrd.id, since mrd is not yet defined in the query (and m.source == mrd.id). Signed-off-by: Bill Erickson Signed-off-by: Mike Rylander --- .../perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm index a3ea1acd6b..669bf2068a 100644 --- a/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm +++ b/Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Driver/Pg/QueryParser.pm @@ -647,7 +647,7 @@ sub toSQL { $rec_join WHERE c.btype = > . $self->QueryParser->quote_value($ctype) . qq< AND c.id = > . $self->QueryParser->quote_value($cid) . - qq< AND (c.pub IS TRUE $perm_join)) container ON (container.container_item = mrd.id) >; + qq< AND (c.pub IS TRUE $perm_join)) container ON (container.container_item = m.source) >; } else {$container = ''}; } else { $container = ''; -- 2.11.0