I have top region with min value and max value.
in another region I have interactive grid column name order value. when user put any value must be between min and max value of top region.
How to perform this validation after got focus.
thanks and regards
Vinish Kapoor
You can create a validation on that IG column. Select the validation type as SQL query returning rows and then add the following query in it:
Example
shyam
Reply : I tried the same it is giving the error
how to validate Interactive Grid Cell Value I copied the other rgion value to in IG column but it is not taking the value.
pl suggest some new in line validation.
afzal
step 1 assign static id for "order_value" column like "order_val"
step 2 create dynamic action
name-- order value validation
event- change
colmun- order_value
action-- execute javascript
var min_val = apex.item('p114_min').getValue();
var max_val = apex.item('p114_max').getValue();
var order=apex.item("order_val");
var v_order= order.getValue();
if (v_order >= min_val && v_order <=max_val){
order.node.setCustomValidity("");
}else{
order.node.setCustomValidity("invalid number");//--customize your error message as your requirement
}