tried to pull the stockroom name in a catalog form not working

[chercm]

how to update the stockroom name based on the assignment group ? 

i tried to use this but stockroom field of the form is still blank 

i created the business rule on it . 

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

// Check if Assignment Group is set

if (current.assignment_group.getDisplayValue() != '') {

// Query the Stockroom based on Assignment Group

var stockroomGR = new GlideRecord('alm_stockroom');

stockroomGR.addQuery('sys_id', current.assignment_group);

stockroomGR.query();

// If a stockroom is found, set the Stockroom field on the catalog form

if (stockroomGR.next()) {

current.stockroom = stockroomGR.getValue('name');

}

}

})(current, previous);

[Robbie · Accepted solution]

Hi @chercm,

Got it. I've spotted a few minor issues based on what you're trying to achieve.

I've tested this on a PDI and can confirm it works as required.

Update the following:

Business Rule. When to run: 'before'

Business Rule Script: (Ready for you to copy and paste)

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

// Check if Assignment Group is set

if (current.assignment_group.getDisplayValue() != '') {

// Query the Stockroom based on Assignment Group

var stockroomGR = new GlideRecord('alm_stockroom');

stockroomGR.addQuery('assignment_group', current.assignment_group);

stockroomGR.query();

// If a stockroom is found, set the Stockroom field on the catalog form

if (stockroomGR.next()) {

current.u_stockroom = stockroomGR.sys_id;

}

}

})(current, previous);

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie

[chercm]

@Harish KM  here is the catalog task table

[Harish KM]

Hi @chercm got it the below code should work, Your BR should be before insert checked,

if (current.assignment_group != '') {
// Query the Stockroom based on Assignment Group
var stockroomGR = new GlideRecord('alm_stockroom');
stockroomGR.addQuery('assignment_group', current.assignment_group);
stockroomGR.query();

// If a stockroom is found, set the Stockroom field on the catalog form
if (stockroomGR.next()) {
current.u_stockroom = stockroomGR.sys_id;
}
}

[chercm]

@Harish KM  does not work with the code provided. i have checked the box for before insert. 

[Harish KM]

Hi @chercm could you please run this code in background script and share the logs?

var stockroomGR = new GlideRecord('alm_stockroom');
stockroomGR.addQuery('assignment_group', 'group sysid'); // pass group sysid here
stockroomGR.query();

// If a stockroom is found, set the Stockroom field on the catalog form
if (stockroomGR.next()) {

gs.info("stock room is-->"+stockroomGR.sys_id);

gs.info("stock room display value-->"+stockroomGR.getDisplayValue());
}
}

[Robbie · Accepted solution]

Hi @chercm,

Got it. I've spotted a few minor issues based on what you're trying to achieve.

I've tested this on a PDI and can confirm it works as required.

Update the following:

Business Rule. When to run: 'before'

Business Rule Script: (Ready for you to copy and paste)

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

// Check if Assignment Group is set

if (current.assignment_group.getDisplayValue() != '') {

// Query the Stockroom based on Assignment Group

var stockroomGR = new GlideRecord('alm_stockroom');

stockroomGR.addQuery('assignment_group', current.assignment_group);

stockroomGR.query();

// If a stockroom is found, set the Stockroom field on the catalog form

if (stockroomGR.next()) {

current.u_stockroom = stockroomGR.sys_id;

}

}

})(current, previous);

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

Thanks, Robbie