How to elimiate duplicate attachment in inbound actions

ravichanduk
Mega Expert

Hi i have an req using inbound actions

I sent mail with attachments ( A and B) on other day i sent one more mail with attachments (A and B)

incident was created but attachments should not load it give the previously loaded attachment data 

is it possible if yes can you tell me the way 

or 

any business rule we should create ???????

6 REPLIES 6

No this one also doesnt work

but i got this using inbound email actions 

var duplicate = false;

var ext_incident = '';

var at ='';

var gr_att = new GlideRecord('sys_attachment');

gr_att.addQuery('table_sys_id',sys_email.sys_id);

gr_att.query();

//gs.log('Email Attachment count:'+gr_att.getRowCount());

var names= [];

while(gr_att.next())

{

names.push(gr_att.file_name.toString());

var gr_attt = new GlideRecord('sys_attachment');

gr_attt.addQuery('file_name',gr_att.file_name);

gr_attt.addQuery('table_name','incident');

gr_attt.query();

if(gr_attt.next()){

duplicate = true;

ext_incident = gr_attt.table_sys_id;}

//at = gr_att.file_name;,//at = gr_att.file_name != '';}

current.u_attach = names.toString();

current.u_duplicate = duplicate;(Ur created checkbox true or false)

current.u_attachment_reference = ext_incident;(ur created field with reference Incident table)

current.setWorkflow(false);

current.update();

ravichanduk
Mega Expert

But i need using business rule dont know how to acheive this tried some ways but still now not yet acheived