How to get thenRecurring Records of Schedular

3 posts, 0 answers
  1. farheen
    farheen avatar
    2 posts
    Member since:
    Dec 2010

    Posted 07 Apr 2011 Link to this post

    Hi there,
          I have a schedular which is used for creating appointments for staff.When I create a new appointment with recurrence ie. a staff is having an appointment daily for a week.The recurrence information is stored in schedular table's field RecData like this
    DTSTART:20110407T100000Z  DTEND:20110407T110000Z  RRULE:FREQ=DAILY;UNTIL=20110415T000000Z;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR,SA,SU 

    Now I have a page called as a dashboard with date criteria given ie if the date is selected as 15 April2011 then all the appointments of 15 March 2011 will be displayed.
    Now if i create a recurrence appointment of a particular staff .The recurrence rule is as follows:
    the staff has an appointment daily  from 07 April 2011 to  15 April 2011.
    Now when I come to dashboard & select the date as 20 April 2011 then I can the above created appointment,but when i change the date criteria to 21 April 2011 then there is no Record.So Ideally 
    I want to display the appointment of this particular staff  till 30 April 2011 on My dashboard because i have created a recurrence appointment toll 30 April 2011

    Urgent Help needed

  2. Peter
    Peter avatar
    6637 posts

    Posted 07 Apr 2011 Link to this post

    Hi farheen,

    Please, review the following resources and let me know if you have further questions -

    Kind regards,
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. Sajid
    Sajid avatar
    1 posts
    Member since:
    Mar 2011

    Posted 11 Apr 2011 Link to this post

       I have a schedular which is used to store the staff appointment details.
    I also have a dashboard module which has a grid view control to show all the appointments based on the date criteria given on dashboard.meaning if the date selected is 20 March 2011 ,then show all the appointments on the dashbaord which is Scheduled on 20 March 2011.
    When a new appointment is created then its appoiintment is stored in a table named "AppointmentSchedular".If the appointment is a recursive appointment then the recursive information is stored in RECDATA field of the AppointmentSchedular table as Follows.
    DTSTART:20110411T063000Z  DTEND:20110411T073000Z  RRULE:FREQ=WEEKLY;UNTIL=20110419T000000Z;INTERVAL=1;BYDAY=MO 

    What i want is when a new appointment is created which is recursive,then I need to show the recursive appointment on the grid view on Dashbaord Page.
    Eg:I created a recursive appointment of a staff on 11 April 2011. The Appointment is Daily basis till 15 April 2011.
    So now what i need is, to show this particular appointment from 11 April 2011 to 15 April 2011 on the dashboard.

    Urgent Help Needed...
Back to Top