@@ -, +, @@
1 - Write a report:
SELECT branchname FROM branches WHERE branchcode LIKE <>
2 - Run it
3 - Select a branch
4 - You get one branch info
5 - Note you cannot select all
6 - Apply patch
7 - Run report
8 - No change
9 - Update report like:
SELECT branchname FROM branches WHERE branchcode LIKE <>
---
C4/Reports/Guided.pm | 1 +
.../prog/en/modules/reports/guided_reports_start.tt | 1 +
reports/guided_reports.pl | 11 ++++++-----
t/db_dependent/Reports/Guided.t | 6 ++++--
4 files changed, 12 insertions(+), 7 deletions(-)
--- a/C4/Reports/Guided.pm
+++ a/C4/Reports/Guided.pm
@@ -903,6 +903,7 @@ sub GetParametersFromSQL {
for ( my $i = 0; $i < ($#split/2) ; $i++ ) {
my ($name,$authval) = split(/\|/,$split[$i*2+1]);
+ $authval =~ s/\:all$// if $authval;
push @sql_parameters, { 'name' => $name, 'authval' => $authval };
}
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/reports/guided_reports_start.tt
@@ -701,6 +701,7 @@ canned reports and writing custom SQL reports.
[% ELSE %]