[SalesForce] How to get the opportunity owner name instead of owner ID

I am posting to chatter using an apex trigger whenever the opportunity stage changes to a certain value. The problem I'm having is that I'm trying to concatenate the opportunity owner name with some text but I can only get the ID of the owner. Is there a way I can simply get the opportunity owner name and concatenate it with the text? The query is returning the list i want but displays the key value pair, and i just want to get the firstname and lastname.

List<User> name= new List<User>();
name = [SELECT FirstName FROM User WHERE Id=:o.Opp_Owner_Name__c];
post.Body = 'Test' + name.get(0);

Best Answer

Select o.Owner.Name, o.Owner.FirstName, o.Owner.LastName, o.OwnerId From Opportunity o where o.Id in Trigger.NewMap.Keyset();

Please use the following query as Priyanka Rightly said that we cannot get those directly in Trigger.New .

Related Solutions

[SalesForce] Is it possible to post a url to an Opportunity in a simple chatter post

is something like this sufficient? The Op Name is a clickable link, though the Id is visible in the post as well.

Opportunity o = [Select OwnerId, Id, Name from Opportunity WHERE Id = 'xxx'];

FeedItem post = new FeedItem();
post.ParentId = o.OwnerId;
post.createdById= o.OwnerId;
post.Type = 'LinkPost'; 
post.Title = o.Name;
post.LinkURL = '/'+ o.Id;
insert post;

Or do you need more of the rich text mentioned in the post you link to (which is possible via ConnectAPI if you need an example - let me know)

[SalesForce] Change Opportunity Owner through Developer Console

try

Opportunity[] opportunities = [SELECT /** required Fields **/ 
                               FROM Opportunty 
                               WHERE Owner.Name = /** owner Name **/
                               LIMIT 1];
for(Opportunity opp : opportunities ){
    opp.OwnerId = /** here wanted Id **/
}

update opportunities;

This have to work. If it is still remain old owner then the issue is not your action from developer console but probably some triggered logic.

Best Answer

Related Solutions

[SalesForce] Is it possible to post a url to an Opportunity in a simple chatter post

[SalesForce] Change Opportunity Owner through Developer Console

Related Topic