]> git.evergreen-ils.org Git - Evergreen.git/commit
projects / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 52a63bf) | 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:53 +0000 (22:06 -0400)
commit6e5bee24ee72f1c2fd5345d1b5d306507f3fd5ae
tree7f344b879ed05f096d052282e0c6d2e6cc4148eetree
parent52a63bf1066109a6b151dda399416d31285cff64commit | 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 ILS