From bcb54d4fe255135f00726fbb9c923d3a38d1e76f Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Wed, 31 Jul 2013 11:03:25 -0400 Subject: [PATCH] Fixing LP 1072892 - repeated rows in reporter.classic_item_list view The view joined the actor.card table in such a way that all library cards (active or not) were being returned. This commit changes that behavior so that only the current card (from actor.usr.card) is returned. Signed-off-by: Chris Sharp Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/example.reporter-extension.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/example.reporter-extension.sql b/Open-ILS/src/sql/Pg/example.reporter-extension.sql index 2bffcef310..6ab5f40ae1 100644 --- a/Open-ILS/src/sql/Pg/example.reporter-extension.sql +++ b/Open-ILS/src/sql/Pg/example.reporter-extension.sql @@ -235,7 +235,7 @@ SELECT t.value as title, LEFT JOIN metabib.full_rec p ON (cn.record = p.record AND p.tag = '260' and p.subfield = 'c') LEFT JOIN action.circulation circ ON (circ.target_copy = cp .id AND circ.checkin_time IS NULL) LEFT JOIN actor.usr circ_u ON (circ_u.id = circ.usr) - LEFT JOIN actor.card circ_card ON (circ_u.id = circ_card.usr) + LEFT JOIN actor.card circ_card ON (circ_u.card = circ_card.id) LEFT JOIN asset.stat_cat_entry_copy_map sc1 ON (sc1.owning_copy = cp.id AND sc1.stat_cat = 1) LEFT JOIN asset.stat_cat_entry sce1 ON (sce1.id = sc1.stat_cat_entry) LEFT JOIN asset.stat_cat_entry_copy_map sc2 ON (sc2.owning_copy = cp.id AND sc2.stat_cat = 2) -- 2.43.2