Apex Code Development You need to sign in to do that
Don't have an account?
XIO Help with using LIKE variable
Hello,
I have the trigger below thats retrieving the FeedItem File ID but I need it to only retrieve the file ID from files that have the word "SOW" in the file name. Any assistance is greatly appreciated.
I have the trigger below thats retrieving the FeedItem File ID but I need it to only retrieve the file ID from files that have the word "SOW" in the file name. Any assistance is greatly appreciated.
trigger FeedItemIDOppty on FeedItem (after insert, after update) {
List<Opportunity> O = [select id, File_ID__c from Opportunity where id =: Trigger.new[0].ParentId];
for(FeedItem fi : trigger.new){
FeedItem fiii =[SELECT Body, (SELECT RecordId, Title, Type, Value FROM FeedAttachments)
FROM FeedItem
WHERE Id =: fi.Id];
O[0].File_ID__c=fiii.FeedAttachments[0].Id ;
update O ;
}
}
trigger FeedItemIDOppty on FeedItem (before insert,after insert,before update,after update) { List<Opportunity> O = [select id, File_ID__c from Opportunity where id =: Trigger.new[0].ParentId]; for(FeedItem fi : trigger.new) if(O.size()>0 && fi.Title.Contains('SOW')) O[0].File_ID__c = fi.ID; update O; }All Answers
trigger FeedItemIDOppty on FeedItem (after insert, after update) { List<Opportunity> O = [select id, File_ID__c from Opportunity where id =: Trigger.new[0].ParentId]; for(FeedItem fi : trigger.new){ FeedItem fiii =[SELECT Body, (SELECT RecordId, Title, Type, Value FROM FeedAttachments) FROM FeedItem WHERE Id =: fi.Id]; For(FeedAttachment atts : fiii.FeedAttachments){ if(atts.Title.Contains('SOW')){ O[0].File_ID__c=fiii.FeedAttachments[0].Id ; update O ; } } } }I got this error
trigger FeedItemIDOppty on FeedItem (after insert, after update) { List<Opportunity> O = [select id, File_ID__c from Opportunity where id =: Trigger.new[0].ParentId]; for(FeedItem fi : trigger.new){ FeedItem fiii =[SELECT Body, (SELECT RecordId, Title, Type, Value FROM FeedAttachments) FROM FeedItem WHERE Id =: fi.Id]; For(FeedAttachment atts : fiii.FeedAttachments){ if(atts.Title.Contains('SOW') && atts.Title!=null){ O[0].File_ID__c=atts.Id ; update O ; } } } }trigger FeedItemIDOppty on FeedItem (before insert,after insert,before update,after update) { List<Opportunity> O = [select id, File_ID__c from Opportunity where id =: Trigger.new[0].ParentId]; for(FeedItem fi : trigger.new) if(O.size()>0 && fi.Title.Contains('SOW')) O[0].File_ID__c = fi.ID; update O; }