Apex Code Development You need to sign in to do that
Don't have an account?
Surender reddy Salukuti query problem
hi,
when i wrote query in query editor.
select id from user where profile='system administator'
error-
[object Object]: select id from user where profile='system administator' ^ ERROR at Row:1:Column:27 No such column 'profile' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
below question
fetch all the account Records from Account which are owned by the user whose profile is System Admin and re-assign to User whose profile is manager how can i achive
when i wrote query in query editor.
select id from user where profile='system administator'
error-
[object Object]: select id from user where profile='system administator' ^ ERROR at Row:1:Column:27 No such column 'profile' on entity 'User'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
below question
fetch all the account Records from Account which are owned by the user whose profile is System Admin and re-assign to User whose profile is manager how can i achive
Please try below Query,
Select id,name,profile.name from user where profile.name ='System administrator'
Regards
Vinod
select id from user where Profile.Name='system administator'
AND
select id from Account where Owner.Profile.Name='system administator'
System administrator profile API is name Admin. use the API name instead of.System administrator.
Make it as best answer if it helps you
Thanks