Customized List Views
By omnecon on Friday, 10 January 2014
Posted in Pre-Sales
Replies 1
Likes 0
Views 1K
Votes 0
Hello !! For our large scale EventCalendar we are tryping to optimize jEvents, and strip out the internal event multiplication for repeats. The approach is to add extra attributes for the Dates on which the event occurs, and save the dates in a seperate database table.

Basically we need a list-view, that displays a set of events which we "selected" from the database. So i need to edit the query (dynamically of course) which would be the base for the displayed events. Do you have any documentation which would help me out to realize this?

-

ALSO we need to have the MAP, which shows a specific event-set, based on a manual sql-query, which is maybe the same kind of hack !!

best regards, Michael Strasser
Hi Michael - we do store the repetitions and exceptions in a separate database table to the event desciptions and titles etc.
Or are you thinking of a table with a table of all possible dates with references to the events that occur on them. If so I have experimented with this approach to optimising the database queries but didn't find it any faster

The base table is the vevent table, details are in the details table, repetitions in the repetitions table, rrule in the rrule table, exceptions in the exceptions table - the field names should allow you to generate the joins you need. For an example take a look at the components/com_jevents/libraries/dbModel.php file

If you do find a faster way to generate the list of events that fall within a time window I would be very interested in testing out your code.
geraint
·
Friday, 10 January 2014 09:30
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post