Posts

Showing posts from March, 2013

A word of caution when using an SQL report with hidden items on the same page as a tabular form

Image
tl;dr: if you are going to have a tabular form and an sql report on the same page with a hidden item, don't hide it using column attributes. I've set up the following page to document the behaviour:  http://apex.oracle.com/pls/apex/f?p=45448:23:11484095074702::::: Basically, when you have a tabular form, elements are given a name attribute such as f01. Then, any processes can reference these elements.  The trouble is, I have a SQL report, and I want to have the name column a link, which uses the ID column. I also don't want to leave the ID column showing, so I set it to hidden in column attributes. Now if I try to delete a row in the tabular form, I will run into the following issue: Now if I look at the source of the people report, I will see the hidden item has also named that field the same way as the tabular form, which will be causing a conflict for the MRU,MRD processes, and any custom process that uses the apex_application.g_f0x array.