Simple OQL query giving null pointer error

0
'SELECT * FROM ModuleName.Project' This simple query giving below error .MendixRuntimeException: java.lang.NullPointerException: Could not find result association modulename$project.ID in target object.   Please help
asked
2 answers
1

Hi Lalit,

 

It would surprise you (as it did me), you can’t use the * (wildcard). 

 

The solution is to name the Attributes you like to select. Here is an example:

'
SELECT
 E.Timestamp Timestamp,
 E.Application Application,
 E.System System,
 E.Model Model,
 E.Location Location,
 E.EnergyContract EnergyContract,
 E.Country Country,
 E.EmissionCO2 EmissionCO2,
 E.EmissionCH4 EmissionCH4,
 E.EmissionN2O EmissionN2O,
 E.kWh kWh,
 E.Platform Platform
FROM
 Emission.EmissionReport E
WHERE
 E.Timestamp >= $TimestampStart AND
 E.Timestamp <= $TimestampStop AND
 E.Application IN $Application AND
 E.System IN $System AND
 E.Model IN $Model AND
 E.Location IN $Location AND
 E.EnergyContract IN $EnergyContract AND
 E.Country IN $Country
 E.Platform IN $Platform
'
 

Go Make It

answered
0

'SELECT 
    P.id Project_Project,
    P.ProjectName
    FROM
    M.Project P'

 

we have to create a self association to access id  

 

answered