LP#1610246 Classic Circulation View excluding circulations
authorChris Sharp <csharp@georgialibraries.org>
Fri, 5 Aug 2016 13:27:23 +0000 (09:27 -0400)
committerGalen Charlton <gmc@equinoxinitiative.org>
Fri, 19 May 2017 01:56:39 +0000 (21:56 -0400)
commit254e42e1f843a18d71f34a92986502cdcd450e0e
tree72d4612e2b429c4ec64c2e1d772f4cdb1e5292ee
parenta4add9ca465974bc775c5076c8543f96c37f55f5
LP#1610246 Classic Circulation View excluding circulations

The reporter.classic_current_circ view, which is available via
Open-ILS/src/sql/Pg/example.reporter-extension.sql, was excluding
circulations because it was assuming all users have a billing address
This branch corrects that with a LEFT JOIN.

No upgrade script will be included since these views are not assumed
to be installed by all Evergreen instances.  Please re-run the
example.reporter-extension.sql file to apply this change for your
instance.

Signed-off-by: Chris Sharp <csharp@georgialibraries.org>
Signed-off-by: Galen Charlton <gmc@equinoxinitiative.org>
Open-ILS/src/sql/Pg/example.reporter-extension.sql