1 Reply Latest reply on Aug 5, 2011 9:26 AM by philmodjunk

    Filter Portal with Value List Value...

    brianquillin

      Title

      Filter Portal with Value List Value...

      Post

      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?

        • 1. Re: Filter Portal with Value List Value...
          philmodjunk

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