Re: [google-appengine] datastore view question : how to sort

you can do this neat little trick:

Select * From table Where __key__ = Key('table',22)

If the id was really a key_name, then you'd use '22' instead of an int.

On Thu, Mar 18, 2010 at 5:25 PM, observer247 <premdeb@gmail.com> wrote:

While using the datastore viewer, to find a particular record, I use a
gql query, for eg:

Select * from table where name  = 'myname'


or to sort it in descending order:

Select * from table ORDER BY score DESC

My question is how to I find a record with id = 22

Also how do I sort and find out the last added entry. (so I would sort
it by id in desc order).

Thanks for reading.

--
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com.
To unsubscribe from this group, send email to google-appengine+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.

--
You received this message because you are subscribed to the Google Groups "Google App Engine" group.
To post to this group, send email to google-appengine@googlegroups.com.
To unsubscribe from this group, send email to google-appengine+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.