Oracle Apex Utility Note Series 6-Editable interactive reports Editable Interactive report

As far as I know, Apex 4.x does not provide an editable interactive reporting component. This requires our manual implementation. In fact, this is not very complicated, just a few simple steps.

1. Create a interactive report according to the wizard. The query statement can be as follows.

Select Apex_item.hidden (1,e.id) | | E.name as Staff, Apex_item.select_list_from_lov (p_idx=>2,p_value=>e.department_id,p_lov=> ' lov_department ') as department from employee E;

The key here is to use Apex_item. Select_list_from_lov is used for table editing. Of course, Lov_department needs to be built in advance.

2. Create a button to submit the page.

3. Create a "after Submit" Plsql process

Begin For I in 1.. Apex_application.g_f01. COUNT LOOP Update employee Set DEPARTMENT_ID=APEX_APPLICATION.G_F02 (i) where id=apex_application.g_f01 (i); END LOOP; End

What you need to remind here is the ordinal match. In other words, g_f onPoint to Apex_item. HIDDEN ( 1, e.id), G_f GenevaPoint to Apex_item.select_list_from_lov (p_idx=> 2,p_value=>e.department_id,p_lov=> ' Lov_department '). Note the italic and underlined number sections.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Oracle Apex Utility Note Series 6-Editable interactive reports Editable Interactive report