Filter Portal with Value List Value...
I have Contacts::status_contact displaying a value list of active or inactive. I have created a portal and want to only see active contacts.
What 'filter' information do I type to allow this?
If you always want to show only Active contacts:
contacts::Status_contact = "Active"
If you want to be able to select either active, inactive or both:
Format a global field with your value list and as a checkbox group.
Set an OnObjectModify script trigger on it to perform this script:
Refresh Window [flush cached join results]
Use this expression in your portal filter:
ValueCount ( FilterValues ( YourTable::GlobalStatusField ; Contacts::Status_contact ) )
Retrieving data ...