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

As far as I know. Apex 4.x is not provided with an editable interactive reporting component. This needs to be implemented manually.

In fact, this is not very complicated, just a few simple steps.

1. Create a interactive report based on the wizard. Query statements 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 need to be built well 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

The warning 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.

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