need local sysadmin page for testing circs and holds

[Rogan Hamby]

In database we can easily test a possible circulation to see what circulation policies it would match against. We should create a local sysadmin page to allow users to do this from the staff client.

[Yamil (ysuarez)]

Does this mean there is a SQL/DB trick to "test a possible circulation to see what circulation policies it would match against"? Could that be pasted here or a link provided to see how that works, as a workaround until this client feature is built?

Thanks in advance.

[Terran McCanna (tmccanna)]

This would be awesome! It'd be incredibly useful to have this for testing holds as well.

[Michele Morgan (mmorgan)]

Agreed this would be awesome! +1 to testing holds as well.

To address Yamil's comment, the following database function can be used to find matching circulation policies:

action.find_circ_matrix_matchpoint("context_ou" integer, "item_object" asset.copy, "user_object" actor.usr, "renewal" boolean)

[Rogan Hamby (rogan-hamby)]

Agreed on holds. And the idea is to (with some prettying up) take the function Michele posted and expose it to staff client users.

[Yamil (ysuarez)]

¡Thank you very much for sharing that Michele!

[Benjamin Kalish (bkalish)]

Frontline staff would benefit from this as well. Patrons often want to know "if I check that out, how long can I have it/how many times can I renew it". The item in question is often an item from another library in the consortium. An easy an obvious way for frontline staff to answer this question would be super desirable!