title: GAE Datastore Viewer by GQL WHERE query for a String does not seem to work
body: <p>Here is my data:</p>
  
  <p>ID/Name  createdTime     customerName    itemName    price   quantity    status  user_orderid
  id=5681726336532480  2013-10-12 05:07:47.794000  "joe"   "Nexus 5"   349.00  1   "pending"   "1"</p>
  
  <p>Running either of these two queries gives me data:<br>
  SELECT * FROM order<br>
  SELECT * FROM order ORDER BY createdTime DESC</p>
  
  <p>But running the following gives me nothing:<br>
  SELECT * FROM order WHERE status = 'pending'<br>
  SELECT * FROM order WHERE status = 'pending' ORDER BY createdTime DESC</p>
  
  <p>I see results when doing the following:<br>
  SELECT * FROM order WHERE status != 'pending'<br>
  <br>
  So I know that the WHERE clause is having some effect. I just can't get 'pending' in the GQL query to match "pending" in the datastore.</p>
  
  <p>My index is defined as so:<br>
  order status ▲ , createdTime ▼   Serving</p>
  
  <p>I deleted the record and re-adding it to make sure that it was created after the index was in place. That did not help.
  I read the GQL Reference page over and over but didn't find anything really helpful. Some posts on stackoverflow indicated that my syntax for doing a WHERE = 'string' is correct.
  But no matter what I do, I can't get this to return data either for the Datastore Viewer or my actual application which is trying to run this query.</p>
  
  <p>I ran into this while doing the App Engine code lab Exercise 8 hosted here: <a href="http://googcloudlabs.appspot.com/codelabexercise8.html" rel="nofollow">http://googcloudlabs.appspot.com/codelabexercise8.html</a></p>
  
  <p><strong>Update:</strong> Here is the model as requested:</p>
  
  <pre><code>/**
   * &lt;p&gt;Java class for order complex type.
   * 
   * &lt;p&gt;The following schema fragment specifies the expected content contained within this class.
   * 
   * &lt;pre&gt;
   * &amp;lt;complexType name="order"&gt;
   *   &amp;lt;complexContent&gt;
   *     &amp;lt;restriction base="{http://www.w3.org/2001/XMLSchema}anyType"&gt;
   *       &amp;lt;sequence&gt;
   *         &amp;lt;element name="customer" type="{http://www.w3.org/2001/XMLSchema}string"/&gt;
   *         &amp;lt;element name="status" type="{http://www.w3.org/2001/XMLSchema}string"/&gt;
   *         &amp;lt;element name="user_orderid" type="{http://www.w3.org/2001/XMLSchema}string"/&gt;
   *         &amp;lt;element name="item" type="{http://www.w3.org/2001/XMLSchema}string"/&gt;
   *         &amp;lt;element name="quantity" type="{http://www.w3.org/2001/XMLSchema}positiveInteger"/&gt;
   *         &amp;lt;element name="price" type="{http://www.w3.org/2001/XMLSchema}decimal"/&gt;
   *       &amp;lt;/sequence&gt;
   *       &amp;lt;attribute name="id" type="{http://www.w3.org/2001/XMLSchema}long" /&gt;
   *     &amp;lt;/restriction&gt;
   *   &amp;lt;/complexContent&gt;
   * &amp;lt;/complexType&gt;
   * &lt;/pre&gt;
   * 
   * 
   */
  @XmlAccessorType(XmlAccessType.FIELD)
  @XmlType(name = "order", propOrder = {
      "customer",
      "status",
      "userOrderid",
      "item",
      "quantity",
      "price"
  })
  public class Order {
  
      @XmlElement(required = true)
      protected String customer;
      @XmlElement(required = true)
      protected String status;
      @XmlElement(name = "user_orderid", required = true)
      protected String userOrderid;
      @XmlElement(required = true)
      protected String item;
      @XmlElement(required = true)
      protected BigInteger quantity;
      @XmlElement(required = true)
      protected BigDecimal price;
      @XmlAttribute
      protected Long id;
  
      ... getters and setters ...
  </code></pre>
  
  <p>Here is the database index:</p>
  
  <pre><code>&lt;datastore-indexes&gt;
      &lt;datastore-index kind="order" ancestor="false" source="auto"&gt;
          &lt;property name="status" direction="asc"/&gt;
          &lt;property name="createdTime" direction="desc"/&gt;
      &lt;/datastore-index&gt;
  &lt;/datastore-indexes&gt;
  </code></pre>
  
  <p><strong>Update:</strong> Fixed. The data should look like this instead of what I posted above.<br />
  ID/Name  createdTime     customerName    itemName    price   quantity    status  user_orderid<br />
  id=5760616295825408  2013-10-12 19:25:13.098000  joe     Nexus 5     349.00  1   pending     12</p>