Hello Kyle M Hall

Claimed QA 29

Signed off 1

• 35100 - Items assigned to StockRotation do not advance if a reserve is triggered before the initial transfer

Failed QA 6

• 17703 - Always export ISSN in serials claims issues CSV
• 23260 - Anonymize (remove) patron data from items_last_borrower
• 32731 - Option for cataloguing tools to also be shown in tools home
• 18138 - Use MARC modification template when adding/updating bibliographic records
• 35131 - Add scan-able barcode to the patron sidebar (patroninfo)
• 27510 - Download the report in HTML format

Passed QA 11

• 36217 - Jobs page include last hour filter does not work
• 9596 - Allow longoverdue.pl to be configured per library on the command line
• 36758 - We should notify an assignee when they are assigned a ticket
• 35145 - Add ability to order patron attributes
• 36169 - Add guarantee to patron categories with type='Staff'
• 36039 - Output of database_audit.pl should be accessible through UI
• 36770 - Add a reportID parameter to export_records.pl
• 36132 - Allow users to delete multiple patron_lists at once on any page
• 36515 - Amend MARC modification templates so control fields can be copied to subfields
• 36027 - search_for_data_inconsistencies.pl - make each section optional
• 35978 - Extend breadcrumbs Course reserves with sections 🎓

New 1

• 16820 - Add possibility to edit fines

In discussion 6

• 28491 - Field 003 in authority records not updated after import
• 10112 - add test for ./debian/control file
• 32502 - Getting patrons/{patron_id} via REST API requires edit_borrowers permission
• 32306 - Hold modifications don't log correctly
• 24288 - Add wording to authorized value interface to indicate valid code length 🎓
• 19787 - Adding system preferences to configure the screen messages for SIP checkout flags in Self-Checkout

Patch doesn't apply 4

• 29959 - Populate prices when creating an order with the API
• 32092 - Improve circulation rules cache utilization
• 25711 - Move ExpireReservesMaxPickUpDelayCharge to the circulation rules
• 23450 - Display issue and subscription price for each issue in subscription tab of /catalogue/detail.pl

CC Bugs 345

Needs documenting 16

• 29354 - Make overdue_notices.pl send HTML attachment as .html
• 35197 + Expose additional_field definitions through REST API
• 33568 + Use the REST API to display items on the biblio detail view
• 34943 + Add a pre-save plugin hook for biblios
• 35362 - Update patron module pop-up windows with consistent footer markup
• 35994 + New acquisition status method to see if biblio record is still in acquisition
• 33360 - SendQueuedMessages: Improve limit behavior and add domain limits
• 30897 + Gracefully reload Koha after plugin install/upgrade
• 35826 + Optimize building of holds queue based on transport cost matrix
• 32680 - Add hooks to allow cover images to be provided by plugins
• 35511 - Add visual indicators of patron edit form collapsible sections
• 35364 - Update serials pop-up windows with consistent footer markup
• 26597 + Transfer information from guarantor when adding a guarantor to an existing patron
• 33087 + OPACHoldsIfAvailableAtPickup considers On order as available
• 29002 - Add ability to book items ahead of time
• 19532 - Recalls for Koha

Pushed to stable 1

• 35277 + Pseudonymization should be done in a background job

Pushed to oldstable 17

• 36034 + cas_ticket is set to serialized patron object in session
• 36665 - Auto location and IP recognition
• 35518 + Call to C4::Context->userenv happens before it's gets populated breaks code logic in circulation
• 28664 + One should not be able to issue a refund against a VOID accountline
• 34520 - Database update 22.06.00.078 breaks update process
• 35819 + "No job found" error for BatchUpdateBiblioHoldsQueue (race condition)
• 37043 + Counter registry has a new API base URL
• 35507 + Fix handling plugins in unit tests causing random failures on Jenkins
• 36948 - Adjust SIPconfig for log_file and IP version
• 33639 + Adding item to item group from 'Add item' screen doesn't work
• 36066 + REST API: We should only allow deleting cancelled order lines
• 23102 + 404 errors on page causes SCI user to be logged out
• 35070 + Koha plugins implementing "background_jobs" hook can't provide view template
• 28012 - Error on saving new numbering pattern
• 32312 + Complete database column descriptions for circulation module in guided reports 🎓
• 36386 + Prevent Net::Server warn about User Not Defined from SIPServer
• 35969 + Improve error message, remove some logging when sending a cart from the OPAC

