Jump to content
Sign in to follow this  
Wayne Irvine

Filtering portal records

Recommended Posts

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 by Wayne Irvine

Share this post


Link to post
Share on other sites

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 ) )

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.