Use a subquery instead of a join for the assignment user filter

Use a subquery instead of a join for the assignment user filter #5672