Bug 21269

Summary: add unique id to issuingrules, include that id in issues table
Product: Koha Reporter: Andrew Fuerste-Henry <andrewfh>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: CLOSED WONTFIX QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: cbrannon, katrin.fischer
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Andrew Fuerste-Henry 2018-08-24 15:33:31 UTC
Perhaps an overly-large ask, but would be a huge boon for troubleshooting circulation behavior. If issuingrules contained a column for issuingrule_id, that value could be included in the issues table, allowing easy identification of which issuing rule applied to a given checkout.
Comment 1 Christopher Brannon 2019-09-18 15:15:05 UTC
+1

There have been SO many times I’ve wondered what rule was used. Good idea.
Comment 2 Katrin Fischer 2019-09-21 20:13:24 UTC
I am not sure about including it in the issues table tbh. The behaviour can change whenever you add/change your rules or the item, when an item is transferred, a pick-up location changed etc. - So I am not sure it would be useful information.
Comment 3 Christopher Brannon 2019-09-21 22:13:07 UTC
Maybe include an 'i' icon or hover over the item to have a tip show this information?
Comment 4 Katrin Fischer 2019-09-22 09:35:24 UTC
I think looking up the rules on demand could work better (just would not include it in the db column, as it might change and keeping it current might turn hard).

That said, not sure how long we will be using issuingrules with the changes to circulation anymore. It might complicate things a little.
Comment 5 Katrin Fischer 2020-04-05 11:02:13 UTC
Closing as we on longer have the issuingrules table