Apigee App Services/Usergrid query not returning results as expected

Question

I created a container called /courseattendees with the following payload:

{
  uuid: "972a794a-8312-11e3-b1ca-b531afb5f461"
  type: "courseattendee"
  created: 1390360162004
  modified: 1390360162004
  badge: "blank.png"
  course: "7d4b97ea-82e3-11e3-bfff-179577f046a1"
  coursestart: "4850ef54-82fc-11e3-b496-c959b35bdbdf"
  email: "[email protected]"
  metadata: {
    path: "/courseattendees/972a794a-8312-11e3-b1ca-b531afb5f461"
  }
  status: "registered"
}

I can query other elements like email but I can't query coursestart (I orignally called it coursedateuuid but renamed it thinking that the uuid part of the name was causing some background indexing).

Is there some kind of special escaping or trick when I'm referencing a uuid formatted element?

Here's my query:

https://api.usergrid.com/apigeetraining/contentapi2/courseattendees?ql=select * where coursestart = '4850ef54-82fc-11e3-b496-c959b35bdbdf'

(Needs authorization)

Answer 1

coursestart is of type UUID, so you don't need the single quotes:

https://api.usergrid.com/apigeetraining/contentapi2/courseattendees?ql=select * where coursestart = 4850ef54-82fc-11e3-b496-c959b35bdbdf

See supported data types in the Apigee docs for details on the different types of data that can be stored/retrieved.