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=#URLEncodedFormat(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
_______________________________
