Page 1 of 1
Filter Issue
Posted:
Tue Sep 25, 2012 11:57 amby kaostika
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
Re: Filter Issue
Posted:
Tue Sep 25, 2012 12:26 pmby JasonYoung
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
Re: Filter Issue
Posted:
Fri Sep 28, 2012 11:29 amby kaostika
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.
Re: Filter Issue
Posted:
Mon Oct 01, 2012 7:47 amby JasonYoung
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