[Koha] circulation overdues report

Сычев Игорь Алексеевич ias at tpu.ru
Wed May 21 16:25:45 NZST 2025


Thanks for the answer!
The report is necessary for a teacher who does not work with Koha. 
Need to leave only "borrowers" and "cardnumber".
I made SQL Reports.
Ideally, it would be possible to configure it in the "circulation overdues report".

-----Original Message-----
From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of George Williams
Sent: Tuesday, May 20, 2025 10:12 PM
To: Koha Community Mailing List <koha at lists.katipo.co.nz>
Subject: Re: [Koha] circulation overdues report

Igor,

I'm assuming that you're using Koha 24.11.  If you are, there are three ways you can make the patron information on Koha's built in Overdues report more secure.

Option 1 -- If your primary concern is having the borrower's name displayed on the screen, but you still want staff to be able to click directly to the borrower's account, you can go to

  * Home > Administration > System preferences
  * Then go to Staff interface preferences
  * Then scroll down to Options
  * Then change the preference "HidePatronName" from "Show" to "Don't show"

This will take the borrower's name off of the report and only show you the card number (which will link to the borrower's account).  It still displays the phone number and has a link to the e-mail address, so this is more secure if your concern is to get the borrower's name off of the screen, but it doesn't go as far as you suggest you want to go in your initial e-mail.

-----

Option 2 -- If you want to remove 100% of the data from the display but still give your staff the option to display the information if needed,

  * Click the Configure tool at the top of the table (this will take you
    to Home > Administration > Table settings > Circulation > Overdues >
    Table id: circ-overdues)
  * Check "Is hidden by default" checkbox in the "patron" row
  * Then click "Save"

This will remove the "Patron" column from the Overdues report, but if a staff member still needs the data, they can still use the "Columns" tool to turn the column back on.

-----

Option 3 - If you want to remove 100% of the data from the display and make it impossible for staff to retrieve it

  * Click the Configure tool at the top of the table (this will take you
    to Home > Administration > Table settings > Circulation > Overdues >
    Table id: circ-overdues)
  * Check the "Is hidden by default" checkbox in the "patron" row
  * Check the "Cannot be toggled" checkbox in the "patron" row
  * Then click "Save"

This removes the "Patron" column from the report and removes the controls for that column from the column configuration tool so that no one can enable the column in the future.

George

On 5/16/2025 7:00 PM, koha-request at lists.katipo.co.nz wrote:
> Send Koha mailing list submissions to
> 	koha at lists.katipo.co.nz
>
> To subscribe or unsubscribe via the World Wide Web, visit
> 	https://lists.katipo.co.nz/mailman/listinfo/koha
> or, via email, send a message with subject or body 'help' to
> 	koha-request at lists.katipo.co.nz
>
> You can reach the person managing the list at
> 	koha-owner at lists.katipo.co.nz
>
> When replying, please edit your Subject line so it is more specific 
> than "Re: Contents of Koha digest..."
>
>
> Today's Topics:
>
>     1. circulation overdues report
>        (Сычев Игорь Алексеевич)
>     2. Re: circulation overdues report (Owen Leonard)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 16 May 2025 02:06:12 +0000
> From: Сычев Игорь Алексеевич<ias at tpu.ru> To:"koha at lists.katipo.co.nz" 
> <koha at lists.katipo.co.nz>
> Subject: [Koha] circulation overdues report 
> Message-ID:<81071ae020024464ada3083a9effd0b5 at tpu.ru>
> Content-Type: text/plain; charset="koi8-r"
>
> Hi!
>
> How can I disable the output of email and phone number from "Patron" in the report?
> https://koha-community.org/manual/24.11/en/html/circulation.html#overd
> ues
>
> Good Luck!
>
> Igor A. Sychev
> Tomsk Polytechnic University
> https://lib.tpu.ru
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 16 May 2025 08:17:47 -0400
> From: Owen Leonard<oleonard at myacpl.org>
> To: Сычев Игорь Алексеевич<ias at tpu.ru> Cc:"koha at lists.katipo.co.nz" 
> <koha at lists.katipo.co.nz>
> Subject: Re: [Koha] circulation overdues report
> Message-ID:
> 	<CAO4qe2NDz+Obww5A6pUE3Dg2EyXoPbHvPGPSuuifow5nYeyoMQ at mail.gmail.com>
> Content-Type: text/plain; charset="UTF-8"
>
>> How can I disable the output of email and phone number from "Patron" in the report?
> The report isn't configurable, and the markup isn't detailed enough to 
> let you hide elements using CSS. Perhaps you could build your own 
> report?
>
> https://wiki.koha-community.org/wiki/SQL_Reports_Circulation#Naughty_O
> verdues
>
> -- Owen
>
-- 

George Williams
(he/him)
Next Search Catalog Coordinator
Northeast Kansas Library System
785-838-4090
gwilliams at nekls.org


  NEXT


          SEARCH CATALOG

<https://nextkansas.org>
_______________________________________________

Koha mailing list  http://koha-community.org Koha at lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


More information about the Koha mailing list