Hi,
I’m working on a Java program which goal is to read a Lotus Domino user calendar. I’m using NCSO.jar and CORBA. It works fine, but :
I have no problem to read documents in the calendar, I can extract all the informations.
There are two main categories of calendar documents :
-
the “unique” entries : their start date/time is “STARTDATETIME” and end date/time “EndDateTime”. No problem.
-
the “multi” entries (repeated entries), like the 25 December, 1st January, etc : they are unique too, and the STARTDATETIME and EndDateTime are arrays of dates/times.
The problem : I can easily make the query to ask for the “unique” entries between two dates : “STARTDATETIME >= myStartDate AND …” but how can I work with the"multi" entries ?
Today, I’m working with two queries : the first gives me the “unique” entries easily. The second gives me ALL the “multi” entries, and, after that, I have to manually fetch all the results to search for the good entries.
It works but the second query is very slow. Any idea ?
Thx.