![]() ![]() 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. 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). tValue( record, "COLLECTION_AMOUNT",model.getValue( record, "SERVICE_CHARGE" )) ![]() Var model = apex.region("SID_COLLECTION_LIST").widget().interactiveGrid("getViews","grid").model Oracle documentation states the cause as the following: A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or. In Dynamic Actions tab right click on Events -> Create Dynamic Action.Button Position = Top of Region (to easily locate it).Right click on the Region -> Create Button.In case the second parameter is null, then it returns the third parameter. If the first parameter is not null, then it returns the second parameter. Oracle NVL2 () function allow three parameters. Set Static ID for the region holding your interactive grid NVL2 () function is an extend version of the NVL () function with different options based on whether a NULL value exists.For the demo I am going to create a button to fire DA. My bad, firstly this NVL2(:P5_BILL_.) column is virtual and secondly it does not leave cells in edit mode. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |