From 93413b7f002dd5705bb21ff6e8f4ad970b862e75 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Mon, 12 Jul 2010 00:02:49 +0000
Subject: [PATCH] facet query correction

git-svn-id: svn://svn.open-ils.org/ILS/trunk@16906 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm | 9 +++------
 1 file changed, 3 insertions(+), 6 deletions(-)

diff --git a/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm b/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm
index 38b444baf..07a3dbfdf 100644
--- a/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm
+++ b/Open-ILS/src/perlmods/OpenILS/Application/Search/Biblio.pm
@@ -1334,21 +1334,18 @@ sub cache_facets {
 
     # The query we're constructing
     #
-    # select  cmf.id,
+    # select  mfae.field as id,
     #         mfae.value,
     #         count(distinct mmrsm.appropriate-id-field )
     #   from  metabib.facet_entry mfae
-    #         join config.metabib_field cmf on (mfae.field = cmf.id)
     #         join metabib.metarecord_sourc_map mmrsm on (mfae.source = mmrsm.source)
-    #   where cmf.facet_field
-    #         and mmrsm.appropriate-id-field in IDLIST
+    #   where mmrsm.appropriate-id-field in IDLIST
     #   group by 1,2;
 
     my $count_field = $metabib ? 'metarecord' : 'source';
     my $facets = $U->cstorereq( "open-ils.cstore.json_query.atomic",
         {   select  => {
-                cmf  => [ 'id' ],
-                mfae => [ 'value' ],
+                mfae => [ { column => 'field', alias => 'id'}, 'value' ],
                 mmrsm => [{
                     transform => 'count',
                     distinct => 1,
-- 
2.11.0