Update field based on attachment

[kunal16]

I have a field 'Has Attachment'(check box) on task table. I want to set the value on this field based on attachment, i.e., if there is any attachment attached to the form, the field 'Has Attachment' should set to 'true'; or else 'false'

[Harish Murikina]

If you write this code after delete it can work try this once

var att = new GlideRecord('task');

att.addQuery('sys_id',current.table_sys_id);

att.query();

gs.log('test attachment ' + att.getRowCount());

if(!att.next())

{

  att.u_has_attachment = "false";

att.update();

}

[kunal16]

No Harish, it didn't work

[Harish Murikina]

Write before delete BR on table sys_attchmnet and let me know

var att = new GlideRecord('sys_attachment');

att.addQuery('sys_id',current.table_sys_id);

att.query();

gs.log('test attachment ' + att.getRowCount());

if(att.getRowCount()<=1)

{

    att.u_has_attachment = "false"; // Please tell me this variable "u_has_attachment " is available on which table

    att.update();

}

[kunal16]

The field 'Has Attachment' is a check box on 'task' table

[Harish Murikina]

ok write gliderecord on task table and update it