Forum Stats

  • 3,769,993 Users
  • 2,253,045 Discussions
  • 7,875,263 Comments

Discussions

Oracle Apex Refresh is not happening from Interactive grid to Interactive report.

Hi,

I am having page like following :

Left most Grid, next 2 are Interactive reports. based on left most selection 2nd Interactive report should give results, I have written following query but not working correctly . Example : :P15_ORIGINAL_TABLE_NAME in case null all the table should display against selected source system, but not happening.

Issue 2: when i select table name, some times its reflect some times slow reflect and doesnt reflect.


SELECT APEX_ITEM.CHECKBOX2(

                  p_idx                      => 1,

                  p_value                    => TABLE_NAME, --||':'||DATA_TYPE,

                  p_attributes               => NULL,

                  p_checked_values           => NULL,

                  p_checked_values_delimiter => ':',

                  p_item_id                  => 'f01_'||ROWNUM

               )

SELECT_TABLE, TABLE_NAME,

OWNER, TABLESPACE_NAME FROM all_tables WHERE OWNER = :P15_SOURCE_SYSTEM AND

(:P15_ORIGINAL_TABLE_NAME IS NULL OR :P15_ORIGINAL_TABLE_NAME = TABLE_NAME);


For mt it's first development in Apex, request you to help.

Thanks