Hi,
I'm using APEX 4.0 with Oracle 10g r2 on Windows XP Pro SP3.
I have an interactive report, and a menu with some items to filter the report.
The problem is that the first time I load the page, the report returns "no data found", when I reload, it works. If I navigate to an other page and then I come back to the report page, it works too.
It seems to be a session state problem, but I can't found how to make it works, even by using a setItemInSessionState() AJAX function.
The query depends of items values :
select
SPAT_ID, SPAT_ACCL_NAME, SPAT_AREA_NAME, SPAT_CLASS, SPAT_NUMBER, SPAT_PT, SPAT_TYPE, SPAT_STATUS,
round(SPAT_CUMUL,2) as "SPAT_CUMUL"
from
SPATIAL_POINTS
where
upper(SPAT_AREA_NAME) LIKE upper(:P3_FILTRE_AREA_NAME)
AND upper(SPAT_CLASS) LIKE '%'||upper(:P3_SPATIAL_CLASS)||'%'
AND upper(SPAT_NUMBER) LIKE '%'||upper(:P3_FILTRE_NUMBER)||'%'
AND instr(upper(:P3_SPATIAL_POINT_VALUES),upper(nvl(SPAT_PT,' '))) > 0
AND instr(upper(:P3_SPATIAL_TYPE_VALUES),upper(SPAT_TYPE)) > 0
AND (:P3_FILTRE_ACC_NAME IS NULL AND spat_accl_name IS NULL OR CASE WHEN :P3_FILTRE_ACC_NAME = '%' THEN nvl(spat_accl_name,'_NULL_') ELSE :P3_FILTRE_ACC_NAME END = nvl(spat_accl_name,'_NULL_'))
I implemented it on apex.oracle.com, if you find time to take a look : http://apex.oracle.com/pls/apex/f?p=4550:1
You should get a "no data found" the first time you load the page.
workspace : yb202826
login : user1
password : u_s_e_r_1
application : 20588. Geode Page 1
Thank you !
Yann.