This is a migrated thread and some comments may be shown as answers.

How to get completed tasks list based on date using sql query

1 Answer 14 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
ashok
Top achievements
Rank 1
ashok asked on 23 Sep 2013, 07:14 PM
Actually I am using scheduler where I can track child activities, child will attend the activities or if he doesn't attend we can delete that task on that day.

As of now my I am able to do all these tasks using the scheduler control.

My problem is :

Per task we will charge some amount based on child age, I need to do these calculations in a database based on child attendance.
I need a database query to get child completed tasks based on date wise. If I can get these in table format in the database and I can do above logic.

As of now In Appointments table has a data in single line format (DTSTART:20130916T093000Z
DTEND:20130916T103000Z
RRULE:FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR
EXDATE:20131008T093000Z,20131010T093000Z ). I need a query where I can get same gird data in the database.

1 Answer, 1 is accepted

Sort by
0
Plamen
Telerik team
answered on 26 Sep 2013, 01:49 PM
Hello Ashok,

 
You can refer to this blog post where is shown how you can work with recurrence Appointments on the SQL.

Hope this will be helpful.

Regards,
Plamen
Telerik
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
Tags
Scheduler
Asked by
ashok
Top achievements
Rank 1
Answers by
Plamen
Telerik team
Share this question
or