Home/Questions/Q 5432
In Process
shyam
shyam

shyam

View Profile
  • 0
Contributor
Asked: 2021-02-18T13:07:49+05:30

How to validate Cell Value in interactive Grid Oracle APEX?

  • 0

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

ig

    3 Answers

    1. Vinish

      Vinish

      View Profile
      Legendary

      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

      Select 1 from dual where :order_value between :p1_min and :p1_max;
      • 0
    2. shyam

      shyam

      View Profile
      Contributor
      sol : Select 1 from dual where :order_value between :p1_min and :p1_max;

      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.

      • 0
    3. afzal

      afzal

      • India
      View Profile
      Professional

      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
      }

      • 1

    You must login to add an answer.