Hi, Marzia. Thank you for your reply.
It is missing.
For example, I run this query:
query = models.Ownership.all().filter('user =',
[email protected]),filter('deleted =',False).order('-
created_on').fetch(0, 20)
These lists are my expecting/getting result.
The getting result contains no 'NG' data but folowing 3 data.
expecting:
2008-12-12 10:25:23.397434
2008-12-09 18:04:23.439058
2008-12-03 15:22:46.754546
2008-12-03 15:22:45.251281
2008-12-03 15:22:42.594933
2008-12-03 15:22:41.149333
2008-12-03 15:22:39.559995
2008-12-03 15:22:38.116000
2008-12-03 15:22:36.511006
2008-12-03 15:22:35.117080
2008-12-03 15:22:33.679363
2008-12-03 15:22:32.119234
2008-12-03 15:22:30.461840
2008-12-03 15:22:28.936849
2008-12-03 15:22:27.518304
2008-12-03 15:22:26.039718
2008-12-03 15:22:24.665877NG
2008-12-03 15:22:23.188243
2008-12-03 15:22:21.681791NG
2008-12-03 15:22:20.245579NG
getting:
2008-12-12 10:25:23.397434
2008-12-09 18:04:23.439058
2008-12-03 15:22:46.754546
2008-12-03 15:22:45.251281
2008-12-03 15:22:42.594933
2008-12-03 15:22:41.149333
2008-12-03 15:22:39.559995
2008-12-03 15:22:38.116000
2008-12-03 15:22:36.511006
2008-12-03 15:22:35.117080
2008-12-03 15:22:33.679363
2008-12-03 15:22:32.119234
2008-12-03 15:22:30.461840
2008-12-03 15:22:28.936849
2008-12-03 15:22:27.518304
2008-12-03 15:22:26.039718
2008-12-03 15:22:23.188243
2008-12-03 15:22:18.783426
2008-12-03 15:22:17.303290
2008-12-03 15:22:13.102364
Thanks.
On 12月16日, 午前5:18, Marzia Niccolai <[email protected]> wrote:
> Hi,
>
> Thanks for the report, but I'm not sure I understand how exactly your query
> is having an issue.
>
> Can you elaborate on this statement: "The result set is ordered by
> '-created_on', but it is not sequential." What data are you getting? What
> data are you expecting? Is it misordered or missing?
>
> Also, have you tried adding this index to your index.yaml and uploading it
> with your application:
>
> - kind: Ownership
> properties:
> - name: user
> - name: deleted
> - name: created_on
> direction: desc
>
> Thanks,
> Marzia
>
> On Mon, Dec 15, 2008 at 11:05 AM, paptimus <[email protected]> wrote:
>
> > I get an additional information.
>
> > I vacuumed the problem index and rebuilt the same index.
> > The number of result set before vacuum_index is not same as one of
> > after that.
> > Obviously, query is same.
>
> > So I think my app get into this situation while rebuilding index.
> > I hope gae team checks my app's index.
> > My app id is 'book-case-2' and kind is 'Ownership'.
>
> > Thanks.
>
> > On 12月16日, 午前1:23, "koji matsui" <[email protected]> wrote:
> > > Hi, djidjadji, thanks for your comment.
>
> > > I tried both query as below:
>
> > > query = models.Ownership.all().filter('user', user),filter('deleted',
> > > False).order('-created_on').fetch(offset, amount)
> > > query = models.Ownership.all().filter('user =', user),filter('deleted
> > > =', False).order('-created_on').fetch(offset, amount)
>
> > > But the definition of index sdk generates is exactly the same.
> > > And lack of data in result set is the same.
>
> > > So, I think this problem happens when server creates the index.
>
> > > Thanks.
>
> > > 2008/12/15 djidjadji <[email protected]>:
>
> > > > A snippet from the manual
> > > > ==============
> > > > filter(property_operator, value)
>
> > > > Adds a property condition filter to the query. Only entities with
> > > > properties that meet all of the conditions will be returned by the
> > > > query.
>
> > > > Arguments:
>
> > > > property_operator
> > > > A string containing the property name and a comparison
> > > > operator. The name and the operator must be separated by a space, as
> > > > in: age > The following comparison operators are supported: < <= = >=
> > > >> (The not-equal (!=) and IN operators are not supported.)
> > > > ==============
>
> > > > You forget the "comparison operator" in your filter statements.
>
> > > > 2008/12/13 paptimus <[email protected]>:
>
> > > >> query = models.Ownership.all().filter('user', user),filter('deleted',
> > > >> False).order('-created_on').fetch(offset, amount)
>
> > > --
> > > -----------------
> > > koji matsui
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Google App Engine" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
