CUSTOM QUERY IN POPUPS

[inspectorflint]

Hello.

I an trying a new aproximation to the trouble. With the business map (above) I am only adding new columns in the popup, and it works.

Next step: The custom query is working in Products.php file, with the function getQueryByModuleField,
....
elseif ($module == 'SalesOrder') {
$sql = $query_body." WHERE vtiger_productcf.cf_1267 = 10321 AND ".$query_cond;
return $adb->convert2Sql($sql, array($_REQUEST['productid']));
}
....
but I need the value of one of the fields in the sales Order. I need change the value of 10321 with the value of the cf_1262 field of the Sales Order when I am creating this sales order ( before save the register)

How Can I capture this values? Or they are disponible with any javascript function?

Thanks and happy Saturday