javascriptoracle-apexoracle-apex-19.2interactive-grid

Getting updating value from IG


I need to store the updated value from the IG in the P12_EMPNO page element.

enter image description here

To do this, use this code in DA --- > Run Javascript code

var changedValue = apex.item("N001").getValue();
apex.item("P12_EMPNO").setValue(changedValue);

But the value is not stored in the P12_EMPNO page item.

Note: I only need to save the value I'm updating...

For example: If the value 1003 (already present) is updated to 1004 (update value), I need to store 1004 in P12_EMPNO.

See page 12

Environment:https://apex.oracle.com/pls/apex/

Workspace: shajin_wk

username: Test

pwd: Test@123


Solution

  • Looking at your application, the reason you're getting the error is because of the following attributes in the page process:

    enter image description here

    DECLARE
      l_emp_collection VARCHAR2(100) := 'PRODUCT_LIST';
    
    begin
        case
            :apex$row_status
            when 'U' then
                apex_debug.info(
                    p_message => 'KL Debug: SEQ_ID: %0, N001: %1, N002: %2, C001: %3, QTY: %4',
                    p0 => :SEQ,
                    p1 => :N001,
                    p2 => :N002,
                    p3 => :C001,
                    p4 => :N003);
    
                APEX_COLLECTION.UPDATE_MEMBER ( p_collection_name => l_emp_collection,
                                                  p_seq => :SEQ,
                                                  p_n001 => :N001,
                                                  p_n002 => :N002,
                                                  p_c001 => :C001,
                                                  p_n003 => :N003 );
    
        end case;
    
    end;
    

    Note that you can use apex_debug to log entries that can be viewed in debug mode.