Lobby Data Source Designer's default column types (Text, Decimal, Number, Currency) don't give a clean way to present large numbers/currencies with thousands separators but no decimal places (like 30,000,000 instead of 30.000.000,00) — is it possible to create a genuinely new custom column type for this?

All FAQ questions / Platform, Aurena, and customization

Answer

You don't need a new column type — format the number directly in your SQL using Oracle's TO_CHAR with an explicit format mask, for example TO_CHAR(30000000,'FM999G999G999G999'), then present the result as a plain Text-type column instead. The FM prefix suppresses extra padding/blank characters, and G represents the locale-aware group (thousands) separator — this gives you a clean, grouped, decimal-free number string without needing any new column type in the Data Source Designer.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Platform, Aurena, and customization questions