Pushed to oldoldoldstable 17

• 19169 - Add a test to detect unneeded 'atomicupdate' files
• 29914 - check_cookie_auth not strict enough
• 28929 - No filtering on borrowers.flags on member entry pages (OPAC, self registration, staff interface)
• 30045 + SCO print slip is broken
• 28523 + Patrons with the most checkouts (bor_issues_top.pl) is failing with MySQL 8
• 28524 + Most-circulated items (cat_issues_top.pl) is failing with MySQL 8
• 28943 + Lower the risk of accidental patron deletion by cleanup_database.pl
• 28487 - Overdue_notices does not fall back to default language
• 28960 - EDI transfer_items uses a relationship where it's looking for a field
• 28462 - TT tag on several lines break the translator tool
• 19613 - Scrub borrowers fields: borrowernotes opacnote
• 28926 + Update cpanfile for Mojolicious::Plugin::OpenAPI v2.16
• 29300 + Release team 22.05
• 28802 + Untranslatable strings in browser.js
• 28409 - Category should be validated in opac-shelves.pl
• 28904 - Update information on Newsletter editor on about page
• 28644 + Can't call method "borrowernumber" on an undefined value at C4/Reserves.pm line 607

Pushed to main 12

• 34478 - Full CSRF protection
• 29087 + Holds to pull list can crash with a SQL::Abstract puke
• 36873 + Koha::Objects->delete should accept parameters and pass them through
• 36901 + Add logging for uncaught exceptions in background job classes
• 35539 + Remove unused columns from categories table
• 36343 + The 'after_biblio_action' hooks have an inconsistent signature compared to before_biblio_action, and actions in reserves and items
• 36970 - (Bug 34160 follow-up) Barcode should be html filtered, not uri filtered in holds queue view
• 30579 + When placing item level hold, some options that are not used are not disabled
• 36546 + Bundle API spec to speed up worker startup
• 31383 + Additional contents: We need a parent and child table
• 18317 + Allow check out of already checked out items through SIP
• 36582 - Add option to set library, desk, and register from user menu

Ready to push 4

• 26777 + Give the user the option to display their patron card barcode from the OPAC 🎓
• 35044 + Additional fields: Allow for repeatable fields
• 36736 + Add ability to load DBIx::Class Schema files found in plugins
• 19316 + Items should have sort1 and sort2 fields

Needs QA 6

• 35134 - cn_browser.pl pop-up size should be configurable
• 35630 + Add ability to log changes to authorized values
• 30657 - Make patron attributes available via Template Toolkit in notices
• 36357 - Add Template::Toolkit filters for internationalization (I18N)
• 21781 - message_transport_type should allow fallbacks
• 35508 - Update borrowers.updated_on when modifying a patron's attribute

Needs signoff 12

• 37389 - REST API queries joining on extended_attributes may cause severe performance issues
• 31380 - Build Mojolicious controller for running Koha plugins
• 37472 - Make plugins translatable
• 24194 - Add system preference to disable the use of expiration dates for holds
• 35560 - Use the REST API for holds history
• 36431 - SIP2: Checkin does not show difference between WasTransfered and NeedsTransfer
• 21272 - MARC import should warn about mis-matched branch during staged import
• 33758 - Add a parameter to use the intranet_catalog_biblio_enhancements_toolbar_button Plugin hook
• 32476 - Add caching for relatively expensive patron methods
• 21214 - cleanup_database.pl --mail should let admin choose which letter codes to keep
• 28657 - Expand branches.branchip to allow for multiple space separated IP ranges
• 33200 - IndependentBranchesTransfers does not prevent holds from creating transfers

Failed QA 53

