On Monday 27 October 2008 03:06:33 pm johnf wrote:
> On Monday 27 October 2008 03:04:16 pm johnf wrote:
> > On Monday 27 October 2008 02:54:12 pm johnf wrote:
> > > I can not add to the where clause for a child using
> > > self.addWhere('public.agpoptrs.lvoid<>True')
> > >
> > > I want to filter all my void records in my child bizobj.  But it
> > > appears that dBizobj in setChildLinkFilter() is over writting the where
> > > I have added.
> >
> > OK I was able use the linkfield as the way to filter the data.  But this
> > sounds fishy.
> >
> > self.LinkField ="lvoid<>True and fk_agpopord"
>
> spoke to soon - above does not work but it also attempts to use the
> linkfield in the new().

this seems to work 
def beforeRequery(self):
        self.addWhere('public.agpoptrs.lvoid<>True')

but I think issue stems comes from 
dBizobj setChildLinkFilter() 

self.setWhereClause=''

if self.DataSource and self.LinkField and self.Parent:
                        if self.Parent.RowCount == 0:
                                # Parent is new and not yet saved, so we cannot 
have child records yet.
                                #self.setWhereClause("")
                                filtExpr = " 1 = 0 "

When I comment out the setWhereClause it works without adding the 
beforeRequery().  I see not reason for having the setWhereClause since Dabo 
is setting the filtExpr statement.  If I leave the setWhereClause it blows 
away my addWhere in the bizobj.

So Ed or Paul is this the right thing to do?


-- 
John Fabiani


_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[EMAIL PROTECTED]

Reply via email to