Expose more fields via circ_loan_rule table
In Sierra 5.5 the circloanrule view was added to SierraDNA, providing SQL access to an abridged form of the loan rule table. A few of the fields missing from this view are particularly notable and their addition would greatly expand on the opportunities to utilize this view in queries:nameis_bookablemax number of auto renewalsamount of fine
Idea Value
SQL access to this fields would enable the construction of more detailed loan rule based queries. In particular being able to look at fine rates and their impact on checkouts would be of great value.
Jeremy Goldstein
shared this idea
-
Jennifer Moakler
commented
My ideal would be to have every field in the loan rule table accessible via SQL. I maintain a workbook to summarize the configuration of our loan rules + loan rule determiners for non-ILS staff (and to check my own work when making changes), and I currently have to do a lot of fussing with both SQL and VLOOKUPs to pull in all the data I need. It would be fantastic to be able to write a single SQL query to get all the information I'm looking for.
-
Joshua Klingbeil
commented
I would classify this more as "missing critical functionality" than a feature or improvement suggestion.
-
Phil Shirley
commented
Just now I got a question from the boss "which things are set to auto-renew" and I have to look at each loan rule using the SDA. If this field were in a SQL table then the answer would be so easy. Glad I don't have as many loan rules as some places do.