FM 11 Filtered Portal Question

[K1200]

In FM 11, can a portal be set up to filter for:

Table::TextField contains the word abc somewhere in the field

... or is it limited to exact matches? (Table::TextField = "abc")

Thanks in advance for any help.

[bruceR]

It's a calculation; can be pretty much anything you want. Some calcs may present performance problems. But yes, patternCount( someTO::someField; "ABC") would work.

[Jeff Hannes]

A related question... Maybe I'm missing something obvious, but it's driving me crazy. Is it possible to do dynamic portal filtering? That is, the filter is based on the contents of a global field, and as the field changes, the filter changes. Following the example above, I've tried:

patternCount(relatedTable::someField, relatedTable::xFilter) > 0

as well as 

patternCount(relatedTable::someField, parentTable::xFilter) > 0

and no luck at all. Like similar issues I've had with stored/unstored calculations, it works ONCE -- when you first create the Portal Filter. But then when you change the xFilter field, the portal filtering is unaffected.

Is it possible the calculation generated by Portal Filtering is a stored calculation? If so, this makes the new feature completely useless to anyone who has experience creating their own filters via additional relationships. I mean, in those cases at least I can make the filter dynamic.

It really seems like I'm missing something here. If so, can anyone tell me what it is?

[Squeaky Data]

To update the filtered portal you need to trigger a script to (Refresh Window[Flush cached join results])