Jeff, After having looked at your version of the tag, I see that you have the old version before the reengineering took place. This problem should be resolved with the newest version.
Thanks! Dave ----- Original Message ----- From: "Jeff Fleitz" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, September 20, 2004 10:16 AM Subject: Re: [plum] Filter Criteria Sticking on Master Detail forms > Hi David, > > Below is the child list info, which has the Join to parent nested inside > it. This was generated by the IDE. I just added the > whereClauseExtension because the filtering wasn't happening automatically. > I also have JoinToParent calls to Country and StateProvince tables, as I > am displaying those display values in the list. I should also mention > that the relationships for those are optional. > > Jeff > > > <cf_DisplayList table="Office" rowsPerPage="10" label="Company Offices" > displayALinkToThisSearchForm="No" whereClauseExtension="Office.CompanyID > = #URL.CompanyID#"> > <cf_PrimaryKey primaryKeyColumn="OfficeID" primaryKeyType="integer"> > <cf_JoinToParent table="Company" primaryKeyColumn="CompanyID" > foreignKeyColumn="CompanyID"> > <cf_JoinToParent table="StateProvince" > primaryKeyColumn="StateProvinceID" foreignKeyColumn="StateProvinceID" > optionality="Optional"> > <cf_JoinToParent table="Country" primaryKeyColumn="CountryID" > foreignKeyColumn="CountryID" optionality="Optional"> > <cf_DisplayColumnInList column="OfficeName" label="Office Name" > type="varchar(50)"> > <cf_DisplayColumnInList column="Headquarters" label="Headquarters" > type="bit"> > <cf_DisplayColumnInList table="StateProvince" column="Abbrev" > label="StateProvince" type="char(10)"> > <cf_DisplayColumnInList table="Country" column="Country" > label="Country" type="varchar(50)"> > > <cf_DisplaySortOrderMenu> > <cf_DisplaySortOrderOption displayText="Office Name" > sortOrder="Office.OfficeName ASC"> > </cf_DisplaySortOrderMenu> > > <cf_DisplayDeleteCheckboxInList> > > <cf_DisplayListLinks add="OfficeAddForm.cfm" > view="OfficeViewForm.cfm" edit="OfficeEditForm.cfm" > delete="OfficeDeleteForm.cfm"> > [<a > href="#Application.urlRoot#/admin/company/EmployeeList.cfm?OfficeID=#URLEnco dedFormat(Trim(Attributes.listQuery.Office_OfficeID[currentRow]))#&FromDrill =1">Employees</a>] > > </cf_DisplayListLinks> > </cf_DisplayList> > > > David Churvis wrote: > > >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 > >>_______________________________ > >> > >> > >> > >> > >> > > > > > > > > > > > > -- > _______________________________ > > Jeff Fleitz > Tekquest, Ltd > Integrated Digital Solutions > http://www.tekquest.com > _______________________________ > > >
