Akal Tech RSS Feed

Topic: Not getting the results with Left Join?

Wed, 20 May 2009 07:21:46 GMT

Topic Description: Hello,

I can't seem to be getting any results with the following code. What am I doing wrong?

using (Users u = new Users()) 
{ 
    u.ObjectMode = ObjectModes.Search; 
    u.Join_DepartmentID_Departments_Parent(JoinTypes.Left); 
    u.DepartmentID_Departments_Parent.DivisionID.Value = 1; 
    u.Find(); 
    return u.GenericList; 
} 
 

I have checked the AffectedRows property is 0 and ErrorString is also null. The data is also there in the table.

Cheers,
Ryan

Replies: 2
Last Reply: Wed, 20 May 2009 07:21:46 GMT
Reply By: Ryan Aljets

Reply: Re: Not getting the results with Left Join?

Wed, 20 May 2009 07:21:46 GMT

Victor,

Thank you for the reply. I added ValueOrNull and it works perfectly!

Cheers,
Ryan

Reply: Re: Not getting the results with Left Join?

Tue, 19 May 2009 18:02:49 GMT

Can you please check see if you have record in departments table with division id 1?

In case you looking to get result where either division id is null or division id is equal to 1 then you need to specify ValueOrNull to SearchMode property of the division id field.

u.DepartmentID_Departments_Parent.DivisionID.SearchMode = SearchModes.ValueOrNull; 
u.Find(); 

Please let me know if this don't resolve your problem.

Regards,
Victor

Quick Objects Support