Requirment :- I need to fetch the assigned user to the territory for any account.
I have one account with territory and in that territory assigned user count is 5 and there is one user with UserType='Manager'.
I need a Single SOQL query which will fetch the user with UserType='Manager' from Territory
IsExcludedFromRealign would also prevent the reassignment when manually updated no?
When you go into a territory and select Manage Rules, down at the bottom there is a Preview button. Does the account show there? Could it be that there is another assignment rule running when you manually update and thus not working when you run the rule you're looking at? Are you actually pressing the Run Rules button?
Not trying to be condescending but running through all the possible scenarios.
As it turns out, one must set the Default checkbox on the account page layout properties if you want Salesforce to re-evaluate territory assignment rules when you edit an account:
By default, this checkbox is not checked (at least in our org). Checking this option and saving the page layout solved my problem.
As a side note, deploying the page layout results in the target org's Default setting becoming unchecked, regardless if it was checked in the source page layout. Salesforce support told me this was "expected behavior", although I can't imagine anyone wanting this "feature".
Best Answer
I haven't tested this, but I think using a nested sub-select in the WHERE clause will work for you. You may need to tweak, but I think this will get you close: