AnsweredAssumed Answered

Filtered portals still contain records, they are just "hidden".

Question asked by dhafitch on Aug 28, 2011
Latest reply on Aug 29, 2011 by LaRetta_1

Summary

Filtered portals still contain records, they are just "hidden".

Product

FileMaker Pro

Version

11.0v4

Operating system version

Mac OS 10.6.8

Description of the issue

Thinking that portal filtering omits records from a found set, I set up a script to retrieve values from records in a filtered portal.  However, the script retrieved ALL the records, including those that were "filtered out" by the portal filter.  Thus portal filtering does not work to limit records for script steps.

Steps to reproduce the problem

Use portal filtering to "remove" records from a portal, such as Line Items. You can even filter out ALL records.  Then use the Go to Portal Row script steps in a script to retrieve records.  You will find that even the portal records that are supposed to be hidden are retrieved.

Expected result

One would have thought that, if you can't see the portal records in the portal, they should not be retrievable via the Go to Portal Row script steps!

Exact text of any error message(s) that appear

No error message.

Workaround

You have to design Find scripts to not only find records, but then omit those. Do NOT use portal filtering if you want to limit your selection of portal records in scripts.  This seems not to be well documented.  There should be warnings all over the place about filtering just being a means to "hide" records which, however, are really still there!

Outcomes