Sure:
<object name="company" table="Company" decorator="auction.$
{companyName}.model.company">
<id name="ID" type="numeric" />
<property name="Name" type="string" column="Name" />
<property name="URL" type="string" column="URL" />
<property name="ResourceRoot" type="string"
column="ResourceRoot" />
<property name="imageRoot" type="string"
column="imageRoot" />
<property name="phone" type="string" column="phone" />
<property name="fax" type="string" column="fax" />
<property type="boolean" name="allowSundayBids"
column="allowSundayBids"/>
<property type="boolean" name="allowSundayPreBids"
column="allowSundayPreBids"/>
<property name="Deleted" type="boolean"
column="Deleted" />
<!-- many other joins removed -->
<manytomany name="paymentMethod"
table="xCompanyPaymentMethods"
lazy="false" proxied="true">
<link to="company" column="CompanyID" />
<link to="paymentMethod"
column="paymentMethodID" />
<collection type="array" />
</manytomany>
</object>
<object name="user" table="users" decorator="auction.$
{companyName}.model.user">
<id name="ID" type="numeric" />
<property name="UUID" type="string" column="UUID" />
<property name="fName" type="string" column="fName" />
<property name="lName" type="string" column="lName" />
<property name="username" type="string"
column="username" />
<property name="password" type="string"
column="password" />
<property name="email" type="string" column="email" />
<property name="emailConfirmed" type="boolean"
column="emailConfirmed" />
<property name="company" type="string" column="company"
/>
<property name="phone" type="string" column="phone" />
<property name="fax" type="string" column="fax" />
<property name="cell" type="string" column="cell" />
<property name="creationDate" type="date"
column="creationDate" />
<property name="lastLogin" type="date"
column="lastLogin" />
<property name="secretAnswer" type="string"
column="secretAnswer" />
<property name="Active" type="boolean" column="Active"
/>
<property name="disableDate" type="date"
column="disableDate"
nullable="true" />
<property name="disableReason" type="string"
column="disableReason" />
<property name="deleted" type="boolean"
column="deleted" />
<!-- many other joins removed -->
<manytomany name="paymentMethod"
table="xUserPaymentMethods"
lazy="true" proxied="true">
<link to="user" column="userID" />
<link to="paymentMethod"
column="paymentMethodID" />
<collection type="array" />
</manytomany>
</object>
<object name="payment" table="payment" decorator="auction.$
{companyName}.model.payment">
<id name="ID" type="numeric" />
<property name="paymentDate" type="date"
column="paymentDate" />
<property name="amount" type="numeric" column="amount"
/>
<property name="approved" type="boolean"
column="approved" />
<property name="response" type="string"
column="response" />
<property name="note" type="string" column="note" />
<property name="deleted" type="boolean"
column="deleted" />
<property name="refunded" type="boolean"
column="refunded" />
<property name="paymentMethodID" type="numeric" ignore-
insert="true" ignore-update="true" refresh-insert="true" refresh-
update="true" />
<manytoone name="location">
<link to="location" column="locationID"/>
</manytoone>
<manytoone name="user">
<link to="user" column="userID"/>
</manytoone>
<manytoone name="paymentMethod">
<link to="paymentMethod"
column="paymentMethodID"/>
</manytoone>
</object>
<object name="paymentMethod" table="paymentMethod"
decorator="auction.${companyName}.model.paymentMethod">
<id name="ID" type="numeric" />
<property name="name" type="string" column="name" />
<property name="number" type="string" column="number" />
<property name="password" type="string"
column="password" />
<property name="expiration" type="date"
column="expiration" />
<property name="deleted" type="boolean"
column="deleted" />
<manytoone name="paymentType" lazy="false">
<link to="paymentType" column="paymentTypeID" />
</manytoone>
</object>
The only M2Ms are from User and Company to PaymentMethod... in the
case of my TQL, the joined tables are company and payment.
Incidentally joining Company and Payment at the same time wouldn't
matter because the PaymentMethod used for the Payment would have to
be available to the Company for it to be used on the Payment in the
first place.
J
On Nov 26, 2008, at 3:00 PM, Mark Mandel wrote:
>
> Jared,
>
> Looks like a bug - but, can you lay out the the basic config for me,
> so I can see the object relationships, as I think there are a couple
> of m2m relationships in there.
>
> Mark
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
