Attachment trigger

Hello!

Can someone help me with a trigger? I have it together, but there is an issue with the attachment part. It is not attaching. Here is the trigger:

trigger CreateContractDocSignComp on dsfs__DocuSign_Status__c (after update)
{
map<id,id> testmap = new map<id,id>();

list <attachment> attach = new list<attachment>();
List<Contract> ctr = new List<Contract>();

for(dsfs__DocuSign_Status__c dsfs : Trigger.new)
{
if(dsfs.dsfs__Envelope_Status__c == 'Completed')
{
Contract c = new Contract(Name = dsfs.Name,
Status = 'Draft',
Total_Contract_Value__c = dsfs.Total_Contract_Value__c,
ContractTerm = Integer.valueOf(dsfs.Contract_Term_months2__c),
StartDate = dsfs.Contract_Start_Date__c,
Payment_Status__c = 'Ready to be Invoiced',
AccountId = dsfs.dsfs__Company__c,
Opportunity_Name__c = dsfs.dsfs__Opportunity__c,dsfsid__c = dsfs.id);
ctr.add(c);
}
}
if(ctr.size() > 0)
{
System.debug('-ctr------->'+ctr.size());
insert ctr;
}

for(contract con : ctr){
testmap.put(con.dsfsid__c, con.id);
}
system.debug('Testmap size is '+testmap.size());

system.debug('query data'+[select id,parentid,body,name from attachment where parentid in :
testmap.keyset()]);
for(attachment att : [select id,parentid,body,name from attachment where parentid in :
testmap.keyset()]){

if(testmap.containskey(att.parentid)){
attachment a = new attachment(name=att.name,body=att.body,parentid=testmap.get(att.parentid));
attach.add(a);
}
}
system.debug('attach is '+attach);
insert attach;

}

Thanks so much!

October 20, 2015
·
Like
1
·
Follow
5

Best Answer chosen by Shannon Andreas 1

Neetu_Bansal
Hi Shannon,

Try this code:
trigger CreateContractDocSignComp on dsfs__DocuSign_Status__c( after update ) { Map<Id, Contract> docuSignToContractMap = new Map<Id, Contract>(); List<Attachment> attach = new List<Attachment>(); for( dsfs__DocuSign_Status__c dsfs : trigger.new ) { if( dsfs.dsfs__Envelope_Status__c == 'Completed' ) { Contract c = new Contract( Name = dsfs.Name, Status = 'Draft', Total_Contract_Value__c = dsfs.Total_Contract_Value__c, ContractTerm = Integer.valueOf(dsfs.Contract_Term_months2__c), StartDate = dsfs.Contract_Start_Date__c, Payment_Status__c = 'Ready to be Invoiced', AccountId = dsfs.dsfs__Company__c, Opportunity_Name__c = dsfs.dsfs__Opportunity__c, dsfsid__c = dsfs.id ); docuSignToContractMap.put( dsfs.id, c ); } } if( docuSignToContractMap.size() > 0 ) insert docuSignToContractMap.values(); for( Attachment att : [ Select Id, Parentid, Body, Name from attachment where parentid IN: trigger.new ]) { if( docuSignToContractMap.containskey( att.Parentid )) { Attachment a = new Attachment( Name=att.name, body=att.body, Parentid = docuSignToContractMap.get( att.Parentid ).Id ); attach.add( a ); } } if( attach.size() > 0 ) insert attach; }
Let me know, if you need any other help.

Thanks,
Neetu

October 21, 2015
·
Like
0
·
Dislike
0

john4sfdc
Can you post the debug log?

October 20, 2015
·
Like
0
·
Dislike
0

October 20, 2015
·
Like
0
·
Dislike
0

Chandra Sekhar CH N V
I think its the below code which needs to be corrected:

if(testmap.containskey(att.parentid)){ attachment a = new attachment(name=att.name,body=att.body,parentid=testmap.get(att.parentid)); attach.add(a); }

try instead below;
if(testmap.containskey(att.dsfsid__c)){ attachment a = new attachment(name=att.name,body=att.body,parentid=testmap.get(att.dsfsid__c)); attach.add(a); }

October 21, 2015
·
Like
0
·
Dislike
0

This was selected as the best answer

Shannon Andreas 1
Neetu,

I tried your code...no luck.

Two FYIs...

1.) The document is attached using the DocuSign Connect for Salesforce integration.
2.) The dsfsid__c that is attached to the contract when it is created is 18 characters, but the DocuSign record ID is 15 characters.

Do you think it is timing of the trigger? Do you think a separate trigger would work better? Just so you know, the connect feature also attaches the document to the Opportunity, Quote, and Account records.Maybe it makes sense to write the trigger against these objects?

Please let me know your thoughts.

Thanks,

Shannon

October 21, 2015
·
Like
0
·
Dislike
0

Neetu_Bansal
Hi Shannon,

I figure out the reason, actually we have trigger on after update, but attachment will be created after updating the dsfsid__c.

Yes, you need to write trigger on Attachment, means some checks and according to that create new Attachment. If you need any other help, you can contact me either on my gmail id: neetu.bansal.5@gmail.com or Skype id: neetu.bansal.5

Thanks,
Neetu

October 21, 2015
·
Like
1
·
Dislike
0

Shannon Andreas 1
I am definitely going to need your help with the attachment object trigger. I will send an email. Thanks.

October 21, 2015
·
Like
0
·
Dislike
0

Varun29
Need to update Case child object(Work) fields based on Case attachments inserted:- wrote a below code:-

trigger BIIB_GenerateSOB_Autoclosure on Attachment (after insert) { String wi_Item='Generate SOB'; String sr_type='Benefit Investigation'; Set<Id> attachIds = new Set<Id>(); List<Attachment> sr_attachment = new List<Attachment>(); List<BIIB_Work__c> updateSOB_WI = new List<BIIB_Work__c>(); for(Attachment atc: Trigger.new){ if(atc.ParentId.getSobjectType() == Case.SobjectType) attachIds.add(atc.ParentId); } List<BIIB_Work__c> sobWI = [select id,Name,BIIB_Case__r.Id,BIIB_Case__r.BIIB_SR_Type__c from BIIB_Work__c where BIIB_Case__r.Id IN :attachIds and Name=:wi_Item and BIIB_Case__r.BIIB_SR_Type__c =:sr_type limit 49999]; if(sobWI.size()>0) { sr_attachment = [select id from Attachment where ParentId=: sobWI[0].BIIB_Case__r.Id]; } if(!sr_attachment.isEmpty()){ for (BIIB_Work__c work: sobWI){ work.BIIB_Result__c = 'BI Complete' ; work.BIIB_Status__c = 'Closed' ; updateSOB_WI.add(work); } } if(!updateSOB_WI.isEmpty()) Database.update(updateSOB_WI, false); }

August 21, 2018
·
Like
0
·
Dislike
0

You need to sign in to do that.

Need an account? Sign Up

Have an account? Sign In

Dismiss

Browse by Topic

Welcome to Support!

Show

sorted by

Attachment trigger

All Answers

You need to sign in to do that.