Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IG column names that contains space

venapexOct 20 2021

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?
This post has been answered by Carsten Czarski-Oracle on Oct 21 2021
Jump to Answer

Comments

Hamza Al-abbasi

Hello venapex,
I have miss understand what are you want to achieve, can you reproduce it on apex.oracle.com?

Answer

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.
Bildschirmfoto 2021-10-21 um 11.11.51.pngBest regards
-Carsten

Marked as Answer by venapex · Nov 9 2021
1 person found this helpful
1 - 2

Post Details

Added on Oct 20 2021
#apex-discussions
2 comments
154 views