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

Database bound appointments and recurrence.

1 Answer 82 Views
ScheduleView
This is a migrated thread and some comments may be shown as answers.
Richard
Top achievements
Rank 1
Iron
Richard asked on 26 Jun 2017, 05:11 PM

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

1 Answer, 1 is accepted

Sort by
0
Richard
Top achievements
Rank 1
Iron
answered on 26 Jun 2017, 10:20 PM

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...)

Tags
ScheduleView
Asked by
Richard
Top achievements
Rank 1
Iron
Answers by
Richard
Top achievements
Rank 1
Iron
Share this question
or