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.

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.

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?

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