Titanium JIRA Archive
Appcelerator Community (AC)

[AC-2712] ACS Places query cannot use "$gt" on updated_at field.

GitHub Issuen/a
ResolutionNeeds more info
Resolution Date2013-08-30T17:41:53.000+0000
Affected Version/sn/a
Fix Version/sn/a
Labelsacs, bug
ReporterYuji ODA
AssigneeWei Kong


My application is working few days ago. But it does not work today. I use $gt on updated_at, see below.
    limit: 1,
    where: {
        user_id: "XXXXXXXXXX",
        thread_id: { "$exists" : false },
        closed: { "$exists" : false },
        updated_at: { "$gt": moment().subtract("minutes", 30).toDate() }
    order: '-created_at'
function (e) {
The console output, below.
ACS Request: { url: "places/query.json", verb: "GET", data: {"limit":1,"where":{"user_id":"XXXXXXXXXX","thread_id":{"$exists":false},"closed":{"$exists":false},"updated_at":{"$gt":"2013-08-27T23:37:11.262Z"}},"order":"-created_at"} })
API returns 200 but result is empty. Not found records. When I removed updated_at condition, there are records.My condition is correct. I am very troubled that it is not available. (Maybe this problem is related TC-2837 and TC-2836.) Please fix. Best regards,


  1. Wei Kong 2013-08-28

    What is the actual value of the timestamp? In our documentation we only support 2013-08-21T04:54:22+0000 or 2013-08-21T04:54:22-0000 Can you please confirm the format of your timestamp? you can also get it from acs admin console log
  2. Yuji ODA 2013-08-28

    The updated_at field value is auto generated by ACS. The actual value example is below. (on ACS admin console) > 2013-08-28T00:54:27+0000 Thank you.
  3. Wei Kong 2013-08-28

    can you please email me your app key and actual query that failed? wkong@appcelerator.com
  4. Daniel Sefton 2013-08-28

    Hi Yuji, Apologies for any inconvenience caused, it should be working now, it would be great if you could post here to clarify. Thanks!

JSON Source