AnsweredAssumed Answered

Filter Portal Using ESQL

Question asked by on May 8, 2017
Latest reply on May 8, 2017 by bigtom

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.