- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2020 10:00 AM
HI TEAM,
when to run-BEFORE
table-sys_attachment
I WANT THE BELOW BUSINESS TO RULE ON PARTICULAR CATALOG ITEM
/////Business rule///when 2 files are attached with same file name then there will be alert in below BR
(function executeRule(current, previous /*null when async*/) {
{
var gr = new GlideRecord("sys_attachment");
gr.addQuery('table_sys_id', current.table_sys_id);
gr.addQuery('table_name', current.table_name);
gr.addQuery('file_name', current.file_name);
gr.addQuery('content_type', current.content_type);
gr.addQuery('size_bytes', current.size_bytes);
gr.query();
if (gr.next()) {
{
current.setAbortAction(true);
gs.addInfoMessage("File already exist");
}}
})(current, previous);
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2020 10:23 AM
you can not , business rule runs on table and catalog form is not a table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2020 11:26 AM
hey Chaitanya ,
thanks for the reply.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2020 11:29 AM
yes im trying restrict the user to attach more than 1 file with the same name on the catalog form . I tried using script include and client script but Im not able achieve my requirement

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2020 12:06 PM
Thanks for the confirmation, could you please share the scripts which you are using so that it will be easy to debug the issue in script
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-25-2020 11:29 AM
yes im trying restrict the user to attach more than 1 file with the same name on the catalog form . I tried using script include and client script but Im not able achieve my requirement