How to return the right record from the script condition in action Lookup Record in Flow Designer

LinhN
Tera Contributor

‎08-27-2024 03:14 AM

Hi guys, I am writing a script to add a condition for lookup Record. 

I have a sub-flow with the input of a variable reference to a table (kind)

The script as below 

var inputSysId = fd_data.subflow_inputs.kind;
gs.info('Input value: ' + inputSysId);
var inputName;
var condition;
var grmodel = new GlideRecord('cmdb_model');

if (inputSysId) {
    if (grmodel.get(inputSysId)) {
        inputName = grmodel.getValue('name');
        gs.info('Input name: ' + inputName);
    } 
} 

var gr = new GlideRecord('sys_properties');

if (inputName == 'common') {
    gr.addQuery('name', 'common_balance');
} else if (inputName == 'medium') {
    gr.addQuery('name', 'medium_balance');
} else if (inputName == 'advance') {
    gr.addQuery('name', 'advanced_balance');
}

gr.query();
if (gr.next()) {
    condition = gr.getValue('name');
    gs.info('Property found: ' + condition);
} else {
    gs.info('No property found for input: ' + inputName);
}
gs.info('Condition to be used: ' + condition);
return condition;

  But it now returns a different record from sys_properties table. I want to return the record which is as sam as the condition I found. How can I return it right?   

LinhN_0-1724753666280.png

 

0 Helpfuls
  • 261 Views
3 REPLIES 3

Sandeep Rajput
Tera Patron
Tera Patron

‎08-27-2024 03:39 AM

@LinhN Did you try to run the same query using a background/fix script? If not, can you try to replicate the same query via a background script and see what condition it prints in the logs?

0 Helpfuls

LinhN
Tera Contributor
In response to Sandeep Rajput

‎08-27-2024 08:52 AM

Yes, I've already tried with scripts-background and it printed the expected result. But when applying to lookup records, it returned a different record of sys_properties table glide.ui.specify.dbname; Could you help me know the reason of this?

0 Helpfuls

Sandeep Rajput
Tera Patron
Tera Patron
In response to LinhN

‎08-27-2024 10:18 AM

@LinhN Please test the following and see if it works.

 

var inputSysId = fd_data.subflow_inputs.kind+'';
gs.info('Input value: ' + inputSysId);
var inputName;
var condition;
var grmodel = new GlideRecord('cmdb_model');

if (inputSysId) {
    if (grmodel.get(inputSysId)) {
        inputName = grmodel.getValue('name');
        gs.info('Input name: ' + inputName);
    } 
} 

var gr = new GlideRecord('sys_properties');

if (inputName.trim() == 'common') {
    gr.addQuery('name', 'common_balance');
} else if (inputName.trim() == 'medium') {
    gr.addQuery('name', 'medium_balance');
} else if (inputName.trim() == 'advance') {
    gr.addQuery('name', 'advanced_balance');
}

gr.query();
if (gr.next()) {
    condition = gr.getValue('name');
    gs.info('Property found: ' + condition);
} else {
    gs.info('No property found for input: ' + inputName);
}
gs.info('Condition to be used: ' + condition);
return condition;

Made slight changes to your script, please check if they work.

0 Helpfuls