Discussions
Categories
- 197.1K All Categories
- 2.5K Data
- 546 Big Data Appliance
- 1.9K Data Science
- 450.7K Databases
- 221.9K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 552 MySQL Community Space
- 479 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3.1K ORDS, SODA & JSON in the Database
- 555 SQLcl
- 4K SQL Developer Data Modeler
- 187.2K SQL & PL/SQL
- 21.4K SQL Developer
- 296.3K Development
- 17 Developer Projects
- 139 Programming Languages
- 293K Development Tools
- 110 DevOps
- 3.1K QA/Testing
- 646.1K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 158 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.2K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 19 Java Essentials
- 162 Java 8 Questions
- 86K Java Programming
- 81 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
- 205 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 468 LiveLabs
- 39 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.7K Other Languages
- 2.3K Chinese
- 175 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 233 Portuguese
IG column names that contains space

Hi,
We are creating Detail View in an IG and are trying to reference the column names like this: <td align="right">&EMP_ID.:</td>. This works fine when the column names do not have spaces. But this IG has several column aliases with mixed case with spaces. How do we reference those in td tags?
Best Answer
-
Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,345 Employee
HI,
in general, it's recommended to have your Interactive Grid Query returning column names in upper case and without spaces. Each column has the Heading and Label attributes where you can specify the content to display to end users.
The reason for this not working is that Interactive Grid column values are provided by APEX session state, which is the same thing as page items. And page item names in APEX are ... case-insensitive and must not contain spaces. So it's the same restrictions which apply here.
But the solution is easy: Just change your query to return "clean" column names, and use the Label and Heading attributes to provide content to be displayed in the UI.
Best regards
-Carsten
Answers
-
Hello venapex,
I have miss understand what are you want to achieve, can you reproduce it on apex.oracle.com?
-
Carsten Czarski-Oracle Consulting Member of technical Staff Munich, GermanyMember Posts: 1,345 Employee
HI,
in general, it's recommended to have your Interactive Grid Query returning column names in upper case and without spaces. Each column has the Heading and Label attributes where you can specify the content to display to end users.
The reason for this not working is that Interactive Grid column values are provided by APEX session state, which is the same thing as page items. And page item names in APEX are ... case-insensitive and must not contain spaces. So it's the same restrictions which apply here.
But the solution is easy: Just change your query to return "clean" column names, and use the Label and Heading attributes to provide content to be displayed in the UI.
Best regards
-Carsten