Linq question: Get OrganizationUnits including Member Names #2418

rvanwoezik created 7 years ago

Hi, for a certain view i like to have All OrganizationUnits include there Members -> Member Name and ProfilePic. I'm banging my head against my keyboard but still can get it right.

I Tried this, but result is empty

var query = from uou in _userOrganizationUnitRepository.GetAll()
                        join ou in _organizationUnitRepository.GetAll() on uou.OrganizationUnitId equals ou.Id
                        join user in UserManager.Users on uou.UserId equals user.Id
                        where uou.OrganizationUnitId == input.Id
                        orderby input.Sorting
                        select new { uou, user };

Please advice

1 Answer(s)

0

ismcagdas created 7 years ago
Support Team

Hi,

Do you have an exception ? Because your code seems fine and it worked for me. I have removed sorting and used 1 as static organization unit Id.

Does the organization unit belongs to logged in user's tenant ? This is the only thing comes to my mind for now.

Have an answer to this question? Log in and write your answer.