More clarification. We were looking for a way to mix a specific join and a manual join. The potential work-a-around we have now is to make two joins.
On Mar 30, 11:25 am, jarofclay <[email protected]> wrote: > As a clarification, Transfer 1.1 on MSSQL > > An example, given: > > <package name="post"> > <object name="Post" table="tbl_Post"> > <id name="IDPost" type="numeric"/> > <property name="Title" type="string" column="post_Title"/> > <property name="Body" type="string" column="post_Body"/> > <property name="DateTime" type="date" column="post_DateTime"/> > > <manytomany name="Category" table="lnk_PostCategory"> > <link to="post.Post" column="lnkIDPost"/> > <link to="system.Category" column="lnkIDCategory"/> > <collection type="array"> > <order property="OrderIndex" order="asc"/> > </collection> > </manytomany> > </object> > </package> > > <package name="system"> > <object name="Category" table="tbl_Category"> > <id name="IDCategory" type="numeric"/> > <property name="Name" type="string" column="category_Name"/> > <property name="OrderIndex" type="numeric" > column="category_OrderIndex"/> > </object> > </package> > > TQL Query > > "from post.Post as Posts left outer join system.Category as > Categories" > > This query works (but what is the join?), but when we want to add > another criteria to the join we have problems. So if we only wanted > categories with a name starting with "Red" > > "from post.Post as Posts left outer join system.Category as Categories > on Categories.Name like 'Red%' and ??????" > > We are wondering what the ?????? would be. > > On Mar 30, 11:16 am, Joseph Swenson <[email protected]> wrote: > > > > > How do I specify the join of a manytomany relationship in TQL? > > > For example, I have a TQL statement which is joining correctly but I > > want to add another item to "ON" but I'm not clear on how the join is > > happening currently. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
