Hi All,
SE 12.1
APEX 5.1
OK. todays interesting challenge. I have a page, with a master & detail region. The detail region is a Tabular form (use Interactive Grid, I hear you all yelling.... and I did create a version a while ago with IG, and the users all asked me to put the tabular form version back!!!)
The Tabular Form has the old fashion/legacy ApplyMRU and ApplyMRD submit processes on it.
I have two versions of the page. Development and production.
On the detail region on both production and development, the first column is the Row Selector Column, and it maps onto the ID of the table (when I do an inspect, it shows the ID of the record). All works fine, and I have a bunch of Dynamic actions and processes that work on the CHECK$01 column , using its selector and the f01 array,
However, on the development page, I moved a few columns around on the end of the tabular form, and hid one column. I didn't touch anything at the beginning of the form. Suddenly, inspecting the Row Selector column, it no longer shows the ID value, instead shows a value of "I" . This kills all my DAs and Processes using f01. Checking further, I don't see anywhere that you actually set the column that is associated with the Row Selector column.
No problem I thought, lets dump the Row Selector column, and use APEX_ITEM.CHECKBOX, with an ID of 1 to map onto f01... However, doing this, causes the column that was f02 next to it to become f01, so now I have two f01, and in addition to the ID value being in the checkboc, the value of ID is turning up in the second column that should have a completely different value. So then for the sake of it (to test) I, add in both Row Selector column, as well as apex_item.checkbox with an ID of one. I then get two checkboxes both with ID of one.
I don't especially want to rebuild everything, because there are lots of DAs on the Tabular form.
So my question is, how to either :
- map the Row Selector column back onto the ID column in the database, so i get the ID value in the Checkbox. or
- Discard the original Row Selector, add in my manual checkbox, but force the next column to go back to being f02.
(Oh and I know... TFs are legacy for a reason!!! )
Thanks
Richard
EDIT: Further testing this morning:
Here is a screenshot of the f01 selector before any changes to the Tab Form. Note the value on f01 is 1243895, Also shown are the columns. Note RECEIPT_REF column. Its currently in position f26 on the TF.
If I then simply move RECEIPT_DATE it to just after PMT_DATE as per the following: (its column name changes to f20)
I then inspect the checkbox on f01, I get the following: Note the value is now "I". Its lost its ID value, and obviously none of the processes that use f01 work any more.
rgds
Richard