Filtering Portals

[scottvaughan]

I have a portal that links to our main DB. It will list all of the jobs in house for a specific customer. It works great. But I want it to only show jobs that have not shipped. I need to "filter" out everything whose status field ≠ shipped. Any ideas how to do this?

[John Mark Osborne]

In your Interface table, create a calculation field with the value "Shipped" as the formula. You could use a global field but since it global values are removed when you save a clone and can be different on each guest in a multi-user scenario, I think a calculation works best. Then, create a relationship from your Interface table to the Jobs table using the calculation field and the shipping field. Set the relationship operator as not equal (≠). This will display all jobs that haven't shipped.

[elysive]

What if you have a similar problem but want to omit all dates not listed in the original Find criteria?

If I'm searching Jan 06, that would mean month field != Feb Mar Apr May Jun etc. and year field != 07 08 09 etc.

Right now my Find criteria only filters a related table (geography, so all records are listed per filtered geography, but I want to omit records from different dates).

Edited May 22, 2006 by Guest