Building Google Cloud Platform Solutions

Using GQL in the Cloud Console

With the Employee entities in place, open the Cloud Console and navigate to Navigation menu | Datastore | Entities. Click on the Query by GQL tab to be presented with the GQL console. From here, we can execute GQL queries and view the resulting entities. For example, queries can be performed to return all matches for one or more property like so:

SELECT * FROM Employee WHERE name = 'John Green'

This will return all entities of kind Employee that have a property name set to John Green. After executing the query, click on the resulting entity to view the John Green entity's details. From here, copy the entity's Key Literal and navigate back to the GQL console.

With John Green's key at hand, we can perform ancestry-based ...