I figured it out I think <condition property="FKTable" value="locations"/> If someone else has a better idea please let me know
On Jun 5, 4:55 pm, spiraldev <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
