projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 11a2542) | patch
Fixing LP 1072892 - repeated rows in reporter.classic_item_list view
authorChris Sharp <csharp@georgialibraries.org>
Wed, 31 Jul 2013 15:03:25 +0000 (11:03 -0400)
committerBen Shum <bshum@biblio.org>
Wed, 14 Aug 2013 02:06:48 +0000 (22:06 -0400)
commit4268902b83c65b37c9f525b012dfba3940e8e619
treee3bf41e2aed69ac5dffe74834658f3be6294425dtree
parent11a2542c75dc04f5a86e4206b182b927d4f845aacommit | diff
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 <csharp@georgialibraries.org>
Signed-off-by: Ben Shum <bshum@biblio.org>
Open-ILS/src/sql/Pg/example.reporter-extension.sql diff | blob | history
Evergreen working repo (Equinox)