Geek asks and answers

How to access APEX_ITEM.TEXTAREA field using APEX_APPLICATION.G_F01

I have the following table report using the following query:

select id,
       name,
       telephone,
       apex_item.checkbox2(1,id) as "Tick when Contacted",
       apex_item.text(20,my_date) as "Date Contacted",
       apex_item.textarea(30,my_comment,5,80) as "Comment"
from   my_table

This report displays 10 entries, where the key is the flag assigned to F01.

My problem is that this is a table report using Oracle APEX_APPLICATION.G_F01.COUNT - how do I access the values ​​of the textarea field, where "my_comment" is the user input value in the report, and not from the database column / table?

From what I see, it seems that this is a sequence problem, and if the entries you entered are not in the correct order, then the values ​​are skipped.

I only check the boxes for lines 1, 3, and 5 and therefore expect to return values ​​for textarea fields that apply only to these selected lines.

+3
1

, , . g_f01 3 1, 3, 5, g_f30 10 .

apex_item APEX:

  • APEX my_table. mytable , . apex_item.hidden(2, ID).
  • , my_table, seq_id, checkbox: apex_item.checkbox2(1,seq_id)
  • g_fxx - - .
  • , my_tabl

, APEX, , , c050 "Y":

for i in 1..apex_application.g_f01.count loop
    apex_collection.update_member_attribute('MYCOLL', apex_application.g_f01(i), 
      50, 'Y');
end loop;

:

for i in 1..apex_application.g_f02.count loop
    apex_collection.update_member_attribute('MYCOLL', apex_application.g_f02(i), 
      20, apex_application.g_f20(i));
    apex_collection.update_member_attribute('MYCOLL', apex_application.g_f02(i), 
      30, apex_application.g_f30(i));
end loop;

, my_table:

for r in (select c002, c020, c030 
          from apex_collection
          where collection_name = 'MYCOLL'
          and c001 = 'Y' -- Checked rows only
         )
loop
    update my_table
    set my_date = r.c020
    ,   my_comment = r.c030
    where id = r.c002;
end loop;

...?!

+6

More articles:


All Articles