Skip to Content (Press Enter)
UserImage.jpg
Lebogang Ledwaba
23Views
2Comments
SQl statement results
Discussion
How-to

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!!!

0
0
03 May 2018
Copy Link
2020-03-04 14-50-24
Armando Gomes

Hello Lebogang,


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


Thanks

0
0
03 May 2018
Copy Link
2020-09-15 13-07-23
Kilian Hekhuis
 
MVP

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.

0
0
03 May 2018
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.