Look at the sql it generates. Figure out what is wrong with it and figure out what the correct should look like. When we can try implement it in dal.
On Jun 21, 11:26 am, "Joseph S. Greenawalt" <jsgreenaw...@gmail.com> wrote: > Tried with this: > > maxDate = db.MemberEvents.EventDate.max() > results =\ > db().select(\ > db.Members.ALL,\ > maxDate,\ > left=\ > db.MemberEvents.on(db.Members.id == db.MemberEvents.MemberID),\ > having=(maxDate > date)|(db.MemberEvents.EventDate==None),\ > groupby=db.Members.id) > > Same error, "Unknown column 'MemberEvents.EventDate' in 'having > clause'". I'm pretty sure it's related to my attempt to use the > maxDate in the "having" clause. If I change maxDate to: > > maxDate = db.MemberEvents.EventDate #.max() > > It'll run without errors, but doesn't produce correct results. I get > only a partial set of members w/ event dates mixed in that are after > the target date... > > Thanks, > - Joe G. > > On Jun 21, 11:10 am, Pai <pai.siwamut...@gmail.com> wrote: > > > try below. > > > db().select(\ > > db.Members.ALL,\ > > maxDate,\ > > left=\ > > db.MemberEvents.on(db.Members.id == > > db.MemberEvents.MemberID),\ > > having=(maxDate > date)| > > (db.MemberEvents.EventDate==None), \ > > groupby=db.Members.id) > > > Pai
