@@ -, +, @@ names 1 - Write a report like: SELECT cardnumber FROM borrowers WHERE cardnumber LIKE '%9' 2 - Run report 3 - Note you can batch modify the patrons 4 - Update report: SELECT cardnumber AS library_barcode FROM borrowers WHERE cardnumber LIKE '%9' 5 - Run report 6 - Note batch options are no longer present 7 - Apply patch 8 - Run report, no change 9 - Update report like: SELECT [[cardnumber|library_barcode]] FROM borrowers WHERE cardnumber LIKE '%9' SELECT cardnumber FROM borrowers WHERE cardnumber LIKE '%9' http://kohadev.mydnsname.org:8080/cgi-bin/koha/svc/report?id=1 http://kohadev.mydnsname.org:8081/cgi-bin/koha/svc/report?id=1 --- .../prog/en/modules/reports/guided_reports_start.tt | 18 +++++++++--------- opac/svc/report | 1 + reports/guided_reports.pl | 16 ++++++++++++++-- svc/report | 1 + 4 files changed, 25 insertions(+), 11 deletions(-) --- 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 @@ -737,7 +737,7 @@ canned reports and writing custom SQL reports.

[% # Preserve the whitespace of the following textarea in order to format the values correctly %] - @@ -745,7 +745,7 @@ canned reports and writing custom SQL reports.

[% # Preserve the whitespace of the following textarea in order to format the values correctly %] - @@ -754,7 +754,7 @@ canned reports and writing custom SQL reports.

[% FOREACH result IN results %] [% FOREACH cells IN result.cells %] [% place = loop.index %] - [% IF header_row.$place.cell == 'itemnumber' %] + [% IF header_row.$place.cell == 'itemnumber' || header_types.item(header_row.$place.cell) == 'itemnumber' %] [% SET batch_itemnumbers = 1 %] [% END %] @@ -768,7 +768,7 @@ canned reports and writing custom SQL reports.

[% FOREACH result IN results %] [% FOREACH cells IN result.cells %] [% place = loop.index %] - [% IF header_row.$place.cell == 'itemnumber' %] + [% IF header_row.$place.cell == 'itemnumber' || header_types.item(header_row.$place.cell) == 'itemnumber' %] [% SET batch_itemnumbers = 1 %] [% END %] @@ -780,7 +780,7 @@ canned reports and writing custom SQL reports.

[% FOREACH result IN results %] [% FOREACH cells IN result.cells %] [% place = loop.index %] - [% IF header_row.$place.cell == 'biblionumber' %] + [% IF header_row.$place.cell == 'biblionumber' || header_types.item(header_row.$place.cell) == 'biblionumber' %] [% SET batch_biblionumbers = 1 %] [% END %] @@ -791,7 +791,7 @@ canned reports and writing custom SQL reports.

[% # Preserve the whitespace of the following textarea in order to format the values correctly %] -
@@ -804,7 +804,7 @@ canned reports and writing custom SQL reports.