Number, Size, Date, and Time Formatting
The following field formatters are provided:
Number: This format is based on the Java class NumberFormat. This formatter ignores the Pattern listed in the SQL Template Designer.
Custom Number: This format is based on the Java class NumberFormat. Unlike the Number formatter, this Custom Number formatter takes into account the Pattern when formatting the value.
Decimal: This formatter is based on Java decimal formatters, DecimalFormat.
Date: This formatter is based on the Java class SimpleDateFormat. Note that the Date Formatter is available for templates developed in earlier releases, however, it is no longer supported in the SQL Template Designer because the format of the date is controlled by the user's profile. For special cases, where custom date formatting is required, use the Oracle TO_CHAR function in the query. This function converts a date or interval value to a character data type in the specified format: Date, Timestamp.
File Size: This formatter formats the file size with the unit of measure that is most applicable to the field value. For example, 2048 MB would become 2 GB. The pattern field takes the following values: Bytes, KB, MB, GB, and TB (or the Kibibyte multiples: KiB, MiB, GiB, and TiB). This is the unit of the data returned from the Portal database.
Percentage Bar: The Percentage formatter results in a horizontal bar, representing the value in a tabular report column. For example, 50:75 results in a color designation, where a value < 50 renders green, 50-75 renders yellow, and > 75 renders red.
Status Icon: Colored icons, relevant to a value, will render in a tabular report column.
See Status Icon Values.
Area Sparkline:
See Area, Line or Column Sparkline Format for a SQL Tabular Report Template.
Column Sparkline:
See Area, Line or Column Sparkline Format for a SQL Tabular Report Template.
Line Sparkline:
See Area, Line or Column Sparkline Format for a SQL Tabular Report Template.
Truncate: Truncates a string with ellipsis. The maximum size of the string is 28 characters. Use the pattern to override the maximum size. When using the Truncate formatter, it is recommended to use the Advanced dialog to create a hover tool tip.