projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 0b75bd5) | patch
JBAS-1306 Lost/paid summary view SQL repair
authorBill Erickson <berickxx@gmail.com>
Tue, 16 Oct 2018 15:21:35 +0000 (11:21 -0400)
committerBill Erickson <berickxx@gmail.com>
Thu, 21 Mar 2019 19:46:23 +0000 (15:46 -0400)
commit2c4de06de467bd17780ef251d4639af1765c507b
treebd106d6cccf58f1366f02a9aa290866c223cb7cdtree
parent0b75bd594deaf1218d9f3a9d42934cc3b07de547commit | diff
JBAS-1306 Lost/paid summary view SQL repair

Avoid use of all_ciculation_slim and all_payments view for active
lookups.  These slow the queries down considerably for the normal use
case of staff accepting payments and printing recteipts.

If the B.O. needs access to payments for anon circs / money down the
road we may can create a separate query.

Signed-off-by: Bill Erickson <berickxx@gmail.com>
KCLS/sql/schema/deploy/lost-paid-receipts.sql diff | blob | history
Evergreen ILS