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

How to display scheduler data in a table format based on as of date (Improtent)

3 Answers 17 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
ashok
Top achievements
Rank 1
ashok asked on 17 Sep 2013, 03:16 AM
Hi Friends,

I am able to store scheduler data in a table, I need to write a query where I can get today tasks. But recurrence data are stored in formula (
RRULE: FREQ=WEEKLY; INTERVAL=1; BYDAY=MO, TU, WE, TH, FR  ) it will support by only scheduler control.

My requirement is I want to display today tasks in a table format based on scheduler data. I can't use the scheduler control in that place.

Kindly help me.

3 Answers, 1 is accepted

Sort by
0
Plamen
Telerik team
answered on 19 Sep 2013, 06:01 AM
Hi,

 
You can refer to this KB where the issue have been implemented. In addition I am glad to announce that in the upcoming Q3 release we are introducing the Agenda View where you will be able to observe the appointments in a table like list.

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.
0
ashok
Top achievements
Rank 1
answered on 21 Sep 2013, 10:25 AM
Thank you for your information and support.

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.





0
Plamen
Telerik team
answered on 25 Sep 2013, 01:21 PM
Hello,

 
As far As I could understand you want to save the occurrences in the DataBase. The only way to achieve such behavior is described in this blog post.

Hope this information will help you solve the issue.

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
ashok
Top achievements
Rank 1
Share this question
or