Page 1 of 1

Cannot query from JobBoardPost entity

Posted: Wed Jan 15, 2020 12:14 pm
by dreameral
I sent a POST request to ... bBoardPost with the following JSON in the body of the request:

"where": "id is not null",
"fields": "location",
"count": 500,
"start": 0

The issue happens only when the field 'location' is included to fields. The response we get is as below:

"errorMessage":"javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute query",

We need a general solution for this, we can't go and hard code stuff, to not include the 'location' in the fields, or for other issues the API may have.

The location field is of type 'TO_ONE', but also the 'owner' field is of type 'TO_ONE' and that works just fine.