AnsweredAssumed Answered

Portal filter script

Question asked by feait on Nov 28, 2013
Latest reply on Nov 28, 2013 by philmodjunk

Title

Portal filter script

Post

     Hi

     I have a portal to another table in my file. I want it to filter the results by a partial search match.

     If the "room number" of the entry appears within the "adjoining rooms" field of the related table I want the entries to be displayed in the portal.

     The script I currently have set is:

     PatternCount ( Door Schedule::Adjoining Rooms ; Room Data Sheets::ROOM NO ) > 0

     This is working when the adjoining rooms has the room no within it exactly with no spaces and with each entry on a new line

     Eg.:

     G-01

     G-02

      

     I want to ensure it works if it's entered with a space rather than a return

     Eg.:

     G-01 G-02

      

     Any ideas?

      

     Thanks

     Ivan

Outcomes