I am a APEX newbie so sorry if I am missing something basic but I have spent over an hour looking for an answer to this and keep coming up empty
I have created a master detail page with a report. So two pages (report and masterdatail) I have an "Active" column in both the master and detail tables (1 = Active 0 = Inactive)
First Issue:
On the report page I have specified display as simplecheckbox for the active column for the master table. It displays as a checkbox but how do I specify that 1 = checked and 0 = unchecked. It wont let me modify the query so I cant use apex_item. Also the checkbox is enabled in that I can check/uncheck so not sure why that is as the other columns are disabled.
Second Issue:
When I click the Edit button from the Report page it displays the page item correctly (set display as Checkbox for active column) and it will display correctly if the active value in the database =1. I have a Static LOV defined for the item with the following value: STATIC:;1
But if the value in the database = 0 for inActive, I get two checkboxes displayed and the second check box is checked and has a "0" after the checkbox. If the value in the database = 1 for Active, I only have one checkbox and it is checked like it should be.
Why is there no option for a checkbox to define a checked value and unchecked value? What am I missing?????? This should be something very basic and simple.