question Re: Disable renaming or delete/remove attachment option for a table in Developer forum

Disable renaming or delete/remove attachment option for a table

Community Alums — Wed, 06 Jul 2022 08:59:12 GMT

Hi All,

I have a requirement that "only the user who attached that attachment should be able to rename the attachment or delete/remove the attachment others shouldn't" for a particular table(custom table).

@Ankur Bawiskar Any idea?

Thanks,

Bala

Re: Disable renaming or delete/remove attachment option for a table

Chandu Telu — Wed, 06 Jul 2022 09:07:15 GMT

Hi Balaraju,

Check the below link to hide the rename option you can check the current user and method in below link will hide the Rename Option but it's best practice

https://community.servicenow.com/community?id=community_question&sys_id=a823c3e1dbd8dbc01dcaf3231f961956

Thanks
Chandu Telu
Please Mark ✅ Correct/helpful, if applicable,

Re: Disable renaming or delete/remove attachment option for a table

Community Alums — Wed, 06 Jul 2022 09:16:03 GMT

@Chandu Telu thsanks for replying and this won't solve my requirement

Re: Disable renaming or delete/remove attachment option for a table

Ankur Bawiskar — Wed, 06 Jul 2022 09:28:46 GMT

Hi,

you can try to use before update BR on sys_attachment and check if the logged in user is the created by of that sys_attachment

For Remove/Delete ensure you have correct table level DELETE ACL

Actually both your requirements can be handled via before update/delete business rule

BR: sys_attachment

Before Update AND Delete

Condition: current.table_name == 'incident'

Script:

(function executeRule(current, previous /*null when async*/) {

	// Add your code here
	if(gs.getUserName() != current.sys_created_by){
		gs.addErrorMessage("You are not allowed to update/delete the file as you are not the one who attached it");
		current.setAbortAction(true);
	}

})(current, previous);

regards
Ankur

Re: Disable renaming or delete/remove attachment option for a table

Community Alums — Wed, 06 Jul 2022 10:30:09 GMT

Hi @Ankur Bawiskar Everything is fine but SetAbortAction is not working since we are working in scoped application

Is there any other way to abort?

Re: Disable renaming or delete/remove attachment option for a table

Ankur Bawiskar — Wed, 06 Jul 2022 11:20:53 GMT

Hi,

create BR in your scope and test once.

Regards
Ankur