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 highlight row based on condition using Classic Report
For all rows? It seems you want to compare the date in the interactive grid. Then you just need to refer the IG column (:YOURDATE) instead of the page item (P1_yourdate).
For all rows? It seems you want to compare the date in the interactive grid. Then you just need to refer the IG column (:YOURDATE) instead of the page item (P1_yourdate).
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex?
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_coRead more
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.
See lessHow to highlight row based on condition using Classic Report
How can I get vales into :P1_yourdate for all rows and compare them?
How can I get vales into :P1_yourdate for all rows and compare them?
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex?
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.
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.
See lessHow to highlight row based on condition using Classic Report
Create a dynamic action as Style type and specify the JavaScript expression for the dynamic action as following: new Date($v("P1_yourdate")).getTime() < new Date($v("P1_CURRDATE")).getTime() Here the P1_yourdate is the item with which you want to compare with the current date. Also, create an iteRead more
Create a dynamic action as Style type and specify the JavaScript expression for the dynamic action as following:
new Date($v("P1_yourdate")).getTime() < new Date($v("P1_CURRDATE")).getTime()Here the P1_yourdate is the item with which you want to compare with the current date. Also, create an item P1_currdate and on page load assign the current date to it.
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex?
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: Update yourGridTable set collection_amount = service_charge where yourGridcondition; Then after the refresh, it will show the collection amount.
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.
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex?
Service charge data return to Collection Amount Column when change lOV -Bill Month. Bill Month is item have refresh dynamic action.
Service charge data return to Collection Amount Column when change lOV -Bill Month.
Bill Month is item have refresh dynamic action.
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex?
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.
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex?
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.
See lessHow to add one column data to another column in same row in Interactive Grid on oracle apex?
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?
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?
See less