Page 1 of 1

Filtering complete events

PostPosted: Fri Jan 04, 2013 4:28 am
by dunumba
Hi, I have a lot of events in the calendar and I'd like to speed up it. I don't need to see all the past events, but only the events of the previous week. I need prefilter events so: DateStart > Get (CurrentDate)-7.
I tried it following the instructions about filtering (creating a new filterglob_5 field, etc.) and it works quite good.
Is there another faster way to do this? Thanks
Damian

Re: Filtering complete events

PostPosted: Fri Jan 04, 2013 10:29 am
by jeffalmquist
Hi Damian,

Thanks for your question. By its nature, the calendar already pre-filters events by date range, showing only those events that match the current view (e.g., day, week, month). So hard-coding a new pre-filter to exclude events that fall outside the viewable range wouldn't change anything because it's already happening.

To improve performance, you might consider filtering by some other attribute, such as 'status' or 'resource'.

Here are some articles that explain how to improve calendar performance:

Calendar Pro 12...
http://www.seedcode.com/pmwiki/pmwiki.p ... ar12.Speed
http://www.seedcode.com/pmwiki/pmwiki.p ... 12.Filters

Calendar Pro 11...
http://www.seedcode.com/pmwiki/pmwiki.p ... ndar.Speed
http://www.seedcode.com/pmwiki/pmwiki.p ... ar.Filters

Let me know if I can help any further.

Jeff

Re: Filtering complete events

PostPosted: Fri Jan 04, 2013 12:17 pm
by dunumba
Thanks Jeff,
I'm using the calendar with many events and no need to show past events.
I got filter in this way:
I created a new field (SampleEvents) "view": Case (DateStart> CalendarInterface :: Today - 15, "Yes", "No"), and another field: filterglob_5 field (CalendarInterface).
I modified the script "Load settings on startup ..." adding some steps.

It works correctly.

But I don't know if this filtering speeds up the calendar: Is it worth filter events in this way?
Thanks,
Damian

Re: Filtering complete events

PostPosted: Fri Jan 04, 2013 12:44 pm
by jeffalmquist
Hi Damian,

Performance and draw speed are determined by the number of events appearing on-screen at any one time. Therefore, pre-filtering events more than 15 days old will have no visible or performance effect on the day and week views. It would, however, reduce the number of events that appear on the month view, if that's what you're going for. You could also reduce the number of on-screen events by filtering out "closed" or "pending" events, for example.

Let me know if there's anything else I can help with.

Jeff

Re: Filtering complete events

PostPosted: Sun Jan 06, 2013 10:07 am
by dunumba
Thanks, Jeff, if pre-filtering events will have no visible effects on the calendar speed, I prefer not to do that. Thanks for your help

Re: Filtering complete events

PostPosted: Mon Jan 07, 2013 10:29 am
by rodmastar
Tell you what I do.. write a piece of Filemaker code to copy purge, even just delete old event files.. My application I have a portal to view the event file or files..Delete all/// even populate new records from my app.. by doing so, it auto increment its Id field anyways... then just refresh SC... see my 7 min demo adding/ RATHER linking its 1 event file/// Seedcodes really going to enhance my telephone answering service application and buz :) Thks SC

http://www.mastar.com/Presentations/OnCalCalendar/QuicOnCallCalendar/QuicOnCallCalendar.html

Re: Filtering complete events

PostPosted: Mon Jan 07, 2013 10:35 am
by rodmastar
...or thinking about this... copy certain older records to a date coded event file. The what if, in the SC app, under Sources, its shows your event file.. like the Yoga example, show these datecode files... if you must just link it in.. I am going to try that one.. haven't gotten to Yoga yet.. even that much of this app but immediate integration cheers

Re: Filtering complete events

PostPosted: Mon Jan 07, 2013 5:31 pm
by pnlawrence
What did he say? :-)