[Koha-patches] [PATCH] Bug 6602 - Reports dictionary doesn't properly recognize text columns

Owen Leonard oleonard at myacpl.org
Tue Nov 20 19:55:07 CET 2012


Reports dictionary won't let you set a comparison for MEDIUMTEXT columns. To
test, choose a MEDIUMTEXT column like borrowers.surname in Step 3 of adding
a new dictionary definition. Before the patch, in Step 4 you would not see
any kind of form field for entering a comparison. After patching Step 4 will
offer you a field labeled "Search string matches."
---
 reports/dictionary.pl |    2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/reports/dictionary.pl b/reports/dictionary.pl
index aae96c9..f27ce10 100755
--- a/reports/dictionary.pl
+++ b/reports/dictionary.pl
@@ -108,7 +108,7 @@ elsif ( $phase eq 'New Term step 4' ) {
         if ( $type eq 'DATE' || $type eq 'DATETIME' ) {
             $tmp_hash{'date'} = 1;
         }
-        if ( $type eq 'TEXT' ) {
+        if ($type eq 'TEXT' || $type eq 'MEDIUMTEXT'){
             $tmp_hash{'text'} = 1;
         }
 
-- 
1.7.9.5


More information about the Koha-patches mailing list