You need to sign in to do that
Don't have an account?
Khalid Abdullah
SOQL: How do I select accounts where the owner's record is frozen?
Hi all,
I'm looking to create a simple SOQL query which brings back all accounts based on whether or not the owner's record isfrozen.
I've been trying variations of the following SOQL: Select name from ACCOUNT where Account__r.owner in (select isfrozen from userlogin where isFrozen = true)
So far I have had no luck. Would anyone be able to help me? I am relatively new to SOQL and would appreciate any help I can get :-)
I'm looking to create a simple SOQL query which brings back all accounts based on whether or not the owner's record isfrozen.
I've been trying variations of the following SOQL: Select name from ACCOUNT where Account__r.owner in (select isfrozen from userlogin where isFrozen = true)
So far I have had no luck. Would anyone be able to help me? I am relatively new to SOQL and would appreciate any help I can get :-)
All Answers