Forum | Appery.io

I'm having difficulty getting a where query to work.
When testing one of my own columns it works, ie;

{'Era':{$exists:true}}

Which returns :-

[
{
"Era":"2009",
"createdAt":"2013-06-17 23:11:57.149",
"id":"51bf97bde4b03cd897fb200f",
"_updatedAt":"2013-06-18 19:18:19.705"
}
]

but {'_id':{$exists:true}}
returns :-
{
"status":"400 Bad Request",
"url":"https://api.appery.io/rest/1/db/colle...",
"response":{
"code":"DBSQ210",
"description":"Invalid object ID: 'true'"
}
}

Any ideas why the second line fails?

More strangely, this returns an empty array :-
{'_Id':{$exists:true}}

Response :
[

]

So, In the previous example the response shows that the id field is spelt "id", yet the call doesn't work unless its spelt "Id", but even then the response is incorrect as no records are returned.

Does anyone know what I might be doing wrong?
Thanks!

Hi,

We'll take a look.

It's a bug, will be fixed. Thank you for contacting us!

Thanks for looking into it. Do you have an eta on a fix?
Thanks
p.

Hello! We've reported this problem, but unfortunately for now no eta...