Hi John,
You are going to have to create a view (sql) for two of the joins. Plum will not let you alias tables at this time. So
create a view and use the view reference in place of the table in the Join2Parent, e.g.,
<cf_JoinToParent primaryKeyColumn="companyLocationID" table="vwCustomer"
foreignKey="customerID">
Jeff
John Stanley wrote:
Durr,
I guess I needed to finish my original question. How do I alias the
same table joined multiple times in a view form?
-----Original Message-----
From: John Stanley
Sent: Monday, August 29, 2005 1:58 PM
To: '[email protected]'
Subject: [plum] Multiple Joins to the same table
All,
I am working with a view form that looks like:
<cf_DisplayViewForm table="shipmentCargo"
displayALinkToThisList="No" label="">
<cf_PrimaryKey primaryKeyColumn="shipmentID"
primaryKeyType="integer"
value="#evaluate('#Application.persistentScope#.shipmentID')#">
<cf_JoinToParent primarykeycolumn="companyLocationID"
table="companyLocation" foreignkeycolumn="customerID"
optionality="Mandatory">
<cf_JoinToParent primarykeycolumn="companyLocationID"
table="companyLocation" foreignkeycolumn="shipperID" optionality="Optional">
<cf_DisplayColumnOnForm column="name"
table="companyLocation" label="Customer" type="varchar(50)" renderHtml="No">
<cf_DisplayColumnOnForm column="name"
table="companyLocation" label="Shipper" renderHtml="No">
</cf_DisplayViewForm>
Because my shipmentCargo table design is like this
column type fk
nullable
____________________________________________________________________
shipmentID int shipment.shipmentID NO
customerID int companyLocation.companyLocationID NO
shipperID int companyLocation.companyLocationID Yes
It doesnt look, to me, like the JoinToParent can handle this. Has anyone
else run into this?
I have a solution for this, but before I go hog wild on implementing it, I
want to make sure I didnt overlook anything.
Thanks, john
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
**********************************************************************
You can subscribe to and unsubscribe from lists, and you can change
your subscriptions between normal and digest modes here:
http://www.productivityenhancement.com/support/DiscussionListsForm.cfm
**********************************************************************
