lucene-java-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From emre akgün <emreak...@hotmail.com>
Subject Building Query
Date Wed, 26 Nov 2008 08:16:05 GMT

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/
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message