Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I have an ID of user(say 00536000002qYTUIU8), which is not necessarily current context user, and want to get that user's name in apex. I can do following to get this:
select name from User where id ='00536000002qYTUIU8'
But is there any way to avoid querying DB and get the name from any method, something like:
User.getUsername(ID)
One option to reduce the SOQL call count for data you need frequently is to use the Platform Cache.
You could store the User ID to name lookup in the cache, and would then only need to do a SOQL query if the cache missed.
How effective this is will depend on how many User records you are dealing with and how much storage space you can allocate to the Cache.
You could also do an API call to get the data. Either to the REST API or the SOAP API. This would technically save you the SOQL query, but would use a callout instead. The other big downside of this approach is the performance. A callout will always be much slower than a direct SOQL query.
Http http = new Http(); HttpRequest request = new HttpRequest(); String instance = Url.getSalesforceBaseUrl().toExternalForm(); String endPoint = instance + '/services/data/v38.0/sobjects/User/0050Y000000pmuYQAQ?fields=Name'; String sessionId = 'Bearer ' + UserInfo.getSessionId(); request.setMethod('GET'); request.setHeader('Authorization', sessionId); request.setEndpoint(endPoint); http.send(request).getBody();
UserInfo.getUserName( don't remember the exact function from UserInfo) will return his name. Else I think it's the only wayUserUtilityclass with a static methodgetUserName()to do so