Hello Guys,
I have the following TQL query, which runs as expected:
<cfsavecontent variable="LOCAL.TQL">
from inventory.Stock As Stock
join order.item As Item
where Stock.StockNumber = :StockNumber
</cfsavecontent>
Now, I want to create an additional join, this time from the Item object to
the 'Order' object. This relationship is defined in transfer as a OneToMany
from the Order to the Item.
I see details in the docs on how to do multiple joins from the Stock object,
however, not how to do an extended join like.
Stock -> Item -> Order
So that I can collect a list of stock that is associated to a particular
order through the given line item.
Can anyone offer any advice on this?
Robert
--
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
Try out the new Transfer ORM Custom Google Search:
http://www.google.com/cse/home?cx=002375903941309441958:2s7wbd5ocb8
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
