1 2 Previous Next 24 Replies Latest reply on May 8, 2017 6:00 PM by bigtom

    Filter Portal Using ESQL

    ikimuhammed@gmail.com

      Good Morning,

       

      I'm quite new to FileMaker; would like some help in portal filtering. I recently came across ExecuteMysql function in FileMaker and was interested  using it for my portal filtering.  

      I've got following portal, which grabs some rubbish data

       

      I

       

       

      I've go this portal filter calculation but it doesn't work.

       

       

      When I view this ExecuteSQL in DataViewer it works fine.

       

       

      Can somebody briefly explain how Portal can be filtered with ExecuteSQL. 

       

      Thank you in advance.

        1 2 Previous Next