Discussions
Categories
- 196.9K All Categories
- 2.2K Data
- 240 Big Data Appliance
- 1.9K Data Science
- 450.4K Databases
- 221.7K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 550 MySQL Community Space
- 478 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 546 SQLcl
- 4K SQL Developer Data Modeler
- 187.1K SQL & PL/SQL
- 21.3K SQL Developer
- 295.9K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.6K Development Tools
- 107 DevOps
- 3.1K QA/Testing
- 646K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 155 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 18 Java Essentials
- 160 Java 8 Questions
- 86K Java Programming
- 80 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.3K Java SE
- 13.8K Java Security
- 204 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 443 LiveLabs
- 38 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 171 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 232 Portuguese
Checkbox in Interactive Grid
Answers
-
You can use a checkbox plugin in Apex 19:
https://github.com/rafael-trevisan/apex-plugin-ig_simple_checkbox
It's not 100% (the box moves up when clicking), so we modified the code a bit for our use.
-
I downloaded the application 261 with a test checkbox (page 11) with the .js and .css files.
Works fine.
Now I tried to copy the page for my application, changes the columnname in the select statement to DONE, the column content from J to Y.
select LOTP_ID,
LOTP_NAME_KURZ,
LOTP_NAME_LANG,
case when LOTP_GKZ = 'J' then 'Y'
else 'N'
end as DONE,
LOTP_DGV,
LOTP_DGB,
LOTP_DLA,
LOTP_BEN,
LOTP_INFO
from lotp;
copied the page Javascript and CSS, copied the css class and Javascript Initialisierungscode.
I only see an empty checkbox and cannot change (from select statement the checkbox should be activated) to active or inactive.
Where is my error?
-
Do you see the blue tick on click of the checkbox? If it is there that means value is being changed from yes to no or vice versa but your css class is not reflecting. In this case verify the name of the class and modify accordingly.
-
I see the blue tick.
Now I created a new application and copied the page with the checkbox, downloaded and uploaded the shared components . It doesn't work.
I am not so familiar with css an js scripts so I left both unchanged
Please help me again
-
I think in the issue is in display value set, as a workaround you can also add the below css to set the box checked.
.checkStateY.fa-square-o::before { content: "\f046"; }
-
I copied your help into page CSS inline but how can I call it from DONE (checkbox) column?
-
how to simulate the when-checkbox-checked trigger in oracle forms in oracle apex?