Maintain checkbox state same after submit page in oracle apex

0
votes

I’m working on Oracle Apex.

In the region1 there will be LOV while submit region1 in report2 the interactive report will be shown based upon data through SQL query and I have checkbox in the report2.

But the problem here is: I click the checkbox and then submit page through button. Checkbox' value has been lost after refresh page and I want the checkbox to be the same as what I checked before.

Please, can any body help me in this ?

Thanks

Praveen

1
javascriptjqueryoracleoracle-apex

1 Answers

0
votes

From my point of view, Interactive report is what its name says: a "report" (something you use to view data, not edit it).

If you want to do it in a simple manner (read: out-of-box, no additional coding in JavaScript or whatever else), switch to an Interactive Grid which lets you edit data presented on the screen. Doing so, your checkbox value wouldn't be lost upon submit.

For more info and some examples, have a look at Add awesome checkboxes and status fields in an Interactive Grid in Oracle APEX (by Dimitri Gielis).

Can it be done in an interactive report? Yes; there are examples on the Internet (Google for it), such as Preserving checked checkboxes in a report (by Joel Kallman), Report with Checkboxes (by Martin Giffy D'Souza), etc.