[Koha-cvs] koha/C4 SearchMarc.pm [rel_2_2]

[Henri-Damien LAURENT]

CVSROOT:	/sources/koha
Module name:	koha
Branch:		rel_2_2
Changes by:	Henri-Damien LAURENT <hdl>	07/07/16 15:23:18

Modified files:
	C4             : SearchMarc.pm 

Log message:
	Bug Fixing... Search in blob fields too.

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/C4/SearchMarc.pm?cvsroot=koha&only_with_tag=rel_2_2&r1=1.36.2.39&r2=1.36.2.40

Patches:
Index: SearchMarc.pm
===================================================================
RCS file: /sources/koha/koha/C4/Attic/SearchMarc.pm,v
retrieving revision 1.36.2.39
retrieving revision 1.36.2.40
diff -u -b -r1.36.2.39 -r1.36.2.40
--- SearchMarc.pm	28 Feb 2007 09:18:26 -0000	1.36.2.39
+++ SearchMarc.pm	16 Jul 2007 15:23:18 -0000	1.36.2.40
@@ -613,7 +613,7 @@
 		$maxtag = "399";
 	}
 
-	my $sth=$dbh->prepare("SELECT subfieldvalue,tag FROM marc_subfield_table WHERE bibid=? AND tag BETWEEN ? AND ? ORDER BY tagorder");
+	my $sth=$dbh->prepare("SELECT IF(m2.blobidlink IS NOT NULL,m2.subfieldvalue,m1.subfieldvalue),tag FROM marc_subfield_table m1 LEFT JOIN marc_blob_subfield m2 on m1.valuebloblink=m2.blobidlink WHERE bibid=? AND tag BETWEEN ? AND ? ORDER BY tagorder");
 
 	$sth->execute($bibid,$mintag,$maxtag);