AnsweredAssumed Answered

Portal Filter ExecuteSQL

Question asked by shirase on Sep 11, 2018
Latest reply on Sep 14, 2018 by Fabrice Nordmann

I have a table like this and a relationship"x"

Screen Shot 2018-09-12 at 11.32.58 AM.pngScreen Shot 2018-09-12 at 11.33.49 AM.png

I want to add a portal in testX1 layout to show distinct values from testX2

so I set the portal filter specify : ExecuteSQL(select distinct * from testX2)

but the portal is blank.

I know I can fix the problem by many other ways, but  I just want to know how I failed.

Besides, I performed the script as "set variable($$x;value=ExecuteSQL(select distinct * from testX2)"

and it shows.

Screen Shot 2018-09-12 at 11.37.42 AM.png

Can I filter records in a portal using ExecuteSQL? Or it is illegal for use?

Outcomes