CODEWITHSUNDEEP
apigeeusergrid
Michael Bissell
Michael Bissell

Reputation: 1208

Apigee App Services/Usergrid query not returning results as expected

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)

Upvotes: 1

Views: 244

Answers (1)

brandonscript
brandonscript

Reputation: 73005

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.

Upvotes: 1

Related Questions