Although bug39011 have solved a lot of things regarding searching the items table on authorised_values, it was missing the items.location mapping. As far as I can tell there are no other missing coded_values.
Created attachment 187076 [details] [review] Bug 40904: Fix item search by shelving location on catalogue/details.pl Test plan : - before patch on ktd, go to http://localhost:8081/cgi-bin/koha/catalogue/detail.pl?biblionumber=155 - in the holdings table search for "general" like "General Stacks". - see that no items appear - apply patch - repeat the search - all items appear now.
Created attachment 187095 [details] [review] Bug 40904: Fix item search by shelving location on catalogue/details.pl Test plan : - before patch on ktd, go to http://localhost:8081/cgi-bin/koha/catalogue/detail.pl?biblionumber=155 - in the holdings table search for "general" like "General Stacks". - see that no items appear - apply patch - repeat the search - all items appear now. Signed-off-by: Mathieu <mathsabypro@gmail.com>
BZ 39011 was categorized as a bug fix and not an enhancement. I think the same should apply to this ticket. I tested it on a sandbox, it works, you can search for "general stacks" or "general." "Stacks" doesn't return any results, which may seem surprising, but that's how the filter already works for libraries and statuses following 39011, so that makes sense... But is this the desired behavior for this table or something that should be improved in subsequent bugs?
By the way I discovered an other issue while testing : https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40907