<div dir="ltr">Hi Matthew! Your query should be written in one of the following ways (the first query is the most efficient): 1. select(a for a in A for b in <a href="http://a.bs">a.bs</a> if max(b.status) == 'whatever' and min(b.status) == 'whatever') 2. select(a for a in A if max(a.bs.status) == 'whatever' and min(a.bs.status) == 'whatever') 3. select(a for a in A if 'whatever' in a.b.status and not exists(b for b in <a href="http://a.bs">a.bs</a> if b.status != 'whatever')) Pony currently doesn't support automatic transaltion of all(), but in future we'll add this feature, and the result of translation will be the same as in one of the the queries above. Regards, Alexander</div> <div class="gmail_extra"> <div class="gmail_quote">On Sun, Feb 16, 2014 at 5:26 PM, Matthew Bell <<a href="mailto:matthewrobertbell@gmail.com" target="_blank">matthewrobertbell@gmail.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>Say I have 2 entities with a one to many relationship: �� class A(db.Entity): �� bs = set('B') �� class B(db.Entity): �� a = Required('A') �� status = Required(unicode) I then want to query for all "A", that have Bs that all have the status "whatever". How I assumed it could be done: �� select(a for a in A if a.bs.status == 'whatever') or �� select(a for a in A if all(b.status == 'whatever' for b in <a href="http://a.bs" target="_blank">a.bs</a>)) But neither work. What is the "pony way" of doing this? A python example of what I mean (I obviously would like to do it properly all in pony though): �� for a in models.A.select(): �� if all(b.status == 'whatever' for b in <a href="http://a.bs" target="_blank">a.bs</a>): �� yield a </div>Thanks in advance for any guidance. <div> -- Regards, Matthew Bell </div></div> _______________________________________________ ponyorm-list mailing list <a href="mailto:ponyorm-list@ponyorm.org">ponyorm-list@ponyorm.org</a> <a href="/ponyorm-list" target="_blank">/ponyorm-list</a> </blockquote></div> </div>