DHTMLX recursive event


I’ve a requirement to schedule a recursive event with DHTMLX and once user scheduled the event, other user can search by date to see if he is available on this date/time.

I’m able to save to database the recursive events without any issue. Now say user#1 scheduled an event and it’s stored in database as below.
Start date:- 2015-03-11 10:00:00.000
End Date:- 9999-02-01 00:00:00.000
Rec Type:- week_2___1,3,5#no

Now user#2 want to see if 2015-03-14 user#1 is available. how to run SQL query to get these details? I’m using sql server 2008 to build my project. can anyone please help.

there is no easy way to get it info from the DB record. It has to be parsed in order to get dates of the occurrences
What do you use on server side? Is it PHP or C# or something different?


Thanks for your reply.

I’m using Java in server side.

hi, unfortunately we don’t have a helper implemented in Java.
You can try parsing the recurring events data manually, the format is described here
docs.dhtmlx.com/scheduler/recurr … ntegration