I have a table like this and a relationship"x"
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.
Can I filter records in a portal using ExecuteSQL? Or it is illegal for use?