Hi, i am newbie for lucene search. i have a bit complex query like this:
SELECT mat.name matName,
FROM LIB_MATERIAL mat,
LIB_MAT_TYPE matType ,
LIB_SHELF shelf ,
LIB_ROOM room ,
FZA_PERSON res
WHERE mat.shelf_id = shelf.record_id(+)"
AND shelf.room_id = room.record_id(+)"
AND mat.material_type_id = matType.record_id"
AND mat.reserved_by_id = res.record_id (+)"AND mat.lended_to_id = res.record_id
(+) AND (contains(mat.ft_mat,'book%')>0) ->> full text query fro oracle how
can i write this query for luecene? what is method for adaptation my query with
lucene?
_________________________________________________________________
Windows Live Messenger'ın için Ücretsiz 30 İfadeyi yükle
http://www.livemessenger-emoticons.com/funfamily/tr-tr/
