3 Replies Latest reply on Aug 13, 2018 3:14 PM by cmeda

    Dynamic Action on IG form

    cmeda

      Hi,

       

      I have a Editable interactive Grid say two columns in the grid and want to write a Dynamic action between the columns

      a. ) First column which is DEPTNO is a list of value

      select

          DEPT.DNAME as DNAME , DEPT.DEPTNO as DEPTNO

      from DEPT DEPT

       

      b). Second Column is DNAME.

       

      3) . First column has dynamic action like below to populate column 2

       

      Event: Change

      Selection Type: Columns(s)

      Columns: DEPTNO

       

      True Condition:

          Action: Set Value

          Set Type: SQL Statement

          SQL Statement:

      select

          DEPT.DNAME

      from DEPT DEPT WHERE DEPT.DEPTNO = :DEPTNO

      Items to Submit: DNAME

      Affected element Columns: DNAME

       

      When first column value changes, the second column value is not populating. Appreciate any advice on the same.

       

       

      Thank you