Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.6K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Checkbox in Interactive Grid

Hi,
I have to display a checkbox as part of an Interactive Grid in APEX 19.2. If it contains J then display as checked else as unchecked.
Can I change from checked to unchekced and vice versa?
Please help me.
Regards
Siegwin
Answers
-
Not quite sure what you mean.
But I assume you like reverse checkbox values. For that see column attributes "Settings" select list and change that to "Custom". Then define Checked and Unchecked values
-
I cannot change anything
How can I change the lookout
-
I think IG should be in edit mode, before checkbox shows.
Sorry, it might I don't quite understand what is issue. Please explain more or create example to apex.oracle.com.
-
Of course checkboxes may have changed since 19.2, but on apex.oracle.com (20.2) checkboxes work just fine:
The only problem you may have:
If it contains J then display as checked else as unchecked.
Do you mean "else" as in "for any other value", even null? Checkboxes are binary and work with two values, like 0/1 or N/J.
-
Of course checkboxes may have changed since 19.2, but on apex.oracle.com (20.2) checkboxes work just fine:
Things have changed. Those are a new checkbox item type introduced in APEX 20.2:
New Checkbox item type. This single checkbox offers an alternative to the Switch item type for Boolean columns. Also works in Interactive Grid, including outside of edit mode. The previous Checkbox type is renamed Checkbox Group.
-
Sorry but I have to use 19.2
-
Sorry but I have to use 19.2
Then as Jari said above: "IG should be in edit mode, before checkbox shows".
Prior to the introduction of the new item type in 20.2, checkbox columns are only rendered as checkbox form controls when the grid is in edit mode. In navigation mode or a read-only grid the checked/unchecked labels are displayed:
-
If the checkbox field is a simple binary value, like Yes/No or True/False, you might consider making it a Switch instead of a checkbox. But a simple binary checkbox is possible as long as you are okay with a null as the unchecked value. Just configure the LOV with only one choice, the "J" in your case. But in an interactive grid, you only see the currently selected value, and don't see the checkbox until you are in Edit mode. Same for Switch.
-
Thank you,
I changes it to a Switch Column. Is it possible to use a Javascript or so to see the checkbox in the IG lines?
-
You could check the cookbook (page 11) APEX IG Cookbook Update for 19.1 – HardLikeSoftware