Bug 21269 - add unique id to issuingrules, include that id in issues table
Summary: add unique id to issuingrules, include that id in issues table
Status: CLOSED WONTFIX
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-08-24 15:33 UTC by Andrew Fuerste-Henry
Modified: 2020-11-30 21:45 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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