How to set watchlist user based on account in case table

[sriram35]

Hi Team,

I want to set watchlist user on case table, based Account then contact Relationships. In contact Relationships I have 3 contacts I need to all the three in watchlist field once they select that Account.

[Ankur Bawiskar]

@sriram35 

so when case is created you can fetch the contact relationships using the account field on Case

what did you start with and where are you stuck?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[sriram35]

@Ankur Bawiskar 

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

    if (!current.account) {
        return;
    }

    var watchlistUsers = [];

    var gr = new GlideRecord('sn_customerservice_contact_relationship'); // Contact Relationships table
     gr.addQuery('company', current.account); 

    while (gr.next()) {
        if (gr.contact) { 
            watchlistUsers.push(gr.contact.toString()); 
        }
    }

    if (watchlistUsers.length > 0) {
        current.watch_list = watchlistUsers.join(','); // Update Watchlist field
    }

})(current, previous);

[Chaitanya ILCR]

Hi @sriram35 ,

the query statement is missing in the script 

try this

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

    if (!current.account) {
        return;
    }

    var watchlistUsers = [];

    var gr = new GlideRecord('sn_customerservice_contact_relationship'); // Contact Relationships table
    gr.addQuery('company', current.account);
    gr.query();

    while (gr.next()) {
        if (gr.contact) {
            watchlistUsers.push(gr.getValue('contact'));
        }
    }

    if (watchlistUsers.length > 0) {
        current.watch_list = watchlistUsers.join(','); // Update Watchlist field
    }

})(current, previous);

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

Regards,
Chaitanya

[Ankur Bawiskar]

@sriram35 

please add this line and see if it works

    gr.query();

If my response helped please mark it correct and close the thread so that it benefits future readers.