Yep, that fixes it! Thanks for your work on that!
On Tuesday, August 14, 2012 6:18:29 PM UTC-4, howesc wrote:
>
> i added a patch against trunk to the ticket. spiffytech - can you see if
> that works for you?
>
> cfh
>
> On Monday, August 13, 2012 12:20:02 AM UTC-7, howesc wrote:
>>
>> we do sp
i added a patch against trunk to the ticket. spiffytech - can you see if
that works for you?
cfh
On Monday, August 13, 2012 12:20:02 AM UTC-7, howesc wrote:
>
> we do special query handling on the key field, so i suspect the multiple
> filters on key is wonky. i'll try and look at this in the
we do special query handling on the key field, so i suspect the multiple
filters on key is wonky. i'll try and look at this in the next couple of
days
thanks for reporting, and thanks for your patience guiding us through it. :)
christian
On Sunday, August 12, 2012 8:01:29 PM UTC-7, spiffy
Yes, I've verified that this can be done. The below query works in the App
Engine Datastore Viewer (note that it only worked once I manually created
the index in index.yaml and deployed it; web2py did not automatically
create the appropriate index:
SELECT * FROM posts WHERE __key__ IN (KEY('pos
How would you do the query in GQL? Have you confirmed that it can be done?
Anthony
On Sunday, August 12, 2012 9:23:39 PM UTC-4, spiffytech wrote:
>
> I tested with your suggested orderby, but the outcome was the same.
>
> I tested with the query as you wrote it below, with no common_filter, and
>
> Also, is there some significance to limiting the belongs lists to 30 items?
>
>From Google:
*Note:* The IN and != operators use multiple queries behind the scenes. For
example, the IN operator executes a separate underlying datastore query for
every item in the list. The entities returned
I tested with your suggested orderby, but the outcome was the same.
I tested with the query as you wrote it below, with no common_filter, and
the query still failed. Since that's a pretty straightforward query that
should work, this seems like a bug to me, so I filed a web2py bug report:
http:/
i had to look up common_filters.based on your experience i would assume
that this is being implemented as a query filter rather than getting
results from the DB and then filtering them. so what is must be causing in
your case is:
posts = db((db.posts.id.belongs(post_ids)) &
(db.posts.post
I've narrowed the problem down further- the exception is caused by a
common_filter attached to my posts table:
common_filter = lambda query: db.posts.post_date <= request.now
I'm not sure why that would trigger the orderby error, though.
Also, is there some significance to limiting the belongs
the query and the error message do not match. your query has no orderby,
yet the error message suggests there is an orderby property set. this
confuses me.
i do:
db(db.table.id.belongs([list of items not more than 30 long])).select()
all the time on GAE and it works for me (latest stable web
10 matches
Mail list logo
