I want to join a table (EPEmployees) twice to get employee and supervisor info and based on the user logged in I want to show either only an employees customers or the supervisors customers + the employees that report to them. This is what I have tried among a couple other ways:
public SelectFrom<Customer>
.LeftJoin<Address>
.On<Address.addressID.IsEqual<Customer.defAddressID>>
.LeftJoin<CustSalesPeople>
.On<Customer.bAccountID.IsEqual<CustSalesPeople.bAccountID>>
.LeftJoin<SalesPerson>
.On<CustSalesPeople.salesPersonID.IsEqual<SalesPerson.salesPersonID>>
.LeftJoin<Users>
.On<SalesPerson.descr.IsEqual<Users.email>>
.LeftJoin<EPEmployee>
.On<Users.pKID.IsEqual<EPEmployee.userID>>
.LeftJoin<Supervisors>
.On<EPEmployee.supervisorID.IsEqual<Supervisors.bAccountID>>
.Where<
Brackets<CustSalesPeople.isDefault.IsEqual<True>
.And<Users.pKID.IsEqual<AccessInfo.userID.FromCurrent>>
>
.Or<
Brackets<CustSalesPeople.isDefault.IsEqual<True>
.And<AccessInfo.userID.FromCurrent.IsEqual<Supervisors.userID>>
>
>
>
.AggregateTo<GroupBy<Customer.acctCD , Max<SalesPerson.salesPersonID>>>
.View CustomersView;
public class Supervisors : EPEmployee { }
Thanks in advance!