Monday Minutes: Direct Links Built into Reports

by Jessie Zairo on Nov 7, 2022

In this week's Monday Minutes, Kelly and Jessie show off the new direct links built into the reports module.

A new feature is introduced in 22.05 which will allow direct links to viewing and editing from within the results of a report.

In the Koha Reports Module, if a report includes certain columns, the data in the columns will automatically offer a menu of options.

For example, if the report includes

borrowernumber: Actions will include View, Edit, and Check Out

cardnumber: Check Out

Itemnumber: View and Edit

Biblionumber: View and Edit

Example SQL

Here is the example SQL that was provided to give an example of how each of these would work in the Report:

SELECT biblio.biblionumber , biblio.title, items.itemnumber,
items.itemcallnumber, items.barcode, borrowers.firstname,
borrowers.surname, borrowers.borrowernumber, borrowers.cardnumber
FROM issues
LEFT JOIN borrowers ON borrowers.borrowernumber=issues.borrowernumber
LEFT JOIN items ON issues.itemnumber=items.itemnumber
LEFT JOIN biblio ON items.biblionumber=biblio.biblionumber
ORDER BY RAND() LIMIT 50

Feel free to copy this to your Koha Saved Report Module, and see the actions that will appear.

There is nothing to turn on for this to work, just including any/all these columns will now produce the actions listed above.

Want more 22.05 information?

Koha 22.05: Upgrades Hub

Hallmark Background Zooms

Are you ready for a change in your background for Zoom? Checkout this fantastic site:

Hallmark Zoom Backgrounds

This totally made our day!