[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 he...@bywatersolutions.com changed: What|Removed |Added CC||he...@bywatersolutions.com --- Comment #7 from he...@bywatersolutions.com --- I've had multiple reports recently where a feature like this would be helpful. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 Margaret Hade changed: What|Removed |Added CC||margaret@bywatersolutions.c ||om -- You are receiving this mail because: You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 Ron Houk changed: What|Removed |Added CC||rhouk@ottumwapubliclibrary. ||org --- Comment #6 from Ron Houk --- I like this idea and would find it very useful. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 --- Comment #5 from Andrew Fuerste-Henry --- I filed bug 25971, suggesting the ability to just name a database field, the other day. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 --- Comment #4 from Katrin Fischer --- 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: <> 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? <>. 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: <> 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. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 --- Comment #3 from Christopher Brannon --- (In reply to Andrew Fuerste-Henry from comment #2) > Kicking this around a little more, would it be easier or cleaner to make the > parameter point at a saved report? So, for your example, you'd make one > report that's "SELECT shelfname FROM virtualshelves" and then in your second > report say "WHERE shelfname LIKE <>" For me, that would drive me nuts. If I had to maintain an external report whose sole purpose was to be a list of choices for another report, I would go bonkers trying to manage those. Another way to approach it might be, instead of doing something like <>, we could just reference the table and column, like <>. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 --- Comment #2 from Andrew Fuerste-Henry --- Kicking this around a little more, would it be easier or cleaner to make the parameter point at a saved report? So, for your example, you'd make one report that's "SELECT shelfname FROM virtualshelves" and then in your second report say "WHERE shelfname LIKE <>" -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
[Koha-bugs] [Bug 25173] Create list of parameters to choose from via a query
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25173 Andrew Fuerste-Henry changed: What|Removed |Added CC||and...@bywatersolutions.com --- Comment #1 from Andrew Fuerste-Henry --- I like this idea. There are lots of things I'd like to be able to pull in as a runtime parameter on a report. An approach like this would spare me having to set those up as authorized values and then maintain those auth values when/if the options change. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. ___ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
