title: Selecting Objectify data from the Google DataStore using GSQL in the Developer Console
body: <p>I have an Objectify entity called <code>UserEntity</code> which contains an object called <code>user</code>. I want to dump all the last sync times and some other data from my user objects to do a bit of analysis. I'm trying to do this in the Developers Console using GSQL but can't work out how to get the results I want.</p>
  
  <p>The query below works to get everything</p>
  
  <pre><code>SELECT * FROM UserEntity
  </code></pre>
  
  <p>Using this query get's all the keys</p>
  
  <pre><code>SELECT __key__ FROM UserEntity
  </code></pre>
  
  <p>This returns nothing, saying <code>No data was found.</code></p>
  
  <pre><code>SELECT user FROM UserEntity
  </code></pre>
  
  <p>But I can't work out how to (or if I can) select individual properties from objects. Is it possible to achieve this in the Developer Console, or shall I just write some code to do it?</p>
  
  <p>Ideally I'd like to be able to do something like</p>
  
  <pre><code>SELECT user.synctime, user.currentLevel FROM UserEntity
  </code></pre>
  
  <p>Stripped <code>UserEntity</code> class below</p>
  
  <pre><code>@Entity
  @Cache
  public class UserEntity extends WordBuzzEntity {
      @Id
      private String facebookId;
      public User user = new User(null);
      private HashMap&lt;String, Date&gt; accessTokens = new HashMap&lt;String, Date&gt;();
  }
  </code></pre>