[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173

--- Comment #4 from Katrin Fischer <katrin.fischer at bsz-bw.de> ---
I like the idea, independent of syntax, it might be nice to give an option for
a description showing different to the values it adds to the query.

Something like:
<<List|(SELECT shelfnumber, shelfname FROM virtualshelves)>>

First column will be used for the query and as description, if no second column
exists. So the second parameter could be made optional, if that makes sense?

<<List|virtualshelves.shelfnumber, virtualshelves.shelfname>>.

I can see that the first syntax would give us a bit more flexibility. Like one
could create a list of all shelving locations actually in use:

<<List|SELECT distinct location from items ...>>

And also allowing to pull in a second table for getting descriptions.

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.