[google-appengine] GQL query in google cloud console

2015-11-22 Thread Happy Mornings
I have entry in the Order table with the value (id=5629499534213120) in the Name/ID column. I want to search for the Order entries using this field. I tried executing the following query, it is not giving any result. SELECT * from Order where __key__ = KEY(Order, 5629499534213120) I am getting

[google-appengine] gql query over an n:m relationship

2010-12-20 Thread ping
I have an entity A which is related to an entity B through a n:m relationship. class A { ... @Persistent private SetKey B_entities; ... } class B { ... @Persistent private Group group; @Persistent private SetKey A_entities; ... } Now i want to write a query which gives me all the entities A of

Re: [google-appengine] gql query over an n:m relationship

2010-12-20 Thread Robert Kluin
You would need to denormalize your data in some way to do that. The datastore does not support that type of JOIN. Do not think in terms of SQL while you are developing your data-structures. A little bit of useful info about how the datastore works:

Re: [google-appengine] GQL Query

2010-08-12 Thread Karan Malhotra
whats the GQL i herad SQl -- 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-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com.

[google-appengine] GQL Query

2010-08-11 Thread jp
Hi Can anyone teach me how to do insert delete and update statement for GQL thanks in advance -- 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-appeng...@googlegroups.com. To unsubscribe from this

Re: [google-appengine] GQL Query

2010-08-11 Thread Barry Hunter
You cant. GQL is for SELECT only. (ie it only performs lookup queries) On 11 August 2010 02:57, jp backstabber...@hotmail.com wrote: Hi Can anyone teach me how to do insert delete and update statement for GQL thanks in advance -- You received this message because you are subscribed

[google-appengine] gql query for a specific user

2009-08-18 Thread Marc-Antoine Ruel
See Rietveld's Issue definition at: http://google.com/codesearch?q=class+Issue+package%3Ahttp%3A%2F%2Frietveld.googlecode.com - class Issue(db.Model): # ... owner = db.UserProperty(auto_current_user_add=True, required=True) # ... I'm trying to debug a weird failure and I want to retrieve

[google-appengine] GQL query failed to return a qualifying entity

2009-08-03 Thread phtq
In our application (kbdlessons version 1-01) we have just had a case where a query in our application failed to return a record which definitely exists. We were able to reproduce this problem using the Dataviewer page off the app engine dashboard. We put in this query using the Dataviewer:

[google-appengine] GQL Query with IN operator Issue (bug or am i making a mistake?)

2009-04-20 Thread ecognium
Hello everyone, I noticed an odd behavior with GQL query when it has two IN operators and a regular condition. Below is some basic code to reproduce the problem: class DummyData(db.Model): x = db.StringListProperty() y = db.TextProperty() class Dummy(webapp.RequestHandler):

[google-appengine] GQL query

2009-03-29 Thread Ritesh
Hi, I am a newbie so apologies if this is silly, I need to do a query on my datastore for partial strings but not something that begins with but may be part of the string. Like I have Last Name and First Name as one column Smith, Jhon Python-Micheal Smith, Jhon Doe, Jhon I need to query where I

[google-appengine] GQL Query involving key string

2009-02-27 Thread Audrey M Roy
How do I write a GQL query that's something like this... SELECT * FROM Pet WHERE __key__='mykeystring' the above returns the error BadFilterError: invalid filter: __key__ filter value must be a Key; received mykeystring (a unicode). Audrey --~--~-~--~~~---~--~~

[google-appengine] gql - query in list

2008-10-06 Thread Gilbert
If I'm not mistaken, doing a Gql query WHERE attribute in list returns all the rows of the table if list is empty ? Fairly strange behaviour --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups Google App Engine