andretru2

Search-Filter portal rows on IWP?

Discussion created by andretru2 on Feb 27, 2012
Latest reply on Mar 6, 2012 by Stephen Huston

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.

Outcomes