Bug 25971 - Allow arbitrary database field as runtime parameter
Summary: Allow arbitrary database field as runtime parameter
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Reports (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-07-09 19:27 UTC by Andrew Fuerste-Henry
Modified: 2021-12-23 13:24 UTC (History)
3 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.