Filtering portal records

[Wayne Irvine]

I have a portal that shows records from another table. They are 'available' or not currently assigned records.

The problem is that the list is too long. I would like to be able to filter the list by entering characters in a Filter field.

The relationship currently looks like this:

Available = yes

I would like something like:

Available = yes 
and
Filter (is a substring of) Productname

I can't for the life of me figure out how to do that.

 

Edited March 16, 2017 by Wayne Irvine

[comment]

The best way to do this would be by filtering the portal, not the relationship. However, this can work only if the number of related records to filter is not too high (say no more than a few thousands). Then you can filter the portal by an expression like:

PatternCount ( Child::ProductName ; Parent::gFilter ) 

or:

Parent::gFilter = Left ( Child::ProductName ; Length ( Parent::gFilter ) )

 

[Wayne Irvine]

Excellent! The option is what I am looking for.