So here is my problem I have a rates table and a locations table and
other tables that use the rates table now they are linked via columns
IDFK and FKTable I know how to link them just with the IDFK but how do
I add the
FKTable filter of "location"
I know this is not right but good Idea
<link to="Events.XRRates" column="FKTable" value="locations"/>
Do I have to handle this is the decorator?
here is my table structure
<object name="XRRates" table="xr_rates"
decorator="iplan3.model.Events.xrRates">
<id name="RateID" type="UUID" generate="true" />
<property name="IDFK" type="string" column="IDFK" />
<property name="FKTable" type="string" column="FKTable" />
<property name="roleIDFK" type="string" column="roleIDFK" />
<property name="cutOffDate" type="date" column="cutOffDate" />
<property name="price" type="numeric" column="price" />
<property name="ratename" type="string" column="ratename" />
<property name="maxQTY" type="numeric" column="maxQTY" />
<property name="insOn" ignore-update='true' type="date"
column="insOn" />
<property name="insBy" ignore-update='true' type="string"
column="insBy" />
<property name="updOn" type="date" column="updOn" />
<property name="updBy" type="string" column="updBy" />
</object>
and
<object name="Locations" table="Locations"
decorator="iplan3.model.Events.locations">
<id name="LocationID" type="UUID" generate="true" />
<property name="ClientIDFK" type="string" column="ClientIDFK" />
<property name="eventIDFK" type="string" column="eventIDFK" />
<property name="LocationName" type="string" column="LocationName" />
<property name="Status" type="string" column="Status" />
<property name="Description" type="string" column="Description" />
<property name="City" type="string" column="City" />
<property name="State" type="string" column="State" />
<property name="Country" type="string" column="Country" />
<property name="StartDate" type="date" column="StartDate" />
<property name="EndDate" type="date" column="EndDate" />
<property name="CancelDate" type="date" column="CancelDate" />
<property name="hasRegOpen" type="numeric" column="hasRegOpen" />
<property name="hasGuest" type="numeric" column="hasGuest" />
<property name="Hosts" type="string" column="Hosts" />
<property name="timeZone" type="string" column="timeZone" />
<property name="insOn" ignore-update='true' type="date"
column="insOn" />
<property name="insBy" ignore-update='true' type="string"
column="insBy" />
<property name="updOn" type="date" column="updOn" />
<property name="updBy" type="string" column="updBy" />
<onetomany name="locationRates" lazy="true">
<link to="Events.XRRates" column="locationIDFK"/>
<collection type="array">
<order property="cutoffDate" order="asc"/>
</collection>
</onetomany>
</object>
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
