Skip to main content

GQL Reference - Google App Engine - Google Code

Popularity Report

Total Popularity Score: 0
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...

Rank

URL Tag Cloud

Bookmark History

Saved by 4 people (1 private), first by anonymouse user on 2008-06-05


Public Sticky notes

As with SQL, GQL keywords are case insensitive. Kind and property names are case sensitive.

Highlighted by beijixuexiong

Kind and property names are case sensitive.

Highlighted by klozer

A GQL query cannot perform a SQL-like "join" query.

Highlighted by beijixuexiong

A GQL query cannot perform a SQL-like "join" query.

Highlighted by ken

A result is always a complete entity

Highlighted by klozer

A GQL query cannot perform a SQL-like "join" query.

Highlighted by klozer

GQL does not have an OR operator, however, the IN operator is supported which provides a limited form of OR.

Highlighted by beijixuexiong

GQL does not have an OR operator

Highlighted by ken

GQL does not have an OR operator.

Highlighted by klozer

The IN operator is equivalent to many = queries

Highlighted by klozer

hat are ORed togethe

Highlighted by klozer

The left-hand side of a comparison is always a property name.

Highlighted by ken

he IN and != operators use multiple queries behind the scenes

Highlighted by klozer

for every item in the list

Highlighted by klozer

A maximum of 30 datastore queries are allowed for any single GQL query

Highlighted by klozer

de-duplicated

Highlighted by klozer

as a given entity as an ancestor,

Highlighted by klozer

The LIMIT can also include an offset to skip that many results to find the first result to return. An optional OFFSET clause can specify an offset if no LIMIT clause is present.

Highlighted by beijixuexiong

The 1000 results includes any that are skipped using an OFFSET, so a query with more than 1000 results using an OFFSET of 100 will return 900 results.

Highlighted by beijixuexiong

The datastore returns a maximum of 1000 results in response to a query, regardless of the LIMIT and OFFSET used to fetch the results.

Highlighted by ken

An optional LIMIT clause causes the query to stop returning results after the first count entities

Highlighted by klozer