We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Get Answer From Decision Table

anirban300
Kilo Guru

Hello All,

 

I want to get the 'answer' from the decision table

anirban300_0-1677918514620.png

 

I am using the following decision table API in script:

 

var dt = new sn_dt.DecisionTableAPI();
var input = new Object();
input['u_keywords'] = 'HR case - new hire - mover';
var response = dt.getDecisions('78e5e46d1b6c5554e2e6cbf2164bcb09', input);
var firstRecord = response[0];
gs.print(JSON.stringify(firstRecord));

 

I am getting the following response:

 

[{"sys_meta":{"active":"1","array":"0","attributes":"metadata_link_exempt=true,no_audit_delete=true","audit":"0","calculation":"","choice":"0","choice_field":"","choice_table":"","create_roles":"","default_value":"","delete_roles":"","dependent":"","dependent_on_field":"","display":"label","dynamic_creation":"0","dynamic_creation_script":"","dynamic_default_value":"","dynamic_ref_qual":"","element_reference":"0","filterable":"1","foreign_database":"","function_definition":"","function_field":"0","groupable":"1","help":"","hint":"","i18n_sortable":"1","internal_type":"collection","label":"Choice","language":"en","mandatory":"0","matchable":"1","max_length":"40","multi_text":"0","name":"sys_choice","plural":"Choices","primary":"0","read_only":"0","read_roles":"","reference":"","reference_cascade_rule":"","reference_floats":"0","reference_key":"","reference_qual":"","reference_qual_condition":"","reference_type":"","sizeclass":"1119493","sortable":"1","spell_check":"0","staged":"0","sys_package":"","sys_scope":"global","table_reference":"0","text_index":"0","type":"0","type_description":"collection","unique":"0","url":"","url_target":"","use_dynamic_default":"0","use_reference_qualifier":"simple","virtual":"0","widget":"","write_roles":"","xml_view":"0"},"dependent_value":{},"synonyms":{},"sys_mod_count":{},"language":{},"label":{},"sys_updated_on":{},"sys_domain_path":{},"sys_tags":{},"sequence":{},"sys_id":{},"inactive":{},"sys_updated_by":{},"sys_created_on":{},"hint":{},"sys_domain":{},"name":{},"value":{},"sys_created_by":{},"element":{}},{"sys_meta":{"active":"1","array":"0","attributes":"metadata_link_exempt=true,no_audit_delete=true","audit":"0","calculation":"","choice":"0","choice_field":"","choice_table":"","create_roles":"","default_value":"","delete_roles":"","dependent":"","dependent_on_field":"","display":"label","dynamic_creation":"0","dynamic_creation_script":"","dynamic_default_value":"","dynamic_ref_qual":"","element_reference":"0","filterable":"1","foreign_database":"","function_definition":"","function_field":"0","groupable":"1","help":"","hint":"","i18n_sortable":"1","internal_type":"collection","label":"Choice","language":"en","mandatory":"0","matchable":"1","max_length":"40","multi_text":"0","name":"sys_choice","plural":"Choices","primary":"0","read_only":"0","read_roles":"","reference":"","reference_cascade_rule":"","reference_floats":"0","reference_key":"","reference_qual":"","reference_qual_condition":"","reference_type":"","sizeclass":"1119493","sortable":"1","spell_check":"0","staged":"0","sys_package":"","sys_scope":"global","table_reference":"0","text_index":"0","type":"0","type_description":"collection","unique":"0","url":"","url_target":"","use_dynamic_default":"0","use_reference_qualifier":"simple","virtual":"0","widget":"","write_roles":"","xml_view":"0"},"dependent_value":{},"synonyms":{},"sys_mod_count":{},"language":{},"label":{},"sys_updated_on":{},"sys_domain_path":{},"sys_tags":{},"sequence":{},"sys_id":{},"inactive":{},"sys_updated_by":{},"sys_created_on":{},"hint":{},"sys_domain":{},"name":{},"value":{},"sys_created_by":{},"element":{}}]

 

Can someone help me in getting the correct value i.e. "Choice: 3 - Moderate" in this case.

 

Regards

Anirban

1 REPLY 1

Tarun Kumar9
Tera Contributor

Hi Anirban, 

Did you find any solution for this , thanks