1 Reply Latest reply on Feb 27, 2012 10:55 AM by truji_

    Search-Filter portal rows on IWP?

    truji_

      Title

      Search-Filter portal rows on IWP?

      Post

      I have a layout called Students where users can use a field "vEntry" to search for last name and first name on the students_find_view table using the following script:

       

      Set Variable[$entry;Value:Students::vEntry]

      Enter find Mode[]

      Set Field [Students_find_view::lastName;$entry]

      New Record/Request

      Set Field [Students_find_view::FirstName;$entry]

      Perform Find[]

      Refresh Window[Flush cached join results]

       

      The relationship between the tables is Students::SASID x Students_Find_View::SASID. 

       

      the students_find_view portal row is filtered to:

      ($entry=Students_Find_View::LastName)

      or ($entry=Students_Find_View::FirstName)

       

      When I perform the find on Filemaker, the script works. However, it doesn't seem to work on IWP. Am I missing something? is searching on portal rows disabled in IWP? if so, would anybody have an alternate way to do this in IWP?

       

      Thanks in advance.