How to get SYS_ID from attachment table

Rushi2
Tera Expert

I have 3 attachments on catalog , all are showing same sys_id . I am trying to open one record those are downloading . i want to get sys_id of specific attachment. 

Please suggest me how to get single record sys_id. i want to get sys_id of picture and which is cancelled.

find_real_file.png

7 REPLIES 7

BryanS413339635
Tera Guru

Right click on file name and select Copy Sys ID

 

If my reply helped in any way, please mark it as Helpful/Correct as applicable. Thanks!

Ashok Kumar Am1
Giga Expert

Hi Rushi,

Table Sys ID stores the sysID of the record for which attachments are linked i.e in your case its cat item's sysID. To copy sysID of the attachment record right click on filename and copy sys_id.

 

Example: Right click on file name 'picture' and then click on copy sysid.

Hope this helps.

Jaspal Singh
Mega Patron
Mega Patron

Hi Rushi,

 

That is the sys_id of RITM. If you will to get the sys_id of record you can do a Copy sys_id.

find_real_file.png

Rushi2
Tera Expert

Hi All,

 

I am trying to attach file on RITM , there is 3 attachments . out of 3 i want to attach only one attachment . can you please suggest , how to avoid 2 attachments .

 

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

// Add your code here
if(current.cat_item=='8f6cbf0edbc50c105f333a0f9d96193d'){
//GlideSysAttachment.copy('sc_cat_item', '8f6cbf0edbc50c105f333a0f9d96193d', current.getTableName(), current.sys_id);

}

})(current, previous);