SQl statement results

Hi All

I'm running an sql statement widget to get list of contact's email, amongst other things. On preparation the list have all values, as shown below, and I have combo-box that is populated by the resulting list. When I select a contact, ConactRelationshipId is zero which was not the case previously(1st and 2nd pics). And even when I assign it to the record list other values are missing(last pic below). Problems highlighted below.

Please help!!!

Hello Lebogang,

Can you please share an OML file with what you're doing?


Hi Lebogang,

This is likely the effect of the Platform's optimizer. Quite often, when you don't use certain values in a certain environment, they're optimized away, which results in the debugger showing empty values. That doesn't mean they're not actually there.