• 17704 - Fix OAI breakage when using HTTP::OAI 4.03+
• 28259 - Checking at branch B an item in waiting hold state at branch A kill Koha
• 35165 + Batch item deletions are run in a single transaction and cause locking issues
• 17656 + Irregularities in serial prediction pattern are planned only for current subscription
• 25267 - OPAC browse shelf feature is not responsive
• 33554 - searching borrowers is a lot slower if there's searchable extended attributes.
• 15148 - Serials: Test prediction pattern starts at First issue date, not Subscription start date
• 32702 - Item statuses that block holds should be checked in CanItemBeReserved
• 26035 - AutoMemberNum fails on very large cardnumbers
• 29606 - Include items from host record in XML for XSLT processing
• 25220 + maxoutstanding syspref should be disabled by a null value
• 23357 - overdue_notices.pl can send library doubled emails for patrons with no email/sms if both transports enabled
• 36742 + Do not show Libraries in OPAC menu if there is just one public library
• 29008 - Warning when checking Koha version in plugins
• 13448 - runreport.pl html email striping
• 8112 + Overdues with Fines report, giving duplicates
• 23883 - sip_cli_emulator.pl - typo in parameter name
• 27269 - Move C4::Biblio::GetMarcSubjects to Koha namespace
• 20340 + Ability to use authentication plugin
• 32729 - Deleting an item removes the itemnumber from old_issues when it probably should not
• 36064 - Add Holds with cancellation requests info to intranet-main page
• 22683 - Make issue and old_issue prefetchable from Koha::Account::Line
• 17015 - New Koha Calendar
• 30975 + Use event delegation for framework plugins to avoid using private jQuery method _data
• 22421 - accountlines.issue_id is missing a foreign key constraint
• 36311 - Add option to koha-run-backups, to only include database dump
• 7376 + Transfer limits should be checked at check-in
• 26573 - Limit patron attribute types to more than one patron category
• 30295 - Send a notification when a recall is manually cancelled
• 34021 - Add option to search within results in the OPAC
• 25314 - Make OPAC facets collapse
• 15261 - Verify if checkout or hold request periods overlap with existing holds
• 13961 - Option to include patron's total amount of fines in notices
• 30182 - background_jobs.status should be an ENUM
• 16694 + Limit SIP2 auth by patron attribute
• 27696 + Add a dedicated self checkout (SCO) issue slip
• 7901 + Add option to delete_borrowers.pl for using a file with cardnumbers
• 27138 + Host items are not included in Z39 results when using EasyAnalytics
• 11708 + Display all basketgroups on one page, and new column aqbasketgroups.closeddate
• 18606 + Move rotating collections code to Koha::Object
• 29742 - Make deletemem.pl use Koha::Patron->safe_to_delete
• 21934 - Allow user to specify name for 'Shibboleth'
• 19133 + Password recovery routes
• 25039 - Move new due calculation to Koha::Checkout
• 16413 - Prototype for GetLatestAutoRenewDate and GetSoonestRenewDate should be changed
• 13664 - Add password strength plugin
• 9296 + overduerules table needs restructuring to allow future extension
• 16302 - Koha::Logger performance tests
• 11005 - Centralize the UseBranchTransferLimits-check under one function
• 11194 - Add a new index for "Edition Statement" of a MARC Record
• 15516 - Allow to place a hold on first available item from a group of titles
• 10858 + Browse selected biblios - OPAC
• 21559 - Rules for automatic framework codes

Patch doesn't apply 16

• 36182 - Add booksellerid column to holdings table
• 36025 - Extended attributes clause added to patron search query even when there are no searchable attributes
• 23415 + Notify patron fines when renewing
• 32767 - Optionally allow for trimming whitespace from patron attribute values
• 26744 - Log changes to extended patron attributes
• 36118 + ILL request log does not display patron information
• 12772 - Add item type and on-hold status to overdue notice/status triggers tool
• 4812 - Reserves for a specific copy of a book say book is available even though it it still checked out to someone else
• 25260 - Merge 'reserves' and 'old_reserves' into a new 'holds' table
• 13345 - Choose the format for the attached file when sending a basket/list by email
• 6113 + Keep previous IDs when importing bibliographic and authority records
• 33025 - Show an alert when adding a lost item to an item bundle
• 32370 - Provide a generic set of tools for JSON fields
• 23395 - batch operations on biblios/items should be able to pass a list of plugins
• 12805 - Proposed changes to Koha plugins system (.KPZ) structure
• 11651 - Add possibility to print holds from holds queue

In discussion 34

