Monday Minutes: Report Paramaters

by Jessie Zairo on Oct 7, 2024

In this week's Monday Minutes, Nick and Jessie discuss and show two enhancements in the 24.05 release that help with report writing. Thank you to the Koha Community and Brendan Lawlor, Systems Manager at CLAMS, Inc. for pushing these enhancements forward!

The first enhancement is Bug 35746, when a dropdown selection is used in something like an IN statement in WHERE, Koha now allows you to select multiple options. The second enhancement is Bug 35856, it now makes it easy to include the "All" option in runtime parameter in reports.

Bug 35746 - Multiple selections for parameters used in the IN function

Bug 35856 - Runtime parameter modal should provide option of ":all"

Paramater Options

Multiple selections for parameters used in the IN function

This adds the syntax to the report allowing you to select multiple authorized values when you run the report.

example: <<Select item types|itemtypes:in>>

Runtime parameter modal should provide option of ":all"

This adds radio checkboxes to the reports runtime parameter modal for adding param options :all and :in.

example: <<label|authval:all>>

Example Report

SELECT

title,

author,

itemcallnumber,

barcode,

itype,

lib AS "Lost status"

FROM

items

JOIN

biblio USING (biblionumber)

LEFT JOIN

authorised_values ON items.itemlost = authorised_values.authorised_value AND authorised_values.category = 'LOST'

WHERE

items.itemlost IN <<Lost status|LOST:in>> AND items.itype LIKE <<Item type|itemtypes:all>>

ORDER BY

items.cn_sort

Additional Resources

Self Paced Learning in Koha: Reports

New Director: Reports