]> git.evergreen-ils.org Git - working/Evergreen.git/commit
Purge Circulations: Better selection logic
authorThomas Berezansky <tsbere@mvlc.org>
Mon, 18 Jun 2012 17:07:56 +0000 (13:07 -0400)
committerDan Wells <dbw2@calvin.edu>
Fri, 7 Jun 2013 19:49:45 +0000 (15:49 -0400)
commit8f324450421997cb5619d7ba00e38d423ad466d8
tree23b641cd8ffe72cda86a9e1960268cbc9da51038
parent9b352b2b69fdbdabf24b07ec7f4d8d474330e205
Purge Circulations: Better selection logic

This attempts two things:

1 - Keep the number of circs the library wants based on the most recent
    circulations, regardless of user prefs and such.

    This is accomplished by changing the circ fetching query to use a
    window function in a subquery so we can filter on it easily.

    This also allowed removal of the purge position counter.

2 - Allow removal of circs that are between kept circs if they meet all
    other removal criteria.

    This is accomplished by using CONTINUE instead of EXIT in the loop.

Signed-off-by: Thomas Berezansky <tsbere@mvlc.org>
Signed-off-by: Jason Stephenson <jstephenson@mvlc.org>
Open-ILS/src/sql/Pg/090.schema.action.sql