Find all records containing empty FILTERED portal

[crayfish]

Is there a way to do a find for all records that contain an empty filtered portal? The portal is being filtered using Filemaker 11's new portal filter feature.

Or am I going to have to create a filtered relationship in the relationships graph and then do an isempty search? It's a complex filter so I would really prefer not having to do it in relationship graph.

Thanks!

Edited April 19, 2010 by Guest

[LaRetta]

If you have a Main table (with MainID) and Child table (with MainID) and they are joined on = then you can have a portal which is filtered as:

IsEmpty ( Child::text )

But you say it is a complex filter so we probably need more information. :wink2:

[crayfish]

The relationship itself doesn't have any filtering on it. It's a straight up = join between parent and child. The only filtering is happening in the portal itself via the portal filter in LAYOUT mode.

In other words, using isEmpty doesn't work. Now if I went into the relationship and did the filtering on the relationship itself then isEmpty would work. But I'm trying to avoid doing that, hence my question.

It seems as if Filemaker searches from "Find mode" do not take into account if a filter has been placed on top of an underlying relationship.

Is there a workaround, besides changing the underlying relationship?

Edited April 19, 2010 by Guest

[LaRetta]

Ah, yes. Finds on filtered portals do not take into account the filter on the portal. So if you search for = in a field in the portal, it will find ALL parent records with that field empty (that are related based upon the relationship and NOT based upon the filtered portal).

You can place a button inside the portal row and use GTRR (Go To Related Records) and then constrain your found set (which would be your filtered portal results) to those with only blank text field. You could then GTRR back to the parent.

I doubt we can truly offer good suggestions without knowing your current filtering. It is best if you can provide a sample file.

UPDATE: If using GTRR on a portal-filtered portal, GTRR step should be set to 'match current record only" DOUBLE-UPDATE: No, that will only give you the one parent.

Edited April 19, 2010 by Guest
Added double-update

[crayfish]

Thanks for the GTRR record suggestion. That solved the problem!