Home/Questions/Q 4657
Answered
SM Hasem
SM Hasem

SM Hasem

  • Dhaka, Bangladesh
View Profile
  • 0
Contributor
Asked: 2021-01-23T14:29:36+05:30

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

  • 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

    17 Answers

    1. pavlos

      pavlos

      View Profile
      Guru

      Hi!

      You can use pipes:

      SELECT ename||' - '||sal as "Ename and Sal"
FROM emp;
      • 0
    2. SM Hasem

      SM Hasem

      • Dhaka, Bangladesh
      View Profile
      Contributor

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

      Bill Month is item have refresh dynamic action.

      • 0
    3. Vinish

      Vinish

      View Profile
      Enlightened

      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.

      • 1
    5. goto150

      goto150

      • Wroclaw, Poland
      View Profile
      Professional

      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
    6. goto150

      goto150

      • Wroclaw, Poland
      View Profile
      Professional

      Maybe you could simply solve this at the data source level. Assuming your :P6_BILL_MONTH is LOV accepting NULLs (Display Null Value = TRUE), then you could use NVL2 to display SERVICE_CHARGE in case :P6_BILL_MONTH is selected (meaning not null).

      
SELECT ROWID
     , CLIENTS_ID
     , TITLE
     , PROJECT_NAME
     , AREA
     , SERVICE_CHARGE
     , NVL2(:P6_BILL_MONTH,SERVICE_CHARGE,COLLECTION_AMOUNT) AS COLLECTION_AMOUNT
     , BILL_MONTH
     , SOFTWARE_STATUS
     , ENTRY_DATE
     , BILL_MONTH_2ND
  FROM COLLECTION_LIST
 WHERE MONTH_WISE_DATE <= :P6_BILL_MONTH;

I assume you created Refresh Region Dynamic Action triggered by :P6_BILL_MONTH change and you use this item in Page Items to Submit Source region definition.
      • 0
    7. goto150

      goto150

      • Wroclaw, Poland
      View Profile
      Best Answer
      Professional

      You're right. My bad, firstly this NVL2(:P5_BILL_...) column is virtual and secondly it does not leave cells in edit mode. I'd say lose-lose instead of win-win:)

      Lets try JavaScript. For the demo I am going to create a button to fire DA.

      1. Set Static ID for the region holding your interactive grid
        1. Region properties --> Advanced
          1. Static ID = SID_COLLECTION_LIST
      2. Right click on the Region --> Create Button
        1. Button Name = Forecast
        2. Label = Forecast
        3. Button Position = Top of Region (to easily locate it)
      3. In Dynamic Actions tab right click on Events --> Create Dynamic Action
        1. Identification
          1. Name = Fill collection amount
        2. When
          1. Event = Click
          2. Selection Type = Button
          3. Button = Forecast
      4. True (action)
        1. Identification
          1. Action = Execute JavaScript Code
        2. Settings
          1. Code:
      var model   = apex.region("SID_COLLECTION_LIST").widget().interactiveGrid("getViews","grid").model;
model.forEach(function( record ) {
model.setValue( record, "COLLECTION_AMOUNT",model.getValue( record, "SERVICE_CHARGE" ));
}
);

      I hope this would help you, and the reason I did not add this to Change event of the LOV is that I would not know how to easily chain Refresh() --> DA (Fill collection amount). If you put both: Refresh and DA under :P6_BILL_MONTH Change() event, both will fire synchronously and you won't get your collection column refreshed.

      • 2

    You must login to add an answer.