Can you filter based on Related Data?

I have an events table and I need to filter based on a related field. Can this be done with the new version since no Join has been described

Oreste

Hi,

You can't. This would require adding Joins to the SQL statements and we're not supporting that. Best to get the field/value in the main events table and filter on that.

hth,
-Jason

Hi, I ended up doing this. I used the ID and used the value list to show the second field that was the name, not the id. Works well. Second question. Can you set up the calendar to start out by showing nothing.

Nice, glad that worked.

I think setting a pre-filter that you know will always be false is probably the easiest way to accomplish this, i.e. status = "foo" or something like that, the whole refresh routine that checks the filters is attached to all the scripts/triggers in the navigation so trying to branch those is probably more trouble than this.

The docs on pre-filtering are at the bottom here:

http://www.seedcode.com/pmwiki/pmwiki.p ... 12.Filters