https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=42503
--- Comment #50 from Tomás Cohen Arazi (tcohen) <[email protected]> --- Created attachment 200555 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=200555&action=edit Bug 42503: Populate materialized descriptions during queue build The tmp_holdsqueue table already materializes patron (surname, firstname, phone, cardnumber) and biblio (title) fields to avoid joins at read time. This extends the pattern to item type, collection code, and shelving location descriptions. C4::HoldsQueue::AddToHoldsQueue now resolves and stores: - itype_description: from effective item type (Koha::ItemType->description) - ccode_description: from authorised values (CCODE category) - location_description: from authorised values (LOC category) This enables server-side sorting by human-readable descriptions rather than internal codes. Test plan: $ ktd --shell k$ prove t/db_dependent/HoldsQueue/materialized_descriptions.t => SUCCESS: All tests pass Signed-off-by: David Nind <[email protected]> -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
