Converting FM11 Filtered Portal to Found Set

[Codeus]

Hi,

I was wondering if anyone had come up with an easy way to convert a filtered portal set in to an actual found set (short of doing a new find etc).

The fields I am filtering on are unstored-calculation fields and not really suitable for old-school relationship-based filtering.

[David Jondreau]

In the portal filter build a $$var with the PK of the valid children.

The filter calc can be:

Let($$list = List( If( test; Child::PK);$$List);

test)

The you need a new field in the parent table, either global field set to $$list or an unstored calc field = $$list.

Make sure you clear $$list on RecordEntry.

Build a new relationship from the parent to the child and use a GTRR.

Edited October 22, 2010 by Guest

[bruceR]

Hi,

I was wondering if anyone had come up with an easy way to convert a filtered portal set in to an actual found set (short of doing a new find etc).

The fields I am filtering on are unstored-calculation fields and not really suitable for old-school relationship-based filtering.

Just put a button in the portal to go to related records.

If the button is NOT in the portal, or a GTRR script is called while the portal is not the selected object, you would get the unfiltered record set.

[Codeus]

Thanks for the response, that's just what I needed.