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

    Filter Portal Using ESQL


      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'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