https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29201 Owen Leonard <oleonard@myacpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|koha-bugs@lists.koha-commun |oleonard@myacpl.org |ity.org | Status|NEW |ASSIGNED -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29201 --- Comment #1 from Owen Leonard <oleonard@myacpl.org> --- Created attachment 127045 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127045&action=edit Bug 29201: Add option to insert biblio_framework runtime parameter in SQL report This patch modifies the SQL report creation process so that the list of runtime parameters includes an option for bibliographic framework. To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" menu button and select "Bibliographic framework." - You should be shown a modal dialog in which you can change the label on the framework input. - Click "Insert parameter." The SQL field should now contain the correct parameter, e.g. <<Framework|biblio_framework>> - Use the parameter to define an SQL query, e.g. "SELECT * FROM biblio WHERE frameworkcode = <<Framework|biblio_framework>> LIMIT 10" - Run the report. You should be asked to choose a framework. Confirm that the report runs correctly. -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29201 Andrew Fuerste-Henry <andrew@bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #127045|0 |1 is obsolete| | --- Comment #2 from Andrew Fuerste-Henry <andrew@bywatersolutions.com> --- Created attachment 127067 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127067&action=edit Bug 29201: Add option to insert biblio_framework runtime parameter in SQL report This patch modifies the SQL report creation process so that the list of runtime parameters includes an option for bibliographic framework. To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" menu button and select "Bibliographic framework." - You should be shown a modal dialog in which you can change the label on the framework input. - Click "Insert parameter." The SQL field should now contain the correct parameter, e.g. <<Framework|biblio_framework>> - Use the parameter to define an SQL query, e.g. "SELECT * FROM biblio WHERE frameworkcode = <<Framework|biblio_framework>> LIMIT 10" - Run the report. You should be asked to choose a framework. Confirm that the report runs correctly. Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29201 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #127067|0 |1 is obsolete| | --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Created attachment 127117 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=127117&action=edit Bug 29201: Add option to insert biblio_framework runtime parameter in SQL report This patch modifies the SQL report creation process so that the list of runtime parameters includes an option for bibliographic framework. To test, apply the patch and go to Reports -> Create from SQL. - Click the "Insert runtime parameter" menu button and select "Bibliographic framework." - You should be shown a modal dialog in which you can change the label on the framework input. - Click "Insert parameter." The SQL field should now contain the correct parameter, e.g. <<Framework|biblio_framework>> - Use the parameter to define an SQL query, e.g. "SELECT * FROM biblio WHERE frameworkcode = <<Framework|biblio_framework>> LIMIT 10" - Run the report. You should be asked to choose a framework. Confirm that the report runs correctly. Signed-off-by: Andrew Fuerste-Henry <andrew@bywatersolutions.com> Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de> -- You are receiving this mail because: You are watching all bug changes.

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29201 --- Comment #4 from Jonathan Druart <jonathan.druart+koha@gmail.com> --- Pushed to master for 21.11, thanks to everybody involved! -- You are receiving this mail because: You are watching all bug changes.