• 1993 + Task Scheduler Needs Re-write
• 14293 + Error in the calculation of the suspension of users per day
• 30654 - Even with RabbitMQ enabled, we should poll the database for jobs at worker startup
• 28120 - Koha Account pay is logging fine amountoutstanding as 0 when paying selected lines
• 35624 - Plugin tasks 'type' issue with plugins
• 10943 - Impossible to manage fines without borrowers permission 🎓
• 24489 - Prevent user from paying/writing off 0
• 22539 + Fines charged on back-dated checkin when item has been renewed
• 13680 - Items list on edit items page separates add items form from header and sidebar
• 29392 - Add plugin hooks before merging biblios or authorities
• 15338 - Remove inconsistency in location of SIPServer.pm
• 20271 - Merge deleted biblio, biblioitems, biblio_metadata, and items tables
• 15522 - New interface for revamped circulation rules
• 35688 - RFID Envisionware Software requires static page title
• 36419 - Ambiguous return value in GetPlugins
• 15341 - Performance - Retrieve all sysprefs at once
• 30225 - Rewrite cities admin view in Vue
• 25643 - Move maxreserves functionality into circulation rules
• 21572 - Allow checkout an item with pending hold that is not yet in waiting state
• 6590 + Removing hyphens from ISBN and ISSN when cataloging a biblio
• 25029 - AllowPatronToControlAutorenewal needs to have a disable setting
• 28589 - Move C4 and Koha to lib
• 5739 + Check out waiting holds directly from "hold waiting" alerts on circulation screen
• 26509 - Add Koha::Items->safe_delete
• 26652 - Add a way to mark messages as 'seen' in Koha::Object
• 23890 - Plugins that utilise possibly security breaching hooks should warn
• 24009 - Koha::Account->outstanding_debits should support inline filtering
• 16140 - Only clear L1 cache when needed
• 21685 - Name our exceptions consistently
• 18003 - Should deletedborrowers.borrowernumber be a primary key?
• 8058 + Circulation empty barcode field redirect to pay fines screen if borrower has outstanding fines
• 12780 - Addition of plugins-menu.inc for adding a nav menu for Koha Plugins
• 15107 - Batch Patron Deletion (Trash) Performance Improvement
• 11904 - Proposal for a uniform way to send messages to user interface

Reopened 5

• 34899 - Circulation rules: Only allow "Local use" patron category to place holds on specific library's items
• 30085 - Improve performance of CanItemBeReserved
• 32571 + Use template wrapper to build tabbed components
• 26129 - Add a new 'configurations' table
• 29718 + DateTime - our 'iso' is not ISO 8601

Blocked 5

• 34355 - Automated MARC record ordering process
• 17215 - Cardnumbers of patrons created using LDAP Replication not using autoMemberNum if configured
• 31415 - Script to automate converting holds to recalls
• 28658 - With SearchMyLibraryFirst: If library isn't set for the OPAC, try to guess it by checking branchip
• 11988 - Display basket group close date on late orders

Assigned 13

• 21670 - t/db_dependent/Plugins.t is failing randomly on Jenkins
• 26463 - AllowHoldPolicyOverride overrides too many holds policies
• 29275 - Use the API to render checkout history for a biblio
• 34472 - Template Toolkit reference guide needed
• 19358 - Purchase suggestions - enhancements to linking to orders
• 28655 - New ideas/proposal to enhance pluggability
• 22160 - OMNIBUS: Transfers enhancements
• 22457 - OpacHiddenItemsExceptions should be moved to a category attribute
• 20817 + Add ability to retain 9xx fields when adding on order item to existing record
• 28498 - Add CLI counterpart for plugin actions
• 19270 - Advanced Editor - Rancor - Add ability to search batches on arbitrary marc fields
• 21419 - Inventory - Allow skipping in transit items
• 12754 - Add XSLT action to MARC modification templates

New 134

