Hi Jeff, Does your child DisplayList tag have a JoinToParent nested inside it? If not, is this one that you manually created or one that was generated from the IDE?
Thanks, Dave ----- Original Message ----- From: "Jeff Fleitz" <[EMAIL PROTECTED]> To: "[email protected]" <[email protected]> Sent: Saturday, September 18, 2004 6:52 PM Subject: [plum] Filter Criteria Sticking on Master Detail forms > I don't know if this problem is related to the drilldowns/ups so I'll > post it. This is all latest build and I have generated the tags several > times. > > I am playing with a MasterDetail View form that has a DisplaySpouses tag > call on it (works fine), and a list to a child. This is based on the > Company -> Office parent child relationship I have been testing with > recently. > > When I go into the view form, the Office List I built displays rows from > all companies, instead of from the company I am viewing. I couldn't > figure out why it is not being filtered, and could not find any > references to the problem, so I manually added a > whereClauseExtension="Office.CompanyID = #URL.CompanyID#" for grins. I > should not have to use this attribute, correct? > > This worked, but if I returned to the Company list, selected a different > company to view, the filter criteria from the first call is sticking, > and the filter criteria from the second view call is appended to the > end. See SQL below for example. > > SELECT Office.OfficeName AS Office_OfficeName,Office.Headquarters AS > Office_Headquarters,StateProvince.Abbrev AS > StateProvince_Abbrev,Country.Country AS Country_Country,Office.OfficeID > AS Office_OfficeID,Office.CompanyID AS > Office_CompanyID,Office.StateProvinceID AS > Office_StateProvinceID,Office.CountryID AS Office_CountryID FROM > ((Office INNER JOIN Company ON Office.CompanyID = Company.CompanyID) > LEFT OUTER JOIN StateProvince ON Office.StateProvinceID = > StateProvince.StateProvinceID) LEFT OUTER JOIN Country ON > Office.CountryID = Country.CountryID WHERE 1 > 0 AND Office.CompanyID = > 1 AND Office.CompanyID = 4 AND Office.CompanyID = 1 ORDER BY > Office.OfficeName ASC > > I have to click the list links on the navbar, where refresh=1 to clear > the criteria and start over, otherwise errors are generated. > > Is this related to what David is re-engineering right now? I didn't > install the tutorial, but I gather the example in the help file must work? > > Jeff > > -- > _______________________________ > > Jeff Fleitz > Tekquest, Ltd > Integrated Digital Solutions > http://www.tekquest.com > _______________________________ > > >
