Closed Inlustra closed 6 years ago
Your DBSurvey
model doesn't seem to have an event
column, perhaps you missed it?
My bad, it is there! I just missed it from the comments :)
In new Select().from(DBSurvey.class).where("event=?", id).execute();
, the id
variable corresponds to Id
or _id
? getEntityId
isn't shown in your code snippet.
So I have quite a complex SQL Structure, but for a small example:
The following Query always returns empty. And it's only with this model, my other model works fine.
However, if I do:
I get the correct objects. Any help is appreciated. I realize that event is a keyword in regular sql, however it is not in SQLLite and I have changed the name to event_id to no avail.