AnsweredAssumed Answered

Filter Portal Using ESQL

Question asked by ikimuhammed@gmail.com 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

 

 

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.

Outcomes