Page 1 of 1

REST API service where clause on _createdAt

Posted: Mon Aug 11, 2014 10:33 pm
by Mike Maughan

I have a REST API service where clause with $date (accessing _createdAt) and I want to add a $gt so that the response is only rows that were created after a specific _createdAt date/time.

What would the cURL command look like?

Here is where I've been looking for an answer:

http://devcenter.appery.io/wp-content...

http://devcenter.appery.io/documentat...


REST API service where clause on _createdAt

Posted: Mon Aug 11, 2014 11:38 pm
by Illya Stepanov

Hi Mike,

We are working on it, we'll get back to you with an update.


REST API service where clause on _createdAt

Posted: Tue Aug 12, 2014 12:15 pm
by Evgene Karachevtsev

Hello Mike,

Such queries cannot be applied to predefined columns _createdAt and _updatedAt. only to custom ones.


REST API service where clause on _createdAt

Posted: Tue Aug 12, 2014 1:01 pm
by Mike Maughan

Thanks. And as an alternative, is id sequential such that I could find the MAX(id) and it be the most recent entry in the collection?


REST API service where clause on _createdAt

Posted: Tue Aug 12, 2014 1:24 pm
by Evgene Karachevtsev

Mike,

Perhaps, it would be more correct to add the field "time" with time, as in the example, and use described in the documentation methods.