• 20956 - BorrowersLog is not logging permission changes
• 37392 - Edit item permission by library group is broken
• 35118 - Background job workers are not tested
• 31394 - Background hold cancellation causing confusion
• 37307 - Update And Run SQL function appends report ID to savedsql
• 37191 - iCal shows items due one day later than due date in Koha
• 23187 - Koha::Objects supports find_or_create without passing through the Koha::Object store method
• 36954 - SIP server logging needs an overhaul...
• 12044 - Checkout should be clearly disallowed before inputting item barcode if a patron's fines will block the transaction
• 27423 - ILS-DI should be deprecated and functions moved to REST API
• 36369 - Make APIClient be more useful
• 33905 - Username and cardnumber should be unique respectively
• 22215 - table_borrowers name is inconsistent with other tables
• 34821 - Inventory tool optional filters for lost, withdrawn and damaged appear to do nothing
• 36345 - Deleting related things causes data loss for old_reserves
• 36427 - Library branch ip addresses should be validated
• 36297 - Avoid using var named "t" in templates
• 32429 - With "Write off all" UseEmailReceipts sends emails for each, with "Write off selected" a digest
• 36226 - Large patron databases create difficult patron auto-complete searches
• 28957 - Many plugins require the full plugins permission set to run
• 17427 + Replace CGI::Session with Data::Session
• 22108 - Items generated through MARCItemFieldsToOrder do not receive values applied in Item Information and Default Accounting Details
• 20178 - Fix output_pref with dateformat=iso
• 26500 - Automatic renewals show incorrect count of renewals allowed when CircControl is set to "the library you're logged in at"
• 16104 - Warnings "used only once: possible typo" should be removed
• 28922 - Vendor search has poor performance when system has many vendors
• 19696 - HoldsQueue.t is failing randomly
• 33827 - The option to skip bundle verification at checkin should be syspref driven
• 12599 - IndependentBranches Holes
• 7515 - Authorized value code showing in OPAC for public note
• 32090 - Emojis (or other utf8 characters) can break background job processing
• 32084 - GetMaxPatronHoldsForRecord is incorrect and inefficient
• 31971 - SIP server rejects passwords ending in non-alphanumeric characters
• 31855 - Installer output buffering can be confusing
• 31574 - Cannot place hold message should be adjusted when override is allowed
• 31073 - ThingISBN API causes slowness when there are many editions
• 17239 - Vulnerabilitiy warning for package C4::Biblio
• 25003 - Clearly identify when JavaScript errors are caused by OPACUserJS/IntranetUserJS
• 28953 - Incorrect behavior when voiding a payment on an fine that was paid while accruing and later backdated at return such that it should not have been fined
• 24749 - Plack restart should clear orphaned cgi_compile directories on restart
• 26461 - Incorrect handling of hold levels in SIP2 code
• 24868 - When CircControl or ReservesControlBranch are enforced based on item, location limits are enforced per library
• 18992 - LDAP fallback behaviour not consistent
• 27054 - Round fines at charging
• 26277 - Merging records allows a mix of hold types
• 25609 - Use of permanent location instead of location
• 24660 - ModBiblio spams cataloguing log when linking to authorities
• 20655 - Z3950 Authorities search is unordered
• 7802 + A MySQLism is used to get the current date.
• 21592 - When adding to basket from a file and using MarcFieldsToOrder items are not added to basket if missing funds
• 15115 - Editing item information on active course reserves should not be allowed.
• 36810 - Resend button for notices being hidden by CSS and never unhidden
• 35825 - User without edit_any_item permission gets "Edit item" and "Delete item" options on restricted item
• 34362 - Stage MARC for import background job - Progress bar does not progress
• 24882 - Date updated and Date/time of change are the same on payment/fee details
• 29896 - Sync the functionality of the datatables api wrapper on the OPAC with the Staff Client equivilent
• 33308 - Add ability to to use SFTP with runreport.pl
• 18062 - Damaged Status shows unavailable in results
• 24483 - When batch deleting patrons, report who was not deleted and why
• 37154 - [OMNIBUS] Remove all unnecessary uses of unbless
• 27443 - Add an item loop mechanism to patron_emailer.pl cron
• 7010 + Select all records from search
• 13821 - Add possibility to select more than one department on a course reserve
• 29533 - Add additional fields to items
• 36765 - TestBuilder should explode if FK broken
• 36764 - Koha::Plugins::Base->store_data should return something more useful
• 31458 - Remove Koha::Patron::Debarment::AddDebarment and use $patron->add_restriction in preference
• 36540 - Consider modernising the checkout page to be an Vue page
• 36385 - HTML escaped via JavaScript should encode all entities
• 36205 - Plugins should be able to create permissions
• 20973 - Article requests: Can't tell which library filled an article request
• 15521 - Make circulation rules backend more granular
• 25098 - automatic item modification needs report function
• 24580 - Allow patron_emailer or parallel structure to generate custom print notices from report output
• 35440 - Partial refund triggers a 500 error
• 21236 - Restore ability to selectively set item to lost without generating fee
• 10756 - Add carousel/coverflow display of new titles to the OPAC
• 35311 - Add ability to map content of EDI FTX segment into various fields
• 33681 - Omnibus: Allow SIP2 users to be created through the Koha staff interface
• 33768 - We need tests for the OAuth2/OIDC client
• 32078 - We should have an easy way for an administrator to update the encryption keys
• 28010 - add plugin to modify record in "opac-detail.pl"
• 26275 - Deleting item should not automatically delete group
• 16698 - Preferences like UpdateItemLocationOnCheckin need a GUI editor
• 28499 - Add support for no-UI / administrative plugins
• 10846 - Add preference for naming OverDrive collection
• 33878 - SIP does not warn for patron expiry (as NotifyBorrowerDeparture does)
• 33846 - 'Save' and 'close' buttons confusing on multi-receive
• 32324 - Add ability to disable the OPAC
• 16723 - Add additional subscription fields to serial claim notices
• 21017 - Plugins: Allow for post-install configure flag
• 22407 - OMNIBUS: Use DBIC relations to fetch related object rather than searching for the object
• 4948 + When cancelling a waiting hold, allow to trigger hold for next patron
• 31602 - Replace Try::Tiny with something faster
• 15349 - Problem with email pattern check on forms
• 31172 - Shouldn't issues.issuedate have a DEFAULT NOW() and be NOT NULL?
• 24867 - Keep CircControl / ReservesControlBranch / HomeOrHolding together in sysprefs
• 25219 - Include note in fines-related system preferences which can be disabled by leaving them blank
• 30019 - We should DRY out search_limited (and rename it)
• 29441 - We should make our method returns consistent in Koha::Biblio
• 30331 - Allow RenewalPeriodBase behavior to differ between manual and automatic renewals
• 30017 - Should we prefer `loop.first` and `loop.last` over calling `variable.count` to reduce our DB hits
• 30048 - Koha::ArticleRequests->search_limited may be malformed.
• 29106 - Can we get rid of Koha::Item->effective_itemtype
• 29140 - Suppress some warnings in codemirror js editor
• 17996 - longoverdue.pl should not set 'datereturned' when --mark-returned option is used.
• 12793 - Breaking up IndependentBranches syspref to support finer staff permissions granularity
• 20533 - Deduplicate entries and add paging for call number browser plugin
• 26929 - Koha will only display the first 20 macros Advanced Editor
• 17180 - Add a current date macro to the advanced cataloging editor
• 27831 - Object Name Inconsistencies
• 17409 - Remove redundant note fields for payments on pay.pl
• 26610 - Add 'NULL' option to report value dropdowns
• 25610 - Inconsistent display of 856$3 in OPAC between brief result and full record
• 23511 - Overdrive Advantage integration
• 25488 - Add method to clear clipboard in advanced catalog editor
• 18905 - Advanced editor - Rancor - Add support for /cataloguing/value_builder/upload.pl
• 25489 - Add ability to delete without sending to clipboard in advanced catalog editor
• 24535 - Add the ability to have longer barcodes than 20 digits
• 27374 - Add possibility to attach arbitrary notes to items
• 19306 - Adding hooks to the plugin system
• 24204 - Talking Tech i-tiva is now illion Digital Tech Solutions
• 6973 + Allow reply-to on cart emails to go to the sender of the cart
• 24513 - Should have SIPRenewalBranch preference like OpacRenewalBranch
• 17408 - paycollect.pl should show more information
• 17406 - Simplify pay.pl interface buttons
• 24007 - Koha::Account::non_issues_charges is badly named
• 20545 - Add multi-language support to SIP2
• 21764 - Add more spans with classes around callnumbers in OPAC for additional styling (UNIMARC & NORMARC)
• 19010 - When downloading reports, long running reoprts will time out
• 13924 - LocalHoldsPriority needs dateaccessioned limits.
• 12141 - On Display Module
• 19814 - Batch Check-in function
• 12919 - Automate collecting all records added and deleted from the catalogue