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'

[kunal16]

I did wrote a business rule "'Has Attachment' on delete" but still dint worked

[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)

{

"u_has_attachment " this field available on task table i told gliderecord inside the if condition and update the record.

I dont know what is the relation to attachment table and task table. I think you must know it

give that ref and filter then update task table

var gr = new GlideRecord('task');

gr.addQuery();//give what you have relation

gr.query();

if(gr.next())

{

    gr.u_has_attachment = "false";

    gr.update();

}

}