As good as EE is, I find it pretty unfathomable that you can’t access the custom fields in the calendar view.  In my opinion this is mandatory, WHY!!!??  Does Mr. Wilson’s hack still work, for all I can tell that file has changed drastically. Please do this asap, or let me know if there is a workaround for 1.6.3

It’s strictly a performance issue, tcfleck.  For some data sets, it wouldn’t cause a problem, but for content-heavy sites with frequent entry intervals (say a news site as an example, with 30+ articles per day), then fetching that much data (nearly 900 entries) could be unpleasantly intensive, particularly since the calendar in most cases does not even make up the primary content of the page.

Okay but that doesn’t exclude the necessity to allow people (not running news sites) who would like to have a upcoming event calendar, to display custom fields related to each event.

If there is a workaround that works with EE 1.6.3 I will gladly shut up about this and use it. I just can’t find one.

You could always use an embedded template and pass the entry_id to a streamlined weblog entries tag (or even the query module for a truly lightweight approach if you don’t mind referencing the field_id_# directly).  If your dataset is light, and you implement caching mechanisms appropriately, it could be a perfectly acceptable solution.

I’m not a php wiz.  Could you expand on what this would entail.  Heres an example of the type of thing I would like:

http://www.nectarlounge.com/calendar.html

Since the rest of the site I am developing is in ee, it seems perfectly reasonable for ee to handle this.

My suggestion would not use PHP at all, simply the embed tag with an embed variable to pass the {entry_id} from the calendar tag to the embedded template.

The embedded template could contain either a weblog entries tag, using the entry_id= parameter with the embedded variable:

Or the query module, which would use a direct SQL query:

I think I follow. How would I then get that to output to the calendar tag.

The embed tag would go inside your calendar tag on the parent template, within the {entries} tag pair.

Oh that seems preeeety simple.  I’ll try it this evening and see if I can get it to work. Thanks.

DEREK! MY BUDDY! you sir are a genius, it works flawlessly.  Thank you much.

Okay now I have a different problem, perhaps more severe.  When I do this, the future entries do not show up.
If I use the embed, it only respects past, and present events.  Any ideas?

Glad to be of assistance, tcfleck.  What is the full code you are using in the embedded template?

nevermind you need the show_future_entries on the entries tag in the embedded template

Correct, and I would add the dynamic= and disable= parameters too, as demonstrated in my sample tag above.

Will do.  Thats for performance correct?

The disable one, yes. dynmiac=“off” will ensure that that nothing in the URL will actually override the tag.

Any chance I can get help with a similar query to Derek’s above, but more complex?

I’m using the Free Form plugin from Solspace to setup a standalone edit form, and I’m using the Multiple Site Manager as well, to create several nearly identical sites, each with a calendar, among other things.

So, instead of using Status to allow members to close events via the SAEditF, which won’t work because Free Form is not able to work properly with the MSM, I’m using a custom field which basically says, Close this Event? And if the member selects “Yes,” the entry does not display.

Anyway, I still need to display the title in the calendar, so I need the query to get the title from one table, and the custom field value from the other table.

And, since I suck at MySQL, I’m asking for help with this query.

Any takers?

Thanks in advance!
Ken