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.