@@ -, +, @@ 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 @@ -919,6 +919,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 %]