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 <papti...@gmail.com> 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" <papti...@gmail.com> 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 <djidja...@gmail.com>:
> >
> >
> >
> >
> >
> > > 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 <papti...@gmail.com>:
> >
> > >> 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 google-appengine@googlegroups.com
To unsubscribe from this group, send email to
google-appengine+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/google-appengine?hl=en
-~----------~----~----~----~------~----~------~--~---
