Hi Utku!
This is not possible because where_clause search performed by pre-processor (HTMPL) and can't be affected via JavaScript, as the way can preload all possible values and then switch dropdown options depending on them:
function statusReloadRC(value) {
ahdframe.document.getElementsByName('SET.z_TestDropdown')[0].options.length = 0;
ahdframe.document.getElementsByName('SET.z_TestDropdown')[0].options[0] = new Option("<Empty>", "", true, false);
var i=1;
if (value == "HOLD") {
<PDM_LIST PREFIX=list WHERE="description like 'HOLD' AND delete_flag = 0" FACTORY=rc>
ahdframe.document.getElementsByName('SET.z_TestDropdown')[0].options[i] = new Option("$list.sym", "$list.id", false, false);
i++;
</PDM_LIST>
} else if ( (value == "CNCL") || (value == "CLnotRE") ) {
<PDM_LIST PREFIX=list WHERE="description like 'CNCL' AND delete_flag = 0" FACTORY=rc>
ahdframe.document.getElementsByName('SET.z_TestDropdown')[0].options[i] = new Option("$list.sym", "$list.id", false, false);
i++;
</PDM_LIST>
} else if (value == "RE") {
<PDM_LIST PREFIX=list WHERE="description like 'RE' AND delete_flag = 0" FACTORY=rc>
ahdframe.document.getElementsByName('SET.z_TestDropdown')[0].options[i] = new Option("$list.sym", "$list.id", false, false);
i++;
</PDM_LIST>
}
}
Where statusReloadRc(value) should be attached to onchange event.
Regards,
cdtj