function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jyoti Ranjan PandaJyoti Ranjan Panda 

what is the soql query to get record id of active user

what is the soql query to get record id of active user 
SwethaSwetha (Salesforce Developers) 
HI Jyoti,
Can you elaborate on the recordid you are referring to? Is it the user object record id?

As mentioned in https://dfc-org-production--c.vf.force.com/apex/ForumsMain?id=9062I000000Bnu2QAC , you can use
SELECT Id FROM User WHERE IsActive = true AND Username = 'user@example.com' if you want to fetch the userid of the active user

Thank you
Jyoti Ranjan PandaJyoti Ranjan Panda
Hi Swetha,

I would like to extract data of all users having read, write, modify and delete access in Salesforce Org.
How to extract this data through soql query .

Thanks
Arun Kumar 1141Arun Kumar 1141
Hi @Jyoti,

Try out this query:

Select Id,Name,Profile.Name from User with System_Mode 

Thank you.