Apex Code Development You need to sign in to do that
Don't have an account?
ExpertNOT Apex to copy files from one record to another
I have a process where an email service (custom) cretes a CASE with attachments converted to files. I then using Visual Flow create a custom record Purchase_Order__c and fill out some fielsd. I would like to attach the FILES to the new Purchase_Order__c record with in the Visual Flow. Can someone point me on how to copy files from one record to another. I was thinking of calling APEX in the Visual flow. Thanks
It compiles OK but no Attachments from the Case are copied.
Public class CopyAttachments { @InvocableMethod (label='Copy attachments from Soruce to Destination' description='Copy attachments from SourceID to DestID') public static void SourceIDs (List<id> SourceID ) { String DestID; List<Case> cs = [Select Id, Purchase_Order__c from Case where Id=:SourceID]; DestID = cs[0].Purchase_Order__c; Purchase_Order__c po = [Select Id, Name from Purchase_Order__c where Id = :DestID]; Attachment[] attList = [SELECT Body,BodyLength,ContentType,Description,Id,Name,ParentId FROM Attachment where ParentId =: cs[0].Id]; Attachment[] insertAttList = new Attachment[]{}; System.debug('==========================attList:'+attList); for(Attachment a: attList) { Attachment att = new Attachment(name = a.name, body = a.body, parentid = DestId); insertAttList.add(att); } if(insertAttList.size() > 0) { insert insertAttList; } } }List<Case> cs = [Select Id, Purchase_Order__c from Case where Id IN:SourceID];
SourceId is a list so you have to use IN
Public class CopyAttachments { @InvocableMethod (label='Copy attachments from Soruce to Destination' description='Copy attachments from SourceID to DestID') public static void CopyFile (List<id> SourceID ) { String DestID; List<Case> cs = [Select Id, Purchase_Order__c from Case where Id IN:SourceID]; DestID = cs[0].Purchase_Order__c; Purchase_Order__c po = [Select Id, Name from Purchase_Order__c where Id = :DestID]; Attachment[] attList = [SELECT Body,BodyLength,ContentType,Description,Id,Name FROM Attachment where ParentId =:cs[0].Id]; Attachment[] insertAttList = new Attachment[]{}; System.debug('==========================attList:'+attList); for(Attachment a: attList) { Attachment att = new Attachment(name = a.name, ContentType = a.ContentType, body = a.body, ParentId = DestId); insertAttList.add(att); } if(insertAttList.size() > 0) { insert insertAttList; } } }Here is my test
@isTest public class CopyAttachmentTEST { private static testMethod void myTest(){ test.startTest(); Profile pf = [Select Id from Profile where Name = 'System Administrator']; User u = new User(); u.FirstName = 'Test'; u.LastName = 'User'; u.Email = 'testuser@test123456789.com'; u.CompanyName = 'test.com'; u.Title = 'Test User'; u.Username = 'friend@quadrantsoftware.com'; u.Alias = 'testuser'; u.CommunityNickname = 'Test User'; u.TimeZoneSidKey = 'America/Mexico_City'; u.LocaleSidKey = 'en_US'; u.EmailEncodingKey = 'ISO-8859-1'; u.ProfileId = pf.Id; u.LanguageLocaleKey = 'en_US'; insert u; system.runAs(u){ u=[Select Id,Name FROM User WHERE Id= :u.Id]; // Create an Account Account a = new Account(); a.Name = 'Test'; a.Site = 'Home'; insert a; a=[Select Id,Name FROM Account WHERE Id= :a.Id]; //Create Master Opportunity Opportunity oppMas = new Opportunity(); oppMas.name='MasterTest'; oppMas.accountId =a.id; oppMas.stageName='Qualified'; oppMas.CloseDate=System.today(); oppMas.Segue_Customer_Service_Rep__c = u.Id; insert oppMas; // Get Opportunity ID oppMas=[Select Id,Name FROM Opportunity WHERE Id= :oppMas.Id]; // Create New CASE Case cas =new Case(); cas.Build_Location__c='Lowell'; cas.RFQ_Opportunity__c = oppMas.id; cas.Status = 'RFQ Initiated'; insert cas; // Get Case ID cas=[Select Id,CaseNumber FROM Case WHERE Id= :cas.Id]; // Create Purchase Order Purchase_Order__C po = new Purchase_Order__c(); po.Account__c = a.Id; po.Customer_PO_Number__c = '1234'; po.Purchase_Order_Value__c= 34; po.Purchase_Order_Date__c =System.today(); po.Master_Opportunity__c = oppMas.id; insert po; po = [Select Id, Name FROM Purchase_Order__c WHERE Id= :po.Id]; String oppid = oppMas.Id; String casid = cas.Id; String poID = po.Id; Attachment attachment=new Attachment(); attachment.Name='Unit Test Attachment'; Blob bodyBlob=Blob.valueOf('Unit Test Attachment Body'); attachment.Body=bodyBlob; attachment.parentId=casid; attachment attach; // excute method CopyAttachments.CopyFile(New Case[]{cas}); } } }Public class CopyAttachments { @InvocableMethod (label='Copy attachments from Soruce to Destination' description='Copy attachments from SourceID to DestID') public static List<String> CopyFile (List<id> SourceID ) { String DestID; List<Case> cs = [Select Id from Case where Id IN:SourceID]; List<Case> cspo = [Select Id, Purchase_Order__c from Case where Id IN:SourceID]; DestID = cspo[0].Purchase_Order__c; List<Purchase_Order__c> poList = [Select Id, Name from Purchase_Order__c where Id = :DestID]; //Create a list for Returning results List<String> ResultList = new List<String> (); // PROBLEM NOT FINDING ATTACHMENTS ON THE CASE Attachment[] CaseList = [SELECT ID, Name, Body, ContentType from Attachment where ParentId IN :SourceID]; Attachment[] insertAttList = new Attachment[]{}; System.debug('==========================attList:'+CaseList); for(Attachment a: CaseList) { Attachment att = new Attachment(name = a.Name, ContentType = a.ContentType, Body = a.Body, ParentId = DestID); insertAttList.add(att); } if(insertAttList.size() > 0) { insert insertAttList; ResultList.add('Files Copied Insert'); Return ResultList; } else { ResultList.add(DestID); Return ResultList; } } }@isTest public class CopyAttachmentTEST { private static testMethod void myTest(){ test.startTest(); Profile pf = [Select Id from Profile where Name = 'System Administrator']; User u = new User(); u.FirstName = 'Test'; u.LastName = 'User'; u.Email = 'testuser@test123456789.com'; u.CompanyName = 'test.com'; u.Title = 'Test User'; u.Username = 'friend@quadrantsoftware.com'; u.Alias = 'testuser'; u.CommunityNickname = 'Test User'; u.TimeZoneSidKey = 'America/Mexico_City'; u.LocaleSidKey = 'en_US'; u.EmailEncodingKey = 'ISO-8859-1'; u.ProfileId = pf.Id; u.LanguageLocaleKey = 'en_US'; insert u; system.runAs(u){ u=[Select Id,Name FROM User WHERE Id= :u.Id]; // Create an Account Account a = new Account(); a.Name = 'Test'; a.Site = 'Home'; insert a; a=[Select Id,Name FROM Account WHERE Id= :a.Id]; //Create Master Opportunity Opportunity oppMas = new Opportunity(); oppMas.name='MasterTest'; oppMas.accountId =a.id; oppMas.stageName='Qualified'; oppMas.CloseDate=System.today(); oppMas.Segue_Customer_Service_Rep__c = u.Id; insert oppMas; // Get Opportunity ID oppMas=[Select Id,Name FROM Opportunity WHERE Id= :oppMas.Id]; // Create New CASE Case cas = new Case(); cas.Build_Location__c='Lowell'; cas.RFQ_Opportunity__c = oppMas.id; cas.Status = 'RFQ Initiated'; insert cas; // Get Case ID cas=[Select Id,CaseNumber FROM Case WHERE Id= :cas.Id]; // Create Purchase Order Purchase_Order__C po = new Purchase_Order__c(); po.Account__c = a.Id; po.Customer_PO_Number__c = '1234'; po.Purchase_Order_Value__c= 34; po.Purchase_Order_Date__c =System.today(); po.Master_Opportunity__c = oppMas.id; insert po; po = [Select Id, Name FROM Purchase_Order__c WHERE Id= :po.Id]; String oppid = oppMas.Id; String casid = cas.Id; String poID = po.Id; //Create a List of Case IDs. Needed to test the method as it takes a List List<String> CaseIds = new List<String> (); CaseIds.add(casid); Attachment attachment=new Attachment(); attachment.Name='Unit Test Attachment'; Blob bodyBlob=Blob.valueOf('Unit Test Attachment Body'); attachment.Body=bodyBlob; attachment.parentId=casid; attachment attach; insert attachment; // excute method CopyAttachments.CopyFile(CaseIds); }can anyone help me