data does not match

0
what's wrong with this, I'd like to make a query with OQL using a variable as a condition in where. and the data does not appear according to where
asked
2 answers
2

Hi,

variable should be used like this:

 

'select e.CustomerName from MyFirstModule.EntityApiLoadNotice e 

where e.CustomerName='+$CustomerName

answered
1

Hi,

I think there ‘as’ is missing

 

try to use this

 

‘select e.CustomerName from MyFirstModule.EntityApiLoadNotice as e 

where e.CustomerName=$CustomerName’

answered