Get childrens from OrganizationUnit #6526

pointlevel created 5 years ago

Hello!

How can i retrieve(Include) the Children as iCollection of OrganizationUnits when using this code from documentation?

            var user = await _userManager.GetUserByIdAsync(AbpSession.UserId.Value);
            var organizationUnits = await _userManager.GetOrganizationUnitsAsync(user);
            var organizationUnitIds = organizationUnits.Select(ou => ou.Id);

7 Answer(s)

aaron created 5 years ago

Support Team

var organizationUnits = await _organizationUnitRepository
    .GetAllIncluding(ou => ou.Children)
    .Where(ou => organizationUnitIds.Contains(ou.Id))
    .ToListAsync();

0

pointlevel created 5 years ago

so i need to make an additional query for that? First get the logged in user, then the OUs for that user, and then the OUs again with children?
0

aaron created 5 years ago
Support Team

Yes, if you want to use the code from the documentation. Otherwise, you can write your own join query.
0

pointlevel created 5 years ago

Can you please show me how to write that query where i get the current user, users OU´s including its children?

Thanks.
0

ismcagdas created 5 years ago
Support Team

Hi @pointlevel

Have you managead to write that query ?
0
aaron created 5 years ago
Support Team
Copy the query in GetOrganizationUnitsAsync and make this change:

- _organizationUnitRepository.GetAll() + _organizationUnitRepository.GetAllIncluding(ou => ou.Children)
0

pointlevel created 5 years ago

Thank you aaron simplicity is the best!

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