Passing an ad-hoc list of value to a Koha SQL report as parameter
Channel: l2c2technologies
Date: 13/05/2022

Many Koha users from the sub-continent as well as our client partners are often looking an option to throw a list of values as run-time parameter to Koha's SQL reports and be able to generate a report *only* for the values in the ad-hoc list. While the Reports Plus Plugin from ByWater Solutions does the job quite competently IMHO, the average feedback from Indian users is that they often get confused with workflow plus the fact that they have to give their front desk users additional set of permissions to be able to use the plugin. Based on these inputs, this video is to share an idea how we can address the same by utilizing SQL reports in tandem with jQuery and MariaDB / MySQL's support for regular expressions. A blogpost will soon follow.