question Delete duplicate attachment script not working in Developer forum

Delete duplicate attachment script not working

Maddysunil — Sun, 02 Jun 2024 02:13:12 GMT

Hi Everyone, I have written a script action in human resource:core application where i am trying to delete duplicate attachment from case form, i am getting all the logs still attachment is not getting deleted.

Below is the business rule from where i am calling the script action after 5 seconds

var caseSysID = current.parent; var caseGr = new GlideRecord('sn_hr_core_case_talent_management'); caseGr.addQuery('sys_id', caseSysID.toString()); caseGr.query(); if (caseGr.next()) { var hrService = caseGr.hr_service; } var complianceReview = gs.getProperty('sn_hr_core.compliance_review'); if (hrService == complianceReview) { //Delete duplicate attachments only for compliance var wait5sec = new GlideDateTime(); wait5sec.addSeconds(5); // 5 sec in the future. gs.eventQueueScheduled('sn_hr_core.duplicate.attachment.on.case', current, '', '', wait5sec); }

Any help will be appreciated ..Thanks

Re: Delete duplicate attachment script not working

Maik Skoddow — Sun, 02 Jun 2024 03:14:05 GMT

Remove the

attachGr.update();

after

attachGr.deleteRecord();

Re: Delete duplicate attachment script not working

Maddysunil — Sun, 02 Jun 2024 03:17:09 GMT

Hi @Maik Skoddow I tried without attachGr.update() still not working

Re: Delete duplicate attachment script not working

Sandeep Rajput — Sun, 02 Jun 2024 03:57:00 GMT

@Maddysunil Try to put your code responsible for deletion of attachment inside a script include in the Global scope and call the same script include from your script action in HR Scope. I faced the similar issue in the past and I managed to address the issue by putting the deleteRecord operation the the Global scope.

Hope this helps.

Re: Delete duplicate attachment script not working

Maddysunil — Mon, 03 Jun 2024 02:59:35 GMT

@Sandeep Rajput

I tried with that still it was not able to delete..So i tried with an alternative approach and its working, I wrote before insert BR on attachment table itself and for duplicate attachment i aborted the action, below is the working code:

if (current.table_name == 'sn_hr_core_case_talent_management') { var caseSysID = current.table_sys_id.toString(); var caseGr = new GlideRecord('sn_hr_core_case_talent_management'); caseGr.addQuery('sys_id', caseSysID); caseGr.query(); if (caseGr.next()) { var complianceReview = gs.getProperty('sn_hr_core.compliance_review'); if (caseGr.hr_service == complianceReview) { var attachGr = new GlideRecord('sys_attachment'); attachGr.addQuery('table_sys_id', caseSysID); attachGr.addQuery('file_name', current.file_name.toString()); attachGr.query(); if (attachGr.next()) { current.setAbortAction(true); } } } }

Re: Delete duplicate attachment script not working

wenzhenz — Mon, 03 Jun 2024 04:15:47 GMT

@Maddysunil

I tried below code，and it works in global scope, but failed in other scopes。
※Delete operation against 'sys_attachment' from scope 'x_615438_testx' has been refused due to the table's cross-scope access policy

Open the table's configration page and check on the "Can delete" in "Application Access " tab.