Bug 25971

Summary: Allow arbitrary database field as runtime parameter
Product: Koha Reporter: Andrew Fuerste-Henry <andrewfh>
Component: ReportsAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low CC: george, lisettepalouse+koha, nick
Version: Main   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29767
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:

Description Andrew Fuerste-Henry 2020-07-09 19:27:07 UTC
Yet another runtime parameter idea, how about allowing a syntax like "SELECT * from accountlines WHERE debit_type_code like <<Pick a code|account_debit_types.code>>"

So Koha then builds the parameter list based on a "select distinct code from account_debit_types"

To make it even nicer, we could allow "<<Pick a code|account_debit_types.code:account_debit_types.description>>" so we use the code as our value but display the corresponding description.
Comment 1 George Williams (NEKLS) 2020-07-09 19:44:13 UTC
Another awesome idea.  I'd definitely like to see this implemented.