January 2025 - Koha-bugs - lists.koha-community.org

[Bug 35361] New: Search filter on receive orders page crashes the system
by bugzilla-daemon＠bugs.koha-community.org 22 Mar '25

22 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35361 Bug ID: 35361 Summary: Search filter on receive orders page crashes the system Change sponsored?: --- Product: Koha Version: 23.05 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: andreas.jonsson(a)kreablo.se CC: tomascohen(a)gmail.com The search filter for the table on the page acqui/parcel.pl generates the below api-request, which results in the below sql query. Note how the LIMIT clause is applied to the sub-query, not the whole query. For us, this specific query actually yielded a search result of in total over 171 000 rows. GET /api/v1/acquisitions/orders?only_active=1&_page=1&_per_page=20&q={"-and":[{"basket.vendor_id":5},[[{"basket.name":{"like":"%97891%"}}],[{"basket.basket_group.name":{"like":"%97891%"}}],[{"me.order_id":{"like":"%97891%"}}],[{"biblio.title":{"like":"%97891%"}},{"biblio.author":{"like":"%97891%"}},{"biblio.isbn":{"like":"%97891%"}},{"biblio.publisher":{"like":"%97891%"}},{"me.internal_note":{"like":"%97891%"}},{"me.vendor_note":{"like":"%97891%"}}],[{"me.replacement_price":{"like":"%97891%"}}],[{"me.quantity":{"like":"%97891%"}}],[{"me.ecost":{"like":"%97891%"}}],[{"fund.name":{"like":"%97891%"}}]]]}&_match=contains&_order_by=+basket.name HTTP/1.1 SELECT `me`.`ordernumber`, `me`.`biblionumber`, `me`.`deleted_biblionumber`, `me`.`entrydate`, `me`.`quantity`, `me`.`currency`, `me`.`listprice`, `me`.`datereceived`, `me`.`invoiceid`, `me`.`freight`, `me`.`unitprice`, `me`.`unitprice_tax_excluded`, `me`.`unitprice_tax_included`, `me`.`quantityreceived`, `me`.`created_by`, `me`.`datecancellationprinted`, `me`.`cancellationreason`, `me`.`order_internalnote`, `me`.`order_vendornote`, `me`.`purchaseordernumber`, `me`.`basketno`, `me`.`timestamp`, `me`.`rrp`, `me`.`replacementprice`, `me`.`rrp_tax_excluded`, `me`.`rrp_tax_included`, `me`.`ecost`, `me`.`ecost_tax_excluded`, `me`.`ecost_tax_included`, `me`.`tax_rate_bak`, `me`.`tax_rate_on_ordering`, `me`.`tax_rate_on_receiving`, `me`.`tax_value_bak`, `me`.`tax_value_on_ordering`, `me`.`tax_value_on_receiving`, `me`.`discount`, `me`.`budget_id`, `me`.`budgetdate`, `me`.`sort1`, `me`.`sort2`, `me`.`sort1_authcat`, `me`.`sort2_authcat`, `me`.`uncertainprice`, `me`.`subscriptionid`, `me`.`parent_ordernumber`, `me`.`orderstatus`, `me`.`line_item_id`, `me`.`suppliers_reference_number`, `me`.`suppliers_reference_qualifier`, `me`.`suppliers_report`, `me`.`estimated_delivery_date`, `me`.`invoice_unitprice`, `me`.`invoice_currency`, `basket`.`basketno`, `basket`.`basketname`, `basket`.`note`, `basket`.`booksellernote`, `basket`.`contractnumber`, `basket`.`creationdate`, `basket`.`closedate`, `basket`.`booksellerid`, `basket`.`authorisedby`, `basket`.`booksellerinvoicenumber`, `basket`.`basketgroupid`, `basket`.`deliveryplace`, `basket`.`billingplace`, `basket`.`branch`, `basket`.`is_standing`, `basket`.`create_items`, `basket_group`.`id`, `basket_group`.`name`, `basket_group`.`closed`, `basket_group`.`booksellerid`, `basket_group`.`deliveryplace`, `basket_group`.`freedeliveryplace`, `basket_group`.`deliverycomment`, `basket_group`.`billingplace`, `biblio`.`biblionumber`, `biblio`.`frameworkcode`, `biblio`.`author`, `biblio`.`title`, `biblio`.`medium`, `biblio`.`subtitle`, `biblio`.`part_number`, `biblio`.`part_name`, `biblio`.`unititle`, `biblio`.`notes`, `biblio`.`serial`, `biblio`.`seriestitle`, `biblio`.`copyrightdate`, `biblio`.`timestamp`, `biblio`.`datecreated`, `biblio`.`abstract`, `biblioitem`.`biblioitemnumber`, `biblioitem`.`biblionumber`, `biblioitem`.`volume`, `biblioitem`.`number`, `biblioitem`.`itemtype`, `biblioitem`.`isbn`, `biblioitem`.`issn`, `biblioitem`.`ean`, `biblioitem`.`publicationyear`, `biblioitem`.`publishercode`, `biblioitem`.`volumedate`, `biblioitem`.`volumedesc`, `biblioitem`.`collectiontitle`, `biblioitem`.`collectionissn`, `biblioitem`.`collectionvolume`, `biblioitem`.`editionstatement`, `biblioitem`.`editionresponsibility`, `biblioitem`.`timestamp`, `biblioitem`.`illus`, `biblioitem`.`pages`, `biblioitem`.`notes`, `biblioitem`.`size`, `biblioitem`.`place`, `biblioitem`.`lccn`, `biblioitem`.`url`, `biblioitem`.`cn_source`, `biblioitem`.`cn_class`, `biblioitem`.`cn_item`, `biblioitem`.`cn_suffix`, `biblioitem`.`cn_sort`, `biblioitem`.`agerestriction`, `biblioitem`.`totalissues`, `items`.`itemnumber`, `items`.`biblionumber`, `items`.`biblioitemnumber`, `items`.`barcode`, `items`.`dateaccessioned`, `items`.`booksellerid`, `items`.`homebranch`, `items`.`price`, `items`.`replacementprice`, `items`.`replacementpricedate`, `items`.`datelastborrowed`, `items`.`datelastseen`, `items`.`stack`, `items`.`notforloan`, `items`.`damaged`, `items`.`damaged_on`, `items`.`itemlost`, `items`.`itemlost_on`, `items`.`withdrawn`, `items`.`withdrawn_on`, `items`.`itemcallnumber`, `items`.`coded_location_qualifier`, `items`.`issues`, `items`.`renewals`, `items`.`reserves`, `items`.`restricted`, `items`.`itemnotes`, `items`.`itemnotes_nonpublic`, `items`.`holdingbranch`, `items`.`timestamp`, `items`.`deleted_on`, `items`.`location`, `items`.`permanent_location`, `items`.`onloan`, `items`.`cn_source`, `items`.`cn_sort`, `items`.`ccode`, `items`.`materials`, `items`.`uri`, `items`.`itype`, `items`.`more_subfields_xml`, `items`.`enumchron`, `items`.`copynumber`, `items`.`stocknumber`, `items`.`new_status`, `items`.`exclude_from_local_holds_priority`, `suggestions`.`suggestionid`, `suggestions`.`suggestedby`, `suggestions`.`suggesteddate`, `suggestions`.`managedby`, `suggestions`.`manageddate`, `suggestions`.`acceptedby`, `suggestions`.`accepteddate`, `suggestions`.`rejectedby`, `suggestions`.`rejecteddate`, `suggestions`.`lastmodificationby`, `suggestions`.`lastmodificationdate`, `suggestions`.`STATUS`, `suggestions`.`archived`, `suggestions`.`note`, `suggestions`.`staff_note`, `suggestions`.`author`, `suggestions`.`title`, `suggestions`.`copyrightdate`, `suggestions`.`publishercode`, `suggestions`.`date`, `suggestions`.`volumedesc`, `suggestions`.`publicationyear`, `suggestions`.`place`, `suggestions`.`isbn`, `suggestions`.`biblionumber`, `suggestions`.`reason`, `suggestions`.`patronreason`, `suggestions`.`budgetid`, `suggestions`.`branchcode`, `suggestions`.`collectiontitle`, `suggestions`.`itemtype`, `suggestions`.`quantity`, `suggestions`.`currency`, `suggestions`.`price`, `suggestions`.`total`, `suggester`.`borrowernumber`, `suggester`.`cardnumber`, `suggester`.`surname`, `suggester`.`firstname`, `suggester`.`middle_name`, `suggester`.`title`, `suggester`.`othernames`, `suggester`.`initials`, `suggester`.`pronouns`, `suggester`.`streetnumber`, `suggester`.`streettype`, `suggester`.`address`, `suggester`.`address2`, `suggester`.`city`, `suggester`.`state`, `suggester`.`zipcode`, `suggester`.`country`, `suggester`.`email`, `suggester`.`phone`, `suggester`.`mobile`, `suggester`.`fax`, `suggester`.`emailpro`, `suggester`.`phonepro`, `suggester`.`B_streetnumber`, `suggester`.`B_streettype`, `suggester`.`B_address`, `suggester`.`B_address2`, `suggester`.`B_city`, `suggester`.`B_state`, `suggester`.`B_zipcode`, `suggester`.`B_country`, `suggester`.`B_email`, `suggester`.`B_phone`, `suggester`.`dateofbirth`, `suggester`.`branchcode`, `suggester`.`categorycode`, `suggester`.`dateenrolled`, `suggester`.`dateexpiry`, `suggester`.`password_expiration_date`, `suggester`.`date_renewed`, `suggester`.`gonenoaddress`, `suggester`.`lost`, `suggester`.`debarred`, `suggester`.`debarredcomment`, `suggester`.`contactname`, `suggester`.`contactfirstname`, `suggester`.`contacttitle`, `suggester`.`borrowernotes`, `suggester`.`relationship`, `suggester`.`sex`, `suggester`.`password`, `suggester`.`secret`, `suggester`.`auth_method`, `suggester`.`flags`, `suggester`.`userid`, `suggester`.`opacnote`, `suggester`.`contactnote`, `suggester`.`sort1`, `suggester`.`sort2`, `suggester`.`altcontactfirstname`, `suggester`.`altcontactsurname`, `suggester`.`altcontactaddress1`, `suggester`.`altcontactaddress2`, `suggester`.`altcontactaddress3`, `suggester`.`altcontactstate`, `suggester`.`altcontactzipcode`, `suggester`.`altcontactcountry`, `suggester`.`altcontactphone`, `suggester`.`smsalertnumber`, `suggester`.`sms_provider_id`, `suggester`.`privacy`, `suggester`.`privacy_guarantor_fines`, `suggester`.`privacy_guarantor_checkouts`, `suggester`.`checkprevcheckout`, `suggester`.`updated_on`, `suggester`.`lastseen`, `suggester`.`lang`, `suggester`.`login_attempts`, `suggester`.`overdrive_auth_token`, `suggester`.`anonymized`, `suggester`.`autorenew_checkouts`, `suggester`.`primary_contact_method`, `fund`.`budget_id`, `fund`.`budget_parent_id`, `fund`.`budget_code`, `fund`.`budget_name`, `fund`.`budget_branchcode`, `fund`.`budget_amount`, `fund`.`budget_encumb`, `fund`.`budget_expend`, `fund`.`budget_notes`, `fund`.`timestamp`, `fund`.`budget_period_id`, `fund`.`sort1_authcat`, `fund`.`sort2_authcat`, `fund`.`budget_owner_id`, `fund`.`budget_permission` FROM (SELECT `me`.`ordernumber`, `me`.`biblionumber`, `me`.`deleted_biblionumber`, `me`.`entrydate`, `me`.`quantity`, `me`.`currency`, `me`.`listprice`, `me`.`datereceived`, `me`.`invoiceid`, `me`.`freight`, `me`.`unitprice`, `me`.`unitprice_tax_excluded`, `me`.`unitprice_tax_included`, `me`.`quantityreceived`, `me`.`created_by`, `me`.`datecancellationprinted`, `me`.`cancellationreason`, `me`.`order_internalnote`, `me`.`order_vendornote`, `me`.`purchaseordernumber`, `me`.`basketno`, `me`.`timestamp`, `me`.`rrp`, `me`.`replacementprice`, `me`.`rrp_tax_excluded`, `me`.`rrp_tax_included`, `me`.`ecost`, `me`.`ecost_tax_excluded`, `me`.`ecost_tax_included`, `me`.`tax_rate_bak`, `me`.`tax_rate_on_ordering`, `me`.`tax_rate_on_receiving`, `me`.`tax_value_bak`, `me`.`tax_value_on_ordering`, `me`.`tax_value_on_receiving`, `me`.`discount`, `me`.`budget_id`, `me`.`budgetdate`, `me`.`sort1`, `me`.`sort2`, `me`.`sort1_authcat`, `me`.`sort2_authcat`, `me`.`uncertainprice`, `me`.`subscriptionid`, `me`.`parent_ordernumber`, `me`.`orderstatus`, `me`.`line_item_id`, `me`.`suppliers_reference_number`, `me`.`suppliers_reference_qualifier`, `me`.`suppliers_report`, `me`.`estimated_delivery_date`, `me`.`invoice_unitprice`, `me`.`invoice_currency` FROM `aqorders` `me` LEFT JOIN `aqbasket` `basket` ON `basket`.`basketno` = `me`.`basketno` LEFT JOIN `aqbasketgroups` `basket_group` ON `basket_group`.`id` = `basket`.`basketgroupid` LEFT JOIN `biblio` `biblio` ON `biblio`.`biblionumber` = `me`.`biblionumber` LEFT JOIN `biblioitems` `biblioitem` ON `biblioitem`.`biblionumber` = `biblio`.`biblionumber` JOIN `aqbudgets` `fund` ON `fund`.`budget_id` = `me`.`budget_id` WHERE ( ( ( ( `me`.`ecost` LIKE '%97891%' OR `me`.`quantity` LIKE '%97891%' OR `me`.`ordernumber` LIKE '%97891%' OR `fund`.`budget_name` LIKE '%97891%' OR `basket`.`basketname` LIKE '%97891%' OR `basket_group`.`name` LIKE '%97891%' OR `me`.`replacementprice` LIKE '%97891%' OR `biblio`.`title` LIKE '%97891%' OR `biblio`.`author` LIKE '%97891%' OR `biblioitem`.`isbn` LIKE '%97891%' OR `me`.`order_vendornote` LIKE '%97891%' OR `me`.`order_internalnote` LIKE '%97891%' OR `biblioitem`.`publishercode` LIKE '%97891%' ) AND ( ( `orderstatus` = 'ordered' OR `orderstatus` = 'partial' ) OR ( `basket`.`is_standing` = '1' AND ( `orderstatus` = 'new' OR `orderstatus` = 'ordered' OR `orderstatus` = 'partial' ) ) ) ) AND `basket`.`booksellerid` = '5' ) ) GROUP BY `me`.`ordernumber`, `me`.`biblionumber`, `me`.`deleted_biblionumber`, `me`.`entrydate`, `me`.`quantity`, `me`.`currency`, `me`.`listprice`, `me`.`datereceived`, `me`.`invoiceid`, `me`.`freight`, `me`.`unitprice`, `me`.`unitprice_tax_excluded`, `me`.`unitprice_tax_included`, `me`.`quantityreceived`, `me`.`created_by`, `me`.`datecancellationprinted`, `me`.`cancellationreason`, `me`.`order_internalnote`, `me`.`order_vendornote`, `me`.`purchaseordernumber`, `me`.`basketno`, `me`.`timestamp`, `me`.`rrp`, `me`.`replacementprice`, `me`.`rrp_tax_excluded`, `me`.`rrp_tax_included`, `me`.`ecost`, `me`.`ecost_tax_excluded`, `me`.`ecost_tax_included`, `me`.`tax_rate_bak`, `me`.`tax_rate_on_ordering`, `me`.`tax_rate_on_receiving`, `me`.`tax_value_bak`, `me`.`tax_value_on_ordering`, `me`.`tax_value_on_receiving`, `me`.`discount`, `me`.`budget_id`, `me`.`budgetdate`, `me`.`sort1`, `me`.`sort2`, `me`.`sort1_authcat`, `me`.`sort2_authcat`, `me`.`uncertainprice`, `me`.`subscriptionid`, `me`.`parent_ordernumber`, `me`.`orderstatus`, `me`.`line_item_id`, `me`.`suppliers_reference_number`, `me`.`suppliers_reference_qualifier`, `me`.`suppliers_report`, `me`.`estimated_delivery_date`, `me`.`invoice_unitprice`, `me`.`invoice_currency`, `basket`.`basketname` ORDER BY `basket`.`basketname` ASC LIMIT 20) `me` LEFT JOIN `aqbasket` `basket` ON `basket`.`basketno` = `me`.`basketno` LEFT JOIN `aqbasketgroups` `basket_group` ON `basket_group`.`id` = `basket`.`basketgroupid` LEFT JOIN `biblio` `biblio` ON `biblio`.`biblionumber` = `me`.`biblionumber` LEFT JOIN `biblioitems` `biblioitem` ON `biblioitem`.`biblionumber` = `biblio`.`biblionumber` LEFT JOIN `items` `items` ON `items`.`biblionumber` = `biblio`.`biblionumber` LEFT JOIN `suggestions` `suggestions` ON `suggestions`.`biblionumber` = `biblio`.`biblionumber` LEFT JOIN `borrowers` `suggester` ON `suggester`.`borrowernumber` = `suggestions`.`suggestedby` JOIN `aqbudgets` `fund` ON `fund`.`budget_id` = `me`.`budget_id` WHERE ( ( ( ( `me`.`ecost` LIKE '%97891%' OR `me`.`quantity` LIKE '%97891%' OR `me`.`ordernumber` LIKE '%97891%' OR `fund`.`budget_name` LIKE '%97891%' OR `basket`.`basketname` LIKE '%97891%' OR `basket_group`.`name` LIKE '%97891%' OR `me`.`replacementprice` LIKE '%97891%' OR `biblio`.`title` LIKE '%97891%' OR `biblio`.`author` LIKE '%97891%' OR `biblioitem`.`isbn` LIKE '%97891%' OR `me`.`order_vendornote` LIKE '%97891%' OR `me`.`order_internalnote` LIKE '%97891%' OR `biblioitem`.`publishercode` LIKE '%97891%' ) AND ( ( `orderstatus` = 'ordered' OR `orderstatus` = 'partial' ) OR ( `basket`.`is_standing` = '1' AND ( `orderstatus` = 'new' OR `orderstatus` = 'ordered' OR `orderstatus` = 'partial' ) ) ) ) AND `basket`.`booksellerid` = '5' ) ) ORDER BY `basket`.`basketname` ASC; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16

[Bug 33554] New: searching borrowers is a lot slower if there's searchable extended attributes.
by bugzilla-daemon＠bugs.koha-community.org 22 Mar '25

22 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33554 Bug ID: 33554 Summary: searching borrowers is a lot slower if there's searchable extended attributes. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: didier.gautheron(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Depends on: 30055 Hi, Since BZ 30055 search is using the REST API. For a library with 80,000 borrowers and 800,000 borrower_attributes, (one searchable per borrower), searching a borrower is twice as slow and is noticeable in checkin/checkout. before 30055 the request was something like : SELECT borrowernumber FROM borrowers WHERE firstname` LIKE '%foo%' OR middle_name LIKE '%foo%' OR surname LIKE '%foo%' OR othernames LIKE '%foo%' OR cardnumber LIKE '%foo%' OR userid LIKE '%foo%' OR borrowernumber in ( select borrowernumber from borrower_attributes where attribute LIKE '%foo%' AND code = 'BAR' ) GROUP BY borrowernumber; runtime 0.069 sec in master SELECT borrowernumber FROM borrowers LEFT JOIN borrower_attributes USING(borrowernumber) WHERE firstname` LIKE '%foo%' OR middle_name LIKE '%foo%' OR surname LIKE '%foo%' OR othernames LIKE '%foo%' OR cardnumber LIKE '%foo%' OR userid LIKE '%foo%' OR (attribute LIKE '%foo%' AND code = 'BAR' ) GROUP BY borrowernumber; runtime 1.324 sec Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30055 [Bug 30055] Rewrite some of the patron searches to make them use the REST API routes -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 35

[Bug 28841] New: Canceling holds from Waiting Reserves should follow the same rules as for checking in items concerning transfers
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28841 Bug ID: 28841 Summary: Canceling holds from Waiting Reserves should follow the same rules as for checking in items concerning transfers Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: sophie.meynieux(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com When a Hold is canceled from Waiting Reserves, it is automatically transfered to homebranch if it is different from holdingbranch, ignoring return policy defined in circulation rules. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 36780] New: Should templates (notices and slips) ignore print_XXX.css stylesheet
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36780 Bug ID: 36780 Summary: Should templates (notices and slips) ignore print_XXX.css stylesheet Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: cbrannon(a)cdalibrary.org QA Contact: testopia(a)bugs.koha-community.org It seems I am fighting against the print stylesheet at times. Particularly with the templates (notices and slips) regarding tables in report templates. Everything looks great on screen, just the way I plan it, then when you get to the print preview and printing, the print stylesheet takes over. This is extremely troubling when you are working hard to style something for print. It seems like the template should offer a way to exclude the stylesheet. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 30056] New: autoBarcode and serial supplemental issue
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30056 Bug ID: 30056 Summary: autoBarcode and serial supplemental issue Change sponsored?: --- Product: Koha Version: 20.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: pierre.genty(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Hi, In administration module, autoBarcode preference is set to "generated in the form <branchcode> yymm001". In framework structure, barcode.pl plugin is called in the item barcode field. I am editing a serial (Create an item record when receiving this serial is set), change the status to "Arrived", automatically create a barcode by clicking on barcode box, then create a supplemental issue (before to save). The automatic barcode for this supplemental issue is equal to the regular issue above. Don't know if it is possible but the plugin barcode.pl should check for a previous auto generated barcode in the current page in order to avoid duplicate barcode. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 8

[Bug 35355] New: Add ability to auto print holds slips through autofillholds system preference
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35355 Bug ID: 35355 Summary: Add ability to auto print holds slips through autofillholds system preference Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: esther.melander(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com It would be nice to expand or enhance the autofillholds functionality. If a patron places a hold in the OPAC, it would be nice that a hold slip is auto printed. Another option would be to add an optional notification in the staff interface home screen that says something like "pending holds" with a print button to print the hold slips. "Pending holds" would have to be updated in real time to provide ultimate functionality. This would be very useful for Archives in which materials must be retrieved upon request. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 27339] New: Display opac notes and opac messages on check-in
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27339 Bug ID: 27339 Summary: Display opac notes and opac messages on check-in Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: didier.gautheron(a)biblibre.com Reporter: didier.gautheron(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Currently, Circulation note (borrowers.borrowernotes) and item notes (items.itemnotes and items.itemnotes_nonpublic) are displayed during check-in. This patch adds Opac note (borrowers.opacnote) and Opac messages (messages table). Test plan: - Add an Opac note and one or several Opac messages to a patron. - Checkout and check-in an item for this patron. - Check that Opac note and Opac message(s) are not displayed on check-in. - Apply the patch. - Checkout and check-in an item for this patron. - Check that Opac note and Opac message(s) are displayed on check-in. -- You are receiving this mail because: You are watching all bug changes.

1 37

[Bug 35765] New: No permissions to create Public Lists
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35765 Bug ID: 35765 Summary: No permissions to create Public Lists Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Lists Assignee: koha-bugs(a)lists.koha-community.org Reporter: jzairo(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Currently staff with permission to the staff interface (catalogue) automatically have access to create lists. The only permissions that currently exist for staff are delete and edit. Delete public lists (delete_public_lists) Edit public lists contents (edit_public_list_contents) Edit public lists (Name, settings, and permissions, but not explicitly contents) (edit_public_lists) It would be beneficial to add a permission to "create public lists" ensure that staff just can't create unnecessary visible public lists. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 35400] New: Public lists permission
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35400 Bug ID: 35400 Summary: Public lists permission Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Lists Assignee: koha-bugs(a)lists.koha-community.org Reporter: michaela.sieber(a)kit.edu QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl There should be a permission to allow staff members to create public list in the opac. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 1

[Bug 21412] New: Opac upload file access
by bugzilla-daemon＠bugs.koha-community.org 21 Mar '25

21 Mar '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21412 Bug ID: 21412 Summary: Opac upload file access Change sponsored?: --- Product: Koha Version: 18.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: scdogan(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 79410 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=79410&action=ed… step1 I want to restrict access to the files I upload in the Koha automation system. What steps can I use? Thank you. 1. 1. Opac Display - Disable ( This collection will be private) 2. https://www.youtube.com/watch?v=mbYgsodcPaU (How to attach a file to a MARC Record in Koha) 3. Cataloging step 4.Copy upload file link ( For Example : http://193.140.223.100/cgi-bin/koha/opac-retrieve-file.pl?id=eca42072bd9eb8… ) 5. Log out Koha 6. Paste link any browser than file is open. I want to system asked username and password -- You are receiving this mail because: You are watching all bug changes.

1 10