Error While fetching data Using Execute OQL Statement

0
Hi Team,    I want to return a list from the database so i am using Execute OQL Statement As follow. The Oql Query As :-  SELECT * FROM MyFirstModule.Employee WHERE Name = 'Pavan' . I am getting below error even the Name of Pavan record is been there in the database. 
asked
2 answers
0

I don't think you can select from Employee and also use Employee as return entity. Try creating an NPE, e.g., EmployeeResult with all the required attributes. Also try explicitly naming the attributes you want in the SELECT clause.

answered
0

Hi Sunkara Pavan Kalyan,

 

The issue is by using the SELECT * FROM MyFirstModule.Employee.

 

Select * statement returns all the columns, including the ID column which is generated by Mendix, which is present in the backend and cannot be seen in the entity.

 

I suggest you create another entity that is similar to the Employee entity and manually mention the column names, like Select E.Name , E.Email from MyFirstModule.Employee E

 

You just have to make sure the column names in the query and the attribute names in the result entity match.

 

You should be aware that the results coming from the OQL Java action always create a new object in your case list of objects, so use another entity as the result entity.

 

You can reply here if the issue still persists

 

Hope it helps!! 

 

answered