How to implement value association between different fields of two tables?

[shiz]

1.I have two tables, u_actuant_times and u_actuant_times_details, both of which have the u_assigend_to field. 2.Among them, the associated fields of u_actuant_times_details and u_actuant_times are u_ ref Monday, u_ ref Tuesday... u_ ref Sunday.

3.Now I want to implement the following function: when I modify the value of the u_assigend_to field in u_actuant_times, I also modify the value of the u_assigend_to field in the u_actuant_times_details table.

How should the above functions be implemented?

The above figure shows the u_ actual times table

The red box shows the structure of the u_actuant_times_tail table

I want to change the value of 'Assigned to' in u_actual_times in real-time after modifying the 'assigned to' in u'actual_times_detail. How to achieve it?

[RaghavSh]

after update BR is the answer.

On "u'actual_times_detail" table write the after update BR and glide the another table and update the values.

Please mark the answer correct/helpful accordingly.

[shiz]

I have created a BR for 'after' in u'actual_times_tail, but I cannot obtain the sys_id for u'actual_times_tail.

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

    // 再帰呼び出しを防止するためのフラグ

    // このルールが自身を再トリガーするのを防ぐ

    var session = gs.getSession();

    var flag = 'sync.u_actual_times_detail.running';

    if (session.getProperty(flag) == 'true') {

        return;

    }

    // u_actual_times を参照するフィールド名のリスト

    var refFields = [

        'u_ref_sunday', 'u_ref_monday', 'u_ref_tuesday', 'u_ref_wednesday',

        'u_ref_thursday', 'u_ref_friday', 'u_ref_saturday'

    ];

    var actualTimesSysId = '';

    // 値が設定されている参照フィールドを検索

    for (var i = 0; i < refFields.length; i++) {

        if (current.getValue(refFields[i])) {

            actualTimesSysId = current.getValue(refFields[i]);

            break;

        }

    }

    if (!actualTimesSysId) {

        return; // 有効な参照がない場合は処理を終了

    }

    var actualTimesAssignedTo = '';

    var actualTimesGr = new GlideRecord('u_actual_times');

    if (actualTimesGr.get(actualTimesSysId)) {

        actualTimesAssignedTo = actualTimesGr.getValue('u_assigned_to');

        // 担当者が異なる場合のみ更新処理を実行

        if (current.getValue('u_assigned_to') !== actualTimesAssignedTo) {

            try {

                // 更新操作の前に再帰防止フラグを設定

                session.putProperty(flag, 'true');

                // Afterルールの為、直接currentを更新し、update()を呼び出す必要がある

                var detailGr = new GlideRecord('u_actual_times_detail');

                if (detailGr.get(current.getUniqueValue())) {

                    detailGr.setValue('u_assigned_to', actualTimesAssignedTo);

                    detailGr.update();

                }

            } finally {

                // 処理が完了または失敗した場合でも、必ずフラグを解除

                session.putProperty(flag, null);

            }

        }

    }

})(current, previous);

[Ravi Gaurav]

Hi @shiz 

Below demo code will help :- 

Use an After Update Business Rule on the u_actuant_times table.
When u_assigned_to changes, update the same field in related records of u_actuant_times_details.

Example:

(function executeRule(current, previous) { if (current.u_assigned_to.changes()) { var gr = new GlideRecord('u_actuant_times_details'); gr.addQuery('u_ref_Monday', current.sys_id) .addOrCondition('u_ref_Tuesday', current.sys_id) .addOrCondition('u_ref_Wednesday', current.sys_id) .addOrCondition('u_ref_Thursday', current.sys_id) .addOrCondition('u_ref_Friday', current.sys_id) .addOrCondition('u_ref_Saturday', current.sys_id) .addOrCondition('u_ref_Sunday', current.sys_id); gr.query(); while (gr.next()) { gr.u_assigned_to = current.u_assigned_to; gr.update(); } } })(current, previous);

This keeps both tables in sync whenever the Assigned To changes in the main table.

[Ankur Bawiskar]

@shiz 

how are both the tables linked?

what did you start with and where are you stuck?