title: Oracle Apex - Dynamically check checkbox item that is not within a report
body: <p>I have a checkbox item on my page (note: this is not inside a report) and I want to dynamically check the checkboxes when the page loads. I have a table which has all the checkbox types and a table which identifies which checkboxes that user has access to or in better terms should be checked. </p>
  
  <p>My question is, within an Apex checkbox item how do you tell it to dynamically check a checkbox. I have it working in a report and my query looks like this:</p>
  
  <pre><code>SELECT at.name AS TITLE,
       CASE
           WHEN at.name IN (SELECT atp.name FROM preferences p) THEN apex_item.checkbox(1,at.value,'CHECKED')
           ELSE apex_item.checkbox(1,at.value, 'UNCHECKED')
        END AS CHECKBOX
  FROM access_types at
  </code></pre>
  
  <p>Can I do something similar in an oracle apex checkbox item? </p>