Hello!

Could not you help me?
I have a task:
There are two entities:
1) Task with text field "title"
2) TimeInterval with two fields "start", "and" type of DateTime

Task is linked with TimeInterval as 1:n (one to many)
I have to look for task by
1) text in title
2) date contained in some interval
It's T-SQL analogue:

select t.* from tasks where
CONTAINS (t.[text], "lucene custom search")
exists (select ti.intervalId from time_intervals ti where ti.begin <= '2009/01/28' and ti.end >= '2009/01/28')

How do ia have to create index and search criteria?



--
С уважением,
Ахмеджанов Наиль
Начальник отдела разработки ПО на базе Microsoft.NET
Компания Элевайз
e-mail: ach...@elewise.com


---------------------------------------------------------------------
To unsubscribe, e-mail: java-user-unsubscr...@lucene.apache.org
For additional commands, e-mail: java-user-h...@lucene.apache.org

Reply via email to