Quick Fix: Broken “Select All” Checkbox in Tabular Forms
I recently came across this problem in APEX 4.1 and thought I’d post the solution here for the benefit of others, since the solution is quite obscure.
The “select all” checkbox in an APEX 4.1 tabular form only selects the first row.
Background color for checked row and/or Background color for current row in the report template used by the tabular form must be populated.
These values are passed to the initReport function that initialises tabular form variables. In APEX 4.1, if both of these values are not set, initialisation doesn’t take place, which compromises other tabular form functions, including those for row selection.
The reason I don’t normally set these colour values in my APEX themes is because I prefer to separate structure (templates) from style (CSS). This approach has many benefits particularly when applying multiple skins to the same APEX application, as is the case with my Echo Theme for APEX 4.
It’s a pity that omitting such a trivial and misplaced colour value should have such a negative consequence. Fortunately, the value can be set to “null”, which fixes the problem without committing theme developers to a hard coded colour.