Remove attachment from a change request

[Dead Blade]

Hello All, I am having difficulties removing iCalendar attachments from a Change Request.

I am aware of community post: Removing attachments using GlideSysAttachment

I may be using this wrong in a business rule.

var attach = new GlideSysAttachment();


attach.deleteAll(recordGR);

But further, can I only remove iCalendar attachments?

[sachin_namjoshi]

you will have to query sys_attachment table and then delete attachments.

Regards,

Sachin

[Dead Blade]

Hi Sachin, do you have an example?

[sachin_namjoshi]

Please see below code

var gr = new GlideRecord("sys_attachment");
	gr.addQuery("table_sys_id", current.sys_id); // sys_id is table_sys_id
	gr.addQuery("file_name", current.start_at);// update file name as per your instance config
	gr.query();
	while(gr.next())
		gr.deleteRecord();
}
	

[Dead Blade]

Thank you Sachin, works perfectly