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