AnsweredAssumed Answered

Portal filter script

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


Portal filter script



     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





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


     G-01 G-02


     Any ideas?