ActiveObjects - left join

We have 2 entities User and Designation, User can have a Designation or it could be null. In User list view, we want to sort users by Designation name. This will need to join 2 entities so that I can sort on Designation name but join eliminates the Users don’t have designation.

Having LEFT join on Designation will solve the issue, but there is no option to specify join type in ActiveObjects. Is there any other way doing this?

Designation is just one related entity there could be multiple relations and I want to sort User based on related entities’ values as well as return paginated users.

1 Like

Any suggestions for the above issue?