Hi,

I have a dynamic list that I am building and I add a relation

myBucket.Relations.Add(CubeDealItemUserEntity.Relations.UserEntityUsingOwnerID, JoinHint.Right);

However the SQL comes out as RIGHT JOIN.... what I need for my query to work is actually RIGHT OUTER JOIN

I have been reading about obeyweakrelations but how do I use it to get the RIGHT OUTER JOIN I need in a dynamic list.

A small illustrative piece of code would be great

Many thanks

Set ObeyWeakRelations = true on the relationcollection you use for the dynamic list