Bug 28970

Summary: Create runtime parameters on the fly
Product: Koha Reporter: George Williams (NEKLS) <george>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: cbrannon, dcook, jonathan.field, kebliss, lisette, martin.renvoize, rcoert
Version: unspecified   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description George Williams (NEKLS) 2021-09-07 22:46:13 UTC
I was just thinking how helpful it would be if we could create runtime parameters inside of a report.  What I'm thinking is something like this

WHERE biblio.title LIKE CONCAT("%", <<Title contains one of these words|["good", "box", "friend"]>>, "%")

creating a drop-down that has the three options: free, good, box.

Being able to create parameters would open up a lot of new options with writing reports.
Comment 1 Christopher Brannon 2021-09-08 16:09:36 UTC
+1
Comment 2 Christopher Brannon 2023-12-29 19:36:30 UTC
Maybe a variation of this would be something like:

WHERE biblio.title LIKE CONCAT("%", <<Choose one|["Coeur d'Alene Library|COEUR", "Liberty Lake Library|LIBLAKE", "Post Falls Library|POSTFALLS"]>>, "%")

This iteration would allow you to define what the options look like in runtime, and what value is actually being used.
Comment 3 Rebecca Coert 2024-01-09 17:57:26 UTC
+1 - I'd love to see this functionality added to Koha.