Filter Issue

Support for our integrated Contact Manager, Calendar, and Project Tracker.
Posts: 65
Joined: Wed Dec 16, 2009 9:04 am
PostPosted: Tue Sep 25, 2012 11:57 am
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
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Tue Sep 25, 2012 12:26 pm
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
Posts: 65
Joined: Wed Dec 16, 2009 9:04 am
PostPosted: Fri Sep 28, 2012 11:29 am
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.
SeedCode Staff
SeedCode Staff
Posts: 691
Joined: Mon Feb 28, 2011 2:47 pm
PostPosted: Mon Oct 01, 2012 7:47 am
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

Return to SeedCode Calendar

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: