Page Process Does Not Work When Column for APEX_ITEM.HIDDEN is not shown
679690Sep 16 2009 — edited Sep 18 2009I have created a Report Region based on a SQl Query. In the query I have three columns that need to be within an array, but 2 of the 3 columns should not be displayed on the report. Therefore, I don't have Show checked for them in the Column Attributes of the Report Region.
In my testing, if I don't display the columns that are within the arrays on the report and run the page process to insert records into a table, I receive the error of "no data found". In reverse, if I display the columns, my insert is successful.
Is this how the arrays work? Or is there something I have not done correctly.
Below is the query for the Report:
SELECT APEX_ITEM.CHECKBOX(1,ROWNUM,'CHECKED')ATTENDED,
APEX_ITEM.HIDDEN(2,C.PARTY_ID) ID, -----this is the column I want to hide-----
APEX_ITEM.HIDDEN(3,C.PARTY_TYPE_CODE) PTYP, ----this is the column I want to hide----
C.PARTY_TYPE_CODE,
S.PERSON_ID,
S.PERSON_FIRST_NAME AS NAME,
C.PARTY_CASE_ID
FROM CASE.PARTY C
INNER JOIN DN.PERSON S
ON C.PARTY_ID = S.PERSON_ID
WHERE C.PARTY_CASE_ID = :P18_CDBCASE_ID
AND C.PARTY_SEQ_NO = :P18_SEQ
Thanks,
Keisha
Edited by: user4579720 on Sep 16, 2009 2:30 PM