Portal Filter with multi value Variable
I am simplifying a function in a Filemaker solution. In the final solution it wasn't working so i've made it in a new file. It's a portal which shows al people based on a Constant (all records). If the designated variable is available the portal filters the values. With one value there is no problem but when there are more it breaks down. I hoped it would work just like in relations when there are more values but with filters it just not seem to work.
Am i doing something wrong? Or isn't it possible?
Option 1 put your return separated list of value in a field instead of a variable and use the field as one of the match fields in the relationship.
Option 2; use the filtervalues function in your portal filter expression:
Not IsEmpty ( FilterValues ( $$PersonID2 ; Person::PersonID ) ) )