Business rule to update field on another table / GlideRecord help

[Anna Gausel]

Hi there,

I'm trying to update a field 'u_fixed_asset_id' on the hardware asset table [alm_hardware] whenever it is updated on the fixed asset table. This is what I have so far:

Table: Fixed Assets [alm_fixed_assets]
When to run 'Before' 'insert' 'update'
Filter condition 'Fixed Asset ID' changes

function executeRule(current, previous /*null when async*/) {
	
	// Add your code here
	var fixed_asset = new GlideRecord('alm_hardware');
	fixed_asset.addQuery('u_fixed_asset_id_ref', '');
	fixed_asset.addQuery('u_fixed_asset_id', '');
	fixed_asset.query();
	fixed_asset.next();
	
	gs.log("This is the  " + fixed_asset);
	
	fixed_asset.update(current.u_fixed_asset_id, 'u_fixed_asset_id');
	
})(current, previous);

It is not updating the fixed asset ID from the fixed asset table to the hardware asset table. Any ideas what I have missed?

Cheers,

Anna

[Anna Gausel]

Thanks Skyler - now it is returning the sys_id rather than display value

[The SN Nerd]

If you want this to update all records that match your query, change this line

if( fixed_asset.next() ) {

to this

while( fixed_asset.next() ) {

Please mark as correct if this has solved your issue 🙂

[Anna Gausel]

Thanks all for you help - this is what I'm trying to achieve:

1. Table: Fixed Asset [alm_fixed_assets]
2. Field: fixed_asset (string)
3. Field: u_fixed_asset_id (string)

4. Table: Hardware Asset [alm_hardware]
5. Field: u_fixed_asset_id_ref (references alm_fixed_assets)
6. Field: u_fixed_asset_id (string)

when 3 is updated it should update 6, based on 2 and 5 matching.

Hardware Assets fixed asset ID is automatically updated with the fixed as ID in the fixed assets table, based on the associated fixed asset.

[Allen Andreas]

(function executeRule(current, previous /*null when async*/) {
	// Add your code here
	var fixed_asset = new GlideRecord('alm_hardware');
	fixed_asset.addQuery('u_fixed_asset_id_ref', current.fixed_asset);
	fixed_asset.query();
	if(fixed_asset.next()) {
		fixed_asset.u_fixed_asset_id = current.u_fixed_asset_id;
		fixed_asset.update();
	}	
})(current, previous);

This searching the alm_hardware table for a match between the current record's fixed_asset table and matching it to this custom u_fixed_asset_id_ref field you have on this table.

Once the match is found, it will update the custom u_fixed_asset_id field with the current record's custom u_fixed_asset_id field.

Please mark reply as Helpful/Correct. Thanks!

[Allen Andreas]

Glad you got it figured out. I'd say as far as providing context and what it does, this was provided on my end as well. On this post alone you had two people who actually try to help explain things in addition to providing a solution. On other threads you won't see as much detail.

Take care!