Home/ Questions/Q 4657
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2021-01-23T14:29:36+00:00

How to add one column data to another column in same row in Interactive Grid on oracle apex?

  • 0
  • 0

How to add one column data to another column in same row in Interactive Grid on oracle apex?

How to add one column data to another column in same row in Interactive Grid on oracle apex?

question
Share
Leave an answer

Leave an answer

Browse

13 Answers

  1. If I get your problem correctly you want to simply pass a value from one column to another in case initial value has changed.

    If that’s the case let me use EMP table as an example. DEPENDANT (“virtual”) column I added just for the purpose of this example. It would react on change of EMPNO column.

    This is source query for your interactive grid:

    SELECT E.*, NULL AS DEPENDANT FROM EMP E

    Here is explanation:

    1. expand columns of your interactive grid
    2. right click on EMPNO and choose create dynamic action
    3. WHEN section
      1. EVENT = Change
      2. Selection type = Column(s)
      3. Region = IG
      4. Column(s) = EMPNO
    4. True action is:
      1. Identification = Set Value
      2. Settings
        1. Set type = PL/SQL Expression
        2. PL/SQL Expression = :EMPNO
      3. Items to Submit  = EMPNO
      4. Affected Elements
        1. Selection Type = Column(s)
        2. Column(s) = DEPENDANT
      5. Execution Options
        1. Fire on Initialization = False (disable)

    With this in place whenever you change value of EMPNO and then navigate to different cell, DEPENDANT will be updated.

     

  2. Ok, then create a dynamic action on the bill month item to execute JavaScript code. Also, specify a static id to your grid, for example, “igbill”. Now add the below JavaScript code to it:

    var model = apex.region("igbill").widget().interactiveGrid("getViews", "grid").model;
var n_service_charge, n_collection_amount;
n_service_charge = model.getFieldKey("SERVICE_CHARGE");
n_collection_amount = model.getFieldKey("COLLECTION_AMOUNT");
model.forEach(function(igrow) {
igrow[n_collection_amount] = igrow[n_service_charge];
});

    When the user changes the billing month, it will loop through the interactive grid and assign the service charge to the collection amount.

  3. Hi!

    You can use pipes:

    SELECT ename||' - '||sal as "Ename and Sal"
FROM emp;

  4. Service charge data return to Collection Amount Column when change lOV -Bill Month.

    Bill Month is item have refresh dynamic action.