AnsweredAssumed Answered

ExecuteSQL calculation not filtered per customer in portal

Question asked by Stu412 on Mar 9, 2015
Latest reply on Mar 9, 2015 by philmodjunk

Title

ExecuteSQL calculation not filtered per customer in portal

Post

Hi there

I've a lovely SQL calculation on a portal which simply shows a Select Max from a list of values.  

However, on customer AAA it's showing the Max value from the entire table, which happens to be customer BBB.

Does ExecuteSQL somehow circumvent the normal behaviour of portals which is to keep their results specific to the related record upon which they reside?

Just for kicks, I tried inserting a where FKID=PKID within the SQL statement but this resulted in a '?' 

Thanks

Outcomes