Koha Tutorial Videos
Monday Minutes: Direct Links Built into Reports
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?
Hallmark Background Zooms
Are you ready for a change in your background for Zoom? Checkout this fantastic site:
This totally made our day!
Read more by Jessie Zairo