Database bound appointments and recurrence.

2 posts, 0 answers
  1. Richard
    Richard  avatar
    14 posts
    Member since:
    Jun 2013

    Posted 26 Jun Link to this post

    Hi!

    I've been browsing the forum looking for an answer to my problem and found this one: http://www.telerik.com/forums/get-recurrence-appointments-by-timespan.

    What I gather from the first part of that thread is that if I want to show the appointments for the week of, say, july 8th -july 14th next year, and populate it with the occurrences produced by an main appointment starting this week, I still have to find this main appointment to figure out what occurrences to show...

    Is there some preferred strategy to do this suggested by previous experiences, other than just browse my whole appointments database and check each and every one having a recurrence pattern to see if I should show its occurrences?

     

    Thanks in advance!

     

    Miguel Pinkas

  2. Richard
    Richard  avatar
    14 posts
    Member since:
    Jun 2013

    Posted 26 Jun in reply to Richard Link to this post

    Solved!

    Indeed, I added a filter to my db query to get me all the main appointments with recurrence older than the highest visible date. Almost no difference in performance (so far... let's see what happen when that table grows big... I guess I will clip the older dates and move them forward as I go for the recurrences without an end date...)

Back to Top