Business rule issue

[Gopal14]

Hello,

I want to create a new field called Attachment and type is True/False on Case table.  If a case has an attachment, it should mark the field as true and if not, it should remain false. 

Below is my field

Business Rule:

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

	if (current.table_name !== 'sn_customerservice_case') {
        return;
    }

    var caseId = current.table_sys_id;

    var attachmentGR = new GlideRecord('sys_attachment');
    attachmentGR.addQuery('table_name', 'sn_customerservice_case');
    attachmentGR.addQuery('table_sys_id', caseId);
    attachmentGR.query();

    var hasAttachments = attachmentGR.hasNext();
  
    var caseGR = new GlideRecord('sn_customerservice_case');
    if (caseGR.get(caseId)) {
        if (caseGR.u_attachment !== hasAttachments) {
            caseGR.u_attachment = hasAttachments;
            caseGR.update();
        }
    }
})();

I have written after insert delete BR,  above is my code, I have attached a attachment in one of the case record in case table.

I have added that field in list view, always it is showing as false

[SuyashJ41731830]

Hi
@Gopal14 
Try this

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

// Only act on attachments related to Case table
if (current.table_name !== 'sn_customerservice_case') {
return;
}

var caseId = current.table_sys_id;

// Check if any attachments exist for this case
var attachmentGR = new GlideRecord('sys_attachment');
attachmentGR.addQuery('table_name', 'sn_customerservice_case');
attachmentGR.addQuery('table_sys_id', caseId);
attachmentGR.query();

var hasAttachments = attachmentGR.hasNext();

// Update the Case record's u_attachment field
var caseGR = new GlideRecord('sn_customerservice_case');
if (caseGR.get(caseId)) {
if (caseGR.u_attachment != hasAttachments) {
caseGR.u_attachment = hasAttachments;
caseGR.update();
}
}

})();

Regards,
Suyash

[Chaitanya ILCR]

HI @Gopal14 ,

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

	if (current.getValue('table_name') != 'sn_customerservice_case') { //better add this in the BR condition it self
        return;
    }

    var caseId = current.getValue('table_sys_id');

    var attachmentGR = new GlideRecord('sys_attachment');
    attachmentGR.addQuery('table_name', 'sn_customerservice_case');
    attachmentGR.addQuery('table_sys_id', caseId);
    attachmentGR.query();

    var hasAttachments = attachmentGR.hasNext();
  
    var caseGR = new GlideRecord('sn_customerservice_case');
    if (caseGR.get(caseId)) {
        if (caseGR.u_attachment != hasAttachments) {
            caseGR.u_attachment = hasAttachments;
            caseGR.update();
        }
    }
})();

try this

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya

[Gopal14]

@Chaitanya ILCR  

I have updated the code as per your suggestion,

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

	if (current.getValue('table_name') !== 'sn_customerservice_case') {
        return;
    }

    var caseId = current.getValue('table_sys_id');

    var attachmentGR = new GlideRecord('sys_attachment');
    attachmentGR.addQuery('table_name', 'sn_customerservice_case');
    attachmentGR.addQuery('table_sys_id', caseId);
    attachmentGR.query();

    var hasAttachments = attachmentGR.hasNext();
  
    var caseGR = new GlideRecord('sn_customerservice_case');
    if (caseGR.get(caseId)) {
        if (caseGR.u_attachment !== hasAttachments) {
            caseGR.u_attachment = hasAttachments;
            caseGR.update();
        }
    }
})();

I have added a attachment for one of the case record

In the list of the case attachment field is showing as false.

[Chaitanya ILCR]

Hi @Gopal14 ,

update the BR like this

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

    var caseGr = new GlideRecord('sn_customerservice_case');

    if (caseGr.get(current.table_sys_id)) {
        var operation = current.operation();

        if (operation == 'insert') {
            caseGr.u_attachment = true;
            caseGr.update();
        } else {
            var attGr = new GlideRecord('sys_attachment');
            attGr.addEncodedQuery('table_name=sn_customerservice_case^table_sys_id=' + current.table_sys_id);
            attGr.query();
            caseGr.u_attachment = attGr.hasNext();
            caseGr.update();
        }
    }


})(current, previous);

alternative approach

if you can create the BR in Global scope here is the simple script

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

	// Add your code here
	var caseGr = new GlideRecord('sn_customerservice_case');
	if(caseGr.get(current.table_sys_id)){
		caseGr.u_attachment = caseGr.hasAttachments();
		caseGr.update();
	}

})(current, previous);

Please mark my answer as helpful/correct if it resolves your query.

Regards,
Chaitanya