Hi,
I did not receive a reply on this post which I did on Apr 9 2011 Saturday. I think this post went unnoticed. Here is a forward of it:
We have a scenario where we need to filter events based on start_date and end_date using SQL
- For fetching events for a particular date
- For fetching event for a particular date range
Suppose for example, I have created a recurring event for the time period 9 AM to 10PM on April 2 and repeat it every month till Dec 31, 2011. We noticed that the data is stored in the DB (we are using PostgreSQL) as a single record with column values as shown below:
start_date: 2010-04-02 09:00:00
end_date: 2011-12-31
rec_type: month_1__#
As DHX is NOT storing the individual event under the recurring events as separate records, we were not able to filter the events correctly if searched for April 2 or April 3.
We need to retrieve the event from DB when April 2 is given as filter and DO NOT retrieve the event when April 3 is given as the filter.
Usually for the single independent events, we check whether the event date we want to filter falls between the start and end date. But this logic won’t work for recurring events as the rec_type carries additional info (as an expression) in text format.
Is there any mechanism to parse this DHX custom expression in rec_type so that we can use it in our stored procedure to handle the SQL filtering
(for April 2 and April 3 as we have mentioned in the above example)?
We would appreciate if you could help us out on this issue
Regards,
Terence George