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?
Share
Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
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?
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:
With this in place whenever you change value of EMPNO and then navigate to different cell, DEPENDANT will be updated.
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.
Sir, data set after click every cell. not automatic set for all cell when change bill_month item.
when set action:change in dynamic action on bill_month DA fired but return null.
Hi!
You can use pipes:
I dont understand about your ans. In IG column have data from a table. I want to know that, same data add to other column. same as. Sal = 20000, update_sal = 20000.
Thank you so much for your instant reply.
On what event do you want to copy the value from that column to another? On page load? Or when the user changes the value in the Service Charge column?
This page have one Item, when this item change set have an action for below region refresh. after refresh need to this action sir.
This page have one Item, when this item change set have an action for below region refresh. after refresh need to this action sir.
Service charge data return to Collection Amount Column when change lOV -Bill Month.
Bill Month is item have refresh dynamic action.
Then create one more dynamic action (Execute PL/SQL code) on bill month LOV (before Refresh DA) to update the table the grid based on. Below is an example:
Then after the refresh, it will show the collection amount.
Sorry Sir, I couldn’t explain it to you.
Sir, I want to data transfer only form without update table. Its possible for this quary?
Sir, this data transfer service_charge column to collection_amount column then if need data modification, will done then insert into table.
Thank you so much sir.