Good Afternoon Venky.
Just an example as a possible way to get this working for you.
Please note, it is an example to get you started.
It is not meant as 'the solution' for you on this subject.
Thanks in advance for your understanding and kind regards, Louis.
{
getProducts : function ()
{
ca_fdFetchSelectData(ca_fd.formId, 'sel_1');
},
getProductbyID : function (selValue)
{
console.log('getProductbyID1');
ca_reportQuery('300378685f4e-78878ef215cea3c2da9-7f2a1498628830682',
{'productID':selValue,'inuserid':ca_fdGetTextFieldValue(ca_fd.formId,'hid_user')},
function(result)
{
ca_fdShowFields(ca_fd.formId, ['lbl_9']);
if (result.length > 0)
{
ca_fdSetTextFieldValue(ca_fd.formId, 'lbl_cat_string','(ISO 9999) / Hjälpmedelsområden / 12 Förflyttning / 1222 Manuella rullstolar / 122203 Manuella tvåhjulsdrivna rullstolar');
ca_fdSetTextFieldValue(ca_fd.formId, 'ncust_product_name',result[0]['cust_product_name']);
ca_fdSetTextFieldValue(ca_fd.formId, 'nproduct_nr',result[0]['product_nr']);
ca_fdSetTextFieldValue(ca_fd.formId, 'nsupplier',result[0]['supplier']);
ca_fdSetTextFieldValue(ca_fd.formId, 'nproduct_nr_supplier',result[0]['product_nr_supplier']);
ca_fdSetTextFieldValue(ca_fd.formId, 'nsupp_product_name',result[0]['supp_product_name']);
ca_fdSetTextFieldValue(ca_fd.formId, 'nupdated_date',result[0]['updated_date']);
ca_fdSetTextFieldValue(ca_fd.formId, 'nproduct_unit',result[0]['product_unit']);
ca_fdSetTextFieldValue(ca_fd.formId, 'nunit_qty',result[0]['unit_qty']);
ca_fdSetTextFieldValue(ca_fd.formId, 'product_color',result[0]['product_color']);
ca_fdSetTextFieldValue(ca_fd.formId, 'product_material',result[0]['product_product_material']);
ca_fdSetTextFieldValue(ca_fd.formId, 'product_weight',result[0]['product_weight']);
ca_fdSetTextFieldValue(ca_fd.formId, 'product_color',result[0]['product_color']);
ca_fdSetTextFieldValue(ca_fd.formId, 'class_category',result[0]['class_category']);
ca_fdSetTextFieldValue(ca_fd.formId, 'class_code',result[0]['class_code']);
ca_fdSetTextFieldValue(ca_fd.formId, 'class_description',result[0]['class_description']);
ca_fdSetTextFieldValue(ca_fd.formId, 'part_of_class',result[0]['part_of_class']);
ca_fdSetTextFieldValue(ca_fd.formId, 'price',result[0]['price']);
ca_fdSetTextFieldValue(ca_fd.formId, 'agreement_name',result[0]['agreement_name']);
ca_fdSetTextFieldValue(ca_fd.formId, 'selling_party',result[0]['selling_party']);
ca_fdSetTextFieldValue(ca_fd.formId, 'bying_party',result[0]['bying_party']);
ca_fdSetTextFieldValue(ca_fd.formId, 'agreement_number',result[0]['agreement_number']);
ca_fdSetTextFieldValue(ca_fd.formId, 'agreement_status',result[0]['agreement_status']);
}
ca_fdHideFields(ca_fd.formId, ['lbl_9']);
},
ca_fd.js.onFailureFetch);
},
getSelectedRow : function ()
{
console.log('getSelectedRow');
var selValue = ca_fdGetSelectedOptionValues(ca_fd.formId, 'sel_1');
console.log(selValue);
ca_fd.js.getProductbyID(ca_fdGetSelectedOptionValues(ca_fd.formId, 'sel_1'));
},
}