AnsweredAssumed Answered

Portal Filtering and Case Statements

Question asked by dave317yyc on Aug 5, 2014
Latest reply on Aug 5, 2014 by philmodjunk

Title

Portal Filtering and Case Statements

Post

     Good Day, 

     I am hosting some filemaker databases on Filemaker Server 13.  I run Filemaker Pro 13 to create my layouts, etc.  I use Filemaker Go to access my apps/databases from an ipad.

     I have built an app that is working on well on the server, but when it is accessed from the ipads the portal filtering is EXTREMELY slow.  Can anyone offer a better way of doing this?

     Basically I have a player list.  The player list is shown in a portal under the TEAM layout, and there is a few different filters available for displaying data in the portal.  Currently I have a bunch of CASE statements combined with AND statements for filtering portal results.  I use the following but it is very slow when accessing the data through the WAN, and even pretty slow going over local wifi. 

     What i dont understand is if i display the data in a LIST that is not a portal, and use perform find and constrain find to filter the list, the performance is exponentially faster.  It is more ideal for me to use a portal based on how this app works but if i need to use a list i guess i will figure out a way to do that.

     Please look at my portal filter below and let me know if you have any suggestions.

      

     (TeamList::Rank > Teams::rankStartFilter)
     and
     (Case(Teams::posFilter="IDP-ALL";(PlayerList::Pos="DB" or PlayerList::Pos="LB") ;Teams::posFilter="ALL";True;Teams::posFilter=PlayerList::Pos))
     and
     (Case(Teams::teamFilter="ALL";True;Teams::teamFilter=PlayerList::Team))
     and
     (Case(Teams::availFilter="ALL";True;Teams::availFilter=TeamList::Avail))
     and
     (Case(Teams::dhFilter="0";True;Teams::dhFilter=TeamList::DH))
     and
     (Case(Teams::myTeamFilter="0";True;Teams::myTeamFilter=TeamList::ownerTeamSN))
     and
     (Case(Teams::injFilter="0";True;Teams::injFilter=TeamList::Injured))

Outcomes