Hi Angela. It is possible, it just depends on how you have currently set things up, and how you are planning to do things. Are you using the standard overdue reports, or do you have a custom SQL report that is run regularly? Standard overdue reports ---------------------------------- There are standard overdue reports available in the staff interface (Staff interface > Circulation > Overdues section > Overdues + Overdues with fines
then select the fields to filter the results).
If you are using these reports, then separating out overdue items for children should be relatively easy - depending on how you plan to do things, for example having a patron category for children or item types specifically for children books. For example, a public library might have: - different patron categories for adult and child patrons (there may be a limit on the number of items that they can have out at once) - different item types for materials you have (for example: Books, Magazines, DVDs, Reference, Music, etc; and rental fees if you have these for some items) - circulation and fine rules (for example: items issued for 3 weeks, no fines, etc) As you are a small library, I'm assuming these are all pretty straight forward (famous last words!). Custom SQL report -------------------------- If you are using a custom report in Koha, it should be possible to adapt it to do what you want. It will depend a little on how your Koha system is set up (including the patron categories and item types that you use). If you are using a custom SQL report already set up for you, I would suggest sharing: 1. The SQL for the report you currently use (Staff interface > Use saved > for the report you currently use, select Edit from the Action column). That would give everyone a better idea of how things are set up. 2. The patron category codes you use (Staff interface > Administration > Patrons and circulation > Patron categories) - some assumptions here: - you are going to use a separate category for children patrons - you currently have patron categories for adult patrons 3. Some basic information on how you categorise and organise things, and mange circulation and following up overdue items. For example, patrons each have an account on the system and a card number, the item types you use, how you issue your items, how you follow up on overdue items (for example, ringing), and so on. The existing report will probably give us some of this information. 4. The version of Koha you are using (Staff interface > About Koha > Server information tab > Koha version) - the database structure can change between versions. My SQL skills are pretty basic, but hopefully someone on the list can help. Other questions --------------------- If none of this makes sense, feel free to ask any other questions! David Nind Oamaru New Zealand On Sun, 29 Oct 2023 at 11:13, Angela Davies <adavies@chch.planet.org.nz> wrote:
We are a small volunteer library and so different people use the Koha system.
I have already been using an overdue report, but until now we have only issued adult books through the computer. Starting in January children's books will be added.
Is there a way to have an overdue report for adults only and a separate listing for children's issues? None of us are able to create or understand computer programming so we need very simple instructions.
Thank you for any help
Angela Davies Opawa Library Christchurch
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha