This section describes when and how to translate messages is an Oracle Application Express application.
Topics:
You may need to translate messages if your application:
Includes PL/SQL regions or PL/SQL processes, or calls a PL/SQL package, procedure, or function. If it does, you may need to translate the generated HTML.
Uses a language that is not one of the ten languages into which Oracle Application Express is translated. If it does, you may need to translate messages used in reports.
This section explains how to translate messages used in PL/SQL procedures.
Topics:
See Also:
APEX_LANG in Oracle Application Express API Reference
If your application includes PL/SQL regions or PL/SQL processes or calls PL/SQL package, procedures, or functions, you may need to translate generated HTML. First, you define each message on the Translatable Messages page. Second, you use the APEX_LANG.MESSAGE API to translate the messages from PL/SQL stored procedures, functions, triggers, or packaged procedures and functions.
You create translatable messages on the Translate Messages page.
To define a new translation message:
Interactive Grid Messages Requiring Translation lists the interactive grid messages that require translation.
Table 20-2 Interactive Grid Messages Requiring Translation
| Message Name | English Text |
|---|---|
|
|
Collapse control break |
|
|
Expand control break |
|
|
%0 rows deleted |
|
|
Duplicate identity |
|
|
First |
|
|
Last |
|
|
Load More Rows |
|
|
Next |
|
|
%0 - %1 |
|
|
%0 - %1 of %2 |
|
|
Previous |
|
|
Added |
|
|
Changed |
|
|
Deleted |
|
|
Page %0 |
|
|
%0 rows selected |
|
|
Sort Ascending |
|
|
Sort Ascending %0 |
|
|
Sort Descending |
|
|
Sort Descending %0 |
|
|
Don't Sort |
|
|
Total %0 |
|
|
Interactive Grid %0 |
|
|
Actions |
|
|
Add |
|
|
Add Row |
|
|
Aggregate |
|
|
Aggregation |
|
|
All |
|
|
All Text Columns |
|
|
Alternative |
|
|
and |
|
|
Approx. Count Distinct |
|
|
Overal Approx. Count Distinct |
|
|
Area |
|
|
Ascending |
|
|
Authorization |
|
|
Auto |
|
|
Average |
|
|
Overall Average |
|
|
Label Axis Title |
|
|
Decimal Places |
|
|
Value Axis Title |
|
|
Background Color |
|
|
Bar |
|
|
between |
|
|
Both |
|
|
Bubble |
|
|
Cancel |
|
|
Case Sensitive |
|
|
(Case Sensitive) |
|
|
Change View |
|
|
Changes saved |
|
|
Chart |
|
|
Chart View |
|
|
Close |
|
|
Blue |
|
|
Green |
|
|
Orange |
|
|
Red |
|
|
Yellow |
|
|
Colors |
|
|
Column |
|
|
Column %0 |
|
|
Column Purpose |
|
|
Columns |
|
|
Complex |
|
|
Compute |
|
|
contains |
|
|
Control Break |
|
|
Count |
|
|
Count Distinct |
|
|
Overall Count Distinct |
|
|
Overall Count |
|
|
Create %0 |
|
|
Data |
|
|
Data Type |
|
|
Date |
|
|
days |
|
|
Default Settings |
|
|
Default Type |
|
|
Delete |
|
|
Are you sure you would like to delete this report? |
|
|
Delete Row |
|
|
Delete Rows |
|
|
Descending |
|
|
Detail |
|
|
Detail View |
|
|
Direction |
|
|
Disabled |
|
|
does not contain |
|
|
does not start with |
|
|
Donut |
|
|
Download |
|
|
Choose Format |
|
|
Duplicate Aggregation |
|
|
Duplicate Control Break |
|
|
Duplicate Row |
|
|
Duplicate Rows |
|
|
Edit |
|
|
Edit Chart |
|
|
Edit Group By |
|
|
Blind Copy (bcc) |
|
|
Message |
|
|
Copy (cc) |
|
|
Email sent. |
|
|
Subject |
|
|
Recipient (to) |
|
|
Enabled |
|
|
equals |
|
|
Example |
|
|
Expression |
|
|
Type |
|
|
Filter |
|
|
Filter... |
|
|
Filters |
|
|
First |
|
|
Flashback |
|
|
Format |
|
|
CSV |
|
|
HTML |
|
|
Format Mask |
|
|
Freeze |
|
|
Functions and Operators |
|
|
Funnel |
|
|
Go |
|
|
greater than |
|
|
greater than or equals |
|
|
Grid |
|
|
Grid View |
|
|
Group |
|
|
Group By |
|
|
Group By View |
|
|
Condition Type |
|
|
Heading |
|
|
Heading Alignment |
|
|
Help |
|
|
<p>You can insert, update, and delete data directly within this interactive grid.</p> <p>Insert a new row by clicking the Add Row button.</p> <p>Edit existing data by double-clicking a specific cell. For larger editing work, click Edit to enter editing mode. In editing mode, you can single-click or use the keyboard to edit specific cells.</p> <p>Use the Change menu to duplicate and delete rows. To enable the Change menu, use the check boxes to select one or more rows.</p> <p>Duplicate a selected row by clicking the Change menu and selecting Duplicate Rows. Delete a selected row by clicking the Change menu and selecting Delete Row.</p> |
|
|
Editing Capabilities |
|
|
<p>An interactive grid presents a set of data in a searchable, customizable report. You can perform numerous operations to limit the records returned, and change the way the data is displayed.</p> <p>Use the Search field to filter the records returned. Click Actions to access numerous options for modifying the report layout, or use the Column Heading menus on displayed columns.</p> <p>Use Report Settings to save your customizations to a report. You can also download the data from the report to an external file or email the data to yourself or others.</p> <p>To learn more, see Using Interactive Grids" in <em>Oracle Application Express End User's Guide</em></p> |
|
|
Overview |
|
|
<p>You can customize the interactive grid to display data in various different ways using the built-in capabilities.</p> <p>Use the Column Heading menus or the Actions menu to determine which columns to display, in what sequence, and freeze columns. You can also define various data filters and sort the data returned.</p> <p>Use the View button (adjacent to the Search field) to access other data views that may have been defined by the application developer. You can also create a chart or view an existing chart.</p> <p><em>Note: Click <strong>Help</strong> in the interactive grid dialogs to obtain more detailed information on the selected function.</em></p> |
|
|
Reporting Capabilities |
|
|
Interactive Grid Help |
|
|
<p>Use this dialog to aggregate columns. Aggregated values display at the bottom of the data, or if Control Breaks are defined, at the bottom of each break.</p> <p><strong>Aggregation List</strong><br> The Aggregation list displays defined aggregations. Disable an existing aggregation by deselecting it.<br> Click Add (+) to create a new aggregation, or Delete (−) to remove an existing aggregation.</p> <p><strong>Aggregation Settings</strong><br> Use the form on the right to define the aggregation.<br> Select the Column name and Aggregation type.<br> Optionally, enter a tooltip for the aggregation.<br> If you have defined a Control Break, selecting <strong>Show Overall Value</strong> displays the overall average, total, or similar value at the bottom of the data.</p> <p><em>Note: Access the Aggregation dialog in the Actions menu or by clicking the column heading and sum(∑ ).</em></p> |
|
|
Aggregation Help |
|
|
<p>Use this dialog to define a chart which displays as a separate data view.<br> Select a chart Type, configure the chart settings, and click <strong>Save.</strong></p> <p><strong>Chart Settings</strong></br> The chart attributes that display vary depending on the chart type. A number of attributes can be entered to define the chart. Attributes marked with a red asterisk are mandatory.</p> <p>Below are all available attributes across the different chart types (in alphabetical order): <ul> <li>Aggregation - Select how to aggregate the associated chart values.</li> <li>Close - Select the column that contains the daily stock close price (Stock chart only).</li> <li>Decimal Places - Enter the number of decimal places to which the values are rounded.</li> <li>Direction - In relation to the Sort By attribute, specify whether the data is sorted in ascending or descending values.</li> <li>High - Select the column that contains the high value (Range and Stock charts only).</li> <li>Label - Select the column that contains the text for each data point.</li> <li>Label Axis Title - Enter the title that displays on the label axis.</li> <li>Low - Select the column that contains the low value (Range and Stock charts only).</li> <li>Nulls - In relation to the Sort By attribute, specify how you want records with null values to be sorted in relation to records with non null values.</li> <li>Open - Select the column that contains the daily stock opening price (Stock chart only).</li> <li>Orientation - Select whether the chart elements, such as bars, display vertically or horizontally.</li> <li>Series - Select the column used for defining your multi-series dynamic query.</li> <li>Stack - Specify whether the data items are stacked.</li> <li>Sort By - Select whether the chart is sorted by the label or the value(s).</li> <li>Target - Select the column to be used for defining the target value on this chart. When set, the Value attribute defines the filled area within the slice and the Target represents the value of the whole slice (Funnel chart only).</li> <li>Value - Select the column that contains the data to be plotted.</li> <li>Value Axis Title - Enter the title that displays on the value axis.</li> <li>Volume - Select the column that contains the daily stock volume (Stock chart only).</li> <li>X - Select the column that contains the x-axis value for this chart (Bubble and Scatter charts only).</li> <li>Y - Select the column that contains the y-axis value for this chart (Bubble and Scatter charts only).</li> <li>Z - Select the column that contains the bar width or bubble radius (Bar, Bubble, and Range charts only)</li> </p> |
|
|
Chart Help |
|
|
<p> Use this dialog to choose which columns display and in what order.</p> <p>Hide a column by deselecting it.<br> Reorder columns by clicking Move Up ( ↑ ) or Move Down (↓ ).<br> Use the drop down selector to list All columns, Displayed columns, or Not Displayed columns.</p> <p>Optionally, use the form to specify the minimum width of a column in pixels.</p> <p><em> Note: You can also reorder displayed columns by clicking the drag handle (at the start of the column heading) and dragging the column left or right. You can also change the column width of displayed columns by selecting the column separator, between headings, and moving it left or right.</em></p> |
|
|
Columns Help |
|
|
<p> Use this dialog to define additional columns based on mathematical and functional computations performed against existing columns.</p> <p><strong>Computation List</strong><br> The Computation list displays defined computations. Disable an existing computation by deselecting it.<br> Click Add (&plus) to add a new computation, or Delete (− ) to remove an existing computation.</p> <p><strong>Computation Settings</strong><br> Use the form to define the computation.<br> Enter the column details such as heading, label, and select alignment settings.<br> Use the Expression textarea to enter the column(s) and associated functions for the computation.<br> Select the appropriate data type, and optionally a format mask, for the new column.</p> |
|
|
Compute Help |
|
|
<p>Use this dialog to define a control break on one or more columns.</p> <p><strong>Control Break List</strong><br> The Control Break list displays defined control breaks. Disable an existing control break column by deselecting it.<br> Click Add (&plus) to include a new column in the control break, or Delete (− ) to remove an existing column from the control break.<br> To reorder columns, click Move Up (↑ ) or Move Down (↓ ) to move the selected column up and down relative to other columns. </p> <p><strong>Control Break Settings</strong><br> Use the form to define the control break column.<br> Selected a control break column, the sort direction, and how to order null columns (columns with no value).</p> <p><em> Note: When viewing the interactive grid, you can define a control break by clicking a Column Heading and selecting the control break icon.</em></p> |
|
|
Control Break Help |
|
|
<p>Use this dialog to download all the current rows to an external file. The file will contain only the currently displayed columns, using any filters and sorts applied to the data.</p> <p>Select the file format and click Download.<br> Note: CSV will not include text formatting such as aggregates and control breaks.</p> <p>To email the file, select Send as Email and enter the email details (Recipient, Subject and Message).</p> |
|
|
Download Help |
|
|
<p>Use this dialog to configure data filters which limit the rows returned.</p> <p><strong>Filter List</strong><br> The Filter list displays defined filters. Disable an existing filter by deselecting it.<br> Click Add (&plus) to create a new filter, or Delete (− ) to remove an existing filter.</p> <p><strong>Filter Settings</strong><br> Use the form to define the filter properties. <br> Select the appropriate filter type:<br>   ; Row - filter for a term in any filterable column.<br>   ; Column - filter a specific column with a specified operator and value.</p> <p><em> Note: When viewing the interactive grid, you can define row filters by typing directly into the Search field. Click Select Columns to Search to limit the search to a specific column. Alternately, open a Column Heading menu and select a value to create a column filter.</em></p> |
|
|
Filter Help |
|
|
<p>Use this dialog to view the data as it existed at a previous point in time. </p> <p>Enter the number of minutes in the past to execute the flashback query.</p> |
|
|
Flashback Help |
|
|
Group By Help |
|
|
<p>Use this dialog to highlight rows or columns of data based on the condition entered.</p> <p><strong>Highlight List</strong><br> The Highlight list displays defined highlights. Disable an existing highlight by deselecting it.<br> Click Add (&plus) to create a new highlight, or Delete (− ) to remove an existing highlight.<br> <p><strong>Highlight Settings</strong><br> Use the form to define the highlight properties.<br> Enter the name, select Row or Column, and select the HTML color codes for the background and text.<br> Select the appropriate <strong>Condition Type </strong> to highlight specific data: <br>   ; Row - highlight the term in any column. <br>   ; Column - highlight within a specific column based on the specified operator and value.</p> |
|
|
Highlight Help |
|
|
<p>Use this dialog to save changes you have made to the current grid layout and configuration.<br> Application developers can define multiple alternate report layouts. Where permissible, you and other end users can save a report as Public, which makes the report available to all other users of the grid. You can also save a report as a Private report that only you can view.</p> <p>Select from the available types and enter a name for the saved report.</p> |
|
|
Report Help |
|
|
<p>Use this dialog to set the display order.<p> <p><strong>Sort List</strong><br> The Sort dialog displays a list of configured sorting rules.<br> Click Add (&plus) to create a sort column, or Delete (− ) to remove a sort column.<br> Click Move Up (↑ ) and Move Down (↓ ) to move the selected sort column up and down relative to the other sort columns. </p> <p><strong>Sort Settings</strong><br> Select a sort column, the sort direction, and how to order null columns (columns with no value).</p> <p><em> Note: Data can be sorted by columns which are not displayed; however, not all columns may be sortable.</em><br> <em> Displayed columns can be sorted by pressing the up (ascending) or down (descending) arrows at the end of the column headings. To add a subsequent column to an existing sort, hold the Shift key and click the up or down arrow.</em></p> |
|
|
Sort Help |
|
|
Subscription Help |
|
|
Hide |
|
|
High |
|
|
Highlight |
|
|
Horizontal |
|
|
hours |
|
|
Icon |
|
|
Icon View |
|
|
in |
|
|
in the last |
|
|
in the next |
|
|
Inactive Setting |
|
|
Inactive Settings |
|
|
An internal error has occurred while processing the Interactive Grid request. |
|
|
Invalid Date Format |
|
|
Invalid Setting |
|
|
Invalid Settings |
|
|
Sort By has been set to %0, but no column as been selected for %0. |
|
|
Invalid Value |
|
|
Not Displayed |
|
|
is not empty |
|
|
is empty |
|
|
Label |
|
|
Label |
|
|
Last |
|
|
Last Day |
|
|
Last Hour |
|
|
Last Minute |
|
|
Last Month |
|
|
Last Week |
|
|
Last %0 Days |
|
|
Last %0 Hours |
|
|
Last %0 Minutes |
|
|
Last %0 Months |
|
|
Last %0 Weeks |
|
|
Last %0 Years |
|
|
Last Year |
|
|
Cell Alignment |
|
|
Use Group For |
|
|
less than |
|
|
less than or equals |
|
|
Line |
|
|
Line with Area |
|
|
Listagg |
|
|
Low |
|
|
Separate multiple Addresses with commas |
|
|
matches regular expression |
|
|
Maximum |
|
|
Overall Maximum |
|
|
Median |
|
|
Overall Median |
|
|
Minimum |
|
|
Overall Minimum |
|
|
minutes |
|
|
Minutes ago |
|
|
months |
|
|
The data contains more than %0 rows which exceeds the maximum allowed. Please apply additional filters in order to view the results. |
|
|
Name |
|
|
Named Report |
|
|
Next Day |
|
|
Next Hour |
|
|
Next Minute |
|
|
Next Month |
|
|
Next Week |
|
|
Next %0 Days |
|
|
Next %0 Hours |
|
|
Next %0 Minutes |
|
|
Next %0 Months |
|
|
Next %0 Weeks |
|
|
Next %0 Years |
|
|
Next Year |
|
|
No data found |
|
|
not between |
|
|
not equals |
|
|
Region with ID %0 is not an Interactive Grid region or does not exist in application %1. |
|
|
not in |
|
|
not in the last |
|
|
not in the next |
|
|
Nulls |
|
|
Numeric |
|
|
Off |
|
|
On |
|
|
1 minute ago |
|
|
Open Color Picker: %0 |
|
|
Open |
|
|
Operator |
|
|
Orientation |
|
|
Pie |
|
|
Pivot |
|
|
Pivot View |
|
|
Separate values with "%0" |
|
|
Polar |
|
|
Center |
|
|
End |
|
|
Start |
|
|
Primary |
|
|
Primary Default |
|
|
Primary Report |
|
|
Radar |
|
|
Range |
|
|
Refresh |
|
|
Refresh Row |
|
|
Refresh Rows |
|
|
Remove %0 |
|
|
Report |
|
|
Report deleted |
|
|
Alternative report saved for all users |
|
|
Default report saved for all users |
|
|
Private report saved |
|
|
Public report saved for all users |
|
|
Report data as of %0 minutes ago |
|
|
Report data as of 1 minute ago |
|
|
Report - Edit |
|
|
Report - Save As |
|
|
Report Settings |
|
|
Saved Interactive Grid with static ID %0 does not exist. |
|
|
Report View |
|
|
Reset |
|
|
Revert Changes |
|
|
Revert Rows |
|
|
Row |
|
|
Row Actions |
|
|
Actions for row %0 |
|
|
Row %0 Column %1 |
|
|
Row %0 |
|
|
Rows Per Page |
|
|
Save |
|
|
Save As |
|
|
Save Report Settings |
|
|
Default |
|
|
Private |
|
|
Public |
|
|
Saved Reports |
|
|
Scatter |
|
|
Search |
|
|
Search: All Text Columns |
|
|
Search: %0 |
|
|
Search: Full Text |
|
|
Search for '%0' |
|
|
Selection Actions |
|
|
- Select - |
|
|
Select 1 row in the master region |
|
|
Select columns to search |
|
|
Send as Email |
|
|
Series |
|
|
Show Overall Value |
|
|
Single Row View |
|
|
Sort |
|
|
Sort By |
|
|
You can define only one sort per column. |
|
|
Change Menu |
|
|
Stack |
|
|
starts with |
|
|
Stock |
|
|
Subscription |
|
|
Sum |
|
|
Overall Sum |
|
|
Interactive Grid with %0 rows and %1 columns. Report: %2, View: %3, Displayed Rows Start: %4, Displayed Rows End: %5 |
|
|
Target |
|
|
Text Color |
|
|
Toggle |
|
|
Tooltip |
|
|
Type |
|
|
Unfreeze |
|
|
Unit |
|
|
There are unsaved changes. Do you want to continue? |
|
|
Value |
|
|
Value |
|
|
A value is required. |
|
|
Text |
|
|
Vertical |
|
|
View |
|
|
Displayed |
|
|
Volume |
|
|
weeks |
|
|
Minimum Column Width (Pixel) |
|
|
%0 between %1 and %2 |
|
|
%0 contains %1 |
|
|
%0 does not contain %1 |
|
|
%0 equals %1 |
|
|
%0 greater than %1 |
|
|
%0 greater than or equal to %1 |
|
|
%0 in %1 |
|
|
%0 in the last %1 days |
|
|
%0 in the last %1 hours |
|
|
%0 in the last %1 minutes |
|
|
%0 in the last %1 months |
|
|
%0 in the last %1 weeks |
|
|
%0 in the last %1 years |
|
|
%0 in the last day |
|
|
%0 in the last hour |
|
|
%0 in the last minute |
|
|
%0 in the last month |
|
|
%0 in the last week |
|
|
%0 in the last year |
|
|
%0 in the next %1 days |
|
|
%0 in the next %1 hours |
|
|
%0 in the next %1 minutes |
|
|
%0 in the next %1 months |
|
|
%0 in the next %1 weeks |
|
|
%0 in the next %1 years |
|
|
%0 in the next day |
|
|
%0 in the next hour |
|
|
%0 in the next minute |
|
|
%0 in the next month |
|
|
%0 in the next week |
|
|
%0 in the next year |
|
|
%0 is not empty |
|
|
%0 is empty |
|
|
%0 less than %1 |
|
|
%0 less than or equal to %1 |
|
|
%0 like %1 |
|
|
%0 matches regular expression %1 |
|
|
%0 minutes ago |
|
|
%0 not between %1 and %2 |
|
|
%0 not equals %1 |
|
|
%0 not in %1 |
|
|
%0 not in the last %1 days |
|
|
%0 not in the last %1 hours |
|
|
%0 not in the last %1 minutes |
|
|
%0 not in the last %1 months |
|
|
%0 not in the last %1 weeks |
|
|
%0 not in the last %1 years |
|
|
%0 not in the last day |
|
|
%0 not in the last hour |
|
|
%0 not in the last minute |
|
|
%0 not in the last month |
|
|
%0 not in the last week |
|
|
%0 not in the last year |
|
|
%0 not in the next %1 days |
|
|
%0 not in the next %1 hours |
|
|
%0 not in the next %1 minutes |
|
|
%0 not in the next %1 months |
|
|
%0 not in the next %1 weeks |
|
|
%0 not in the next %1 years |
|
|
%0 not in the next day |
|
|
%0 not in the next hour |
|
|
%0 not in the next minute |
|
|
%0 not in the next month |
|
|
%0 not in the next week |
|
|
%0 not in the next year |
|
|
%0 not like %1 |
|
|
%0 starts with %1 |
|
|
X |
|
|
Y |
|
|
years |
|
|
Z |
|
|
Monday, 12 January, 2016 |
|
|
January |
|
|
16 hours ago |
|
|
in 16h |
|
|
Other Columns |
|
|
Row %0 of %1 |
|
|
Row %0 |
|
|
Displayed Columns |
|
|
Exclude Null Values |
|
|
Previous |
|
|
Next |
|
|
Settings Menu |
|
|
Add |
|
|
Delete |
Oracle Application Express is translated into German, Spanish, French, Italian, Japanese, Korean, Brazilian Portuguese, Simplified Chinese, and Traditional Chinese. If your application uses a language that is not among the ten languages into which Oracle Application Express is translated, you must translate messages displayed by the Application Express reporting engine.
For example, if you develop a Russian application and want to include report messages, such as pagination, in Russian, you must translate the strings used in messages displayed in reports.
Topics:
To create a translation message:
%0, %1), ensure that your defined message also contains the same named and number of positional substitution values.To edit text messages:
Internal Messages Requiring Translation lists the internal messages that require translation.
Table 20-3 Internal Messages Requiring Translation
| Message Name | English Text |
|---|---|
|
|
Toggle %0 |
|
|
(Active) |
|
|
Please wait <span id="apex_login_throttle_sec">%0</span> seconds to login again. |
|
|
The login attempt has been blocked. |
|
|
List of Values |
|
|
Open list for: %0 |
|
|
(Completed) |
|
|
Correct errors before saving. |
|
|
Current version of data in database has changed since user initiated update process. current checksum = "%0" application checksum = "%1". |
|
|
Popup Calendar: %0 |
|
|
#LABEL# is greater than specified maximum date %0. |
|
|
#LABEL# does not match format %0. |
|
|
#LABEL# is less than specified minimum date %0. |
|
|
#LABEL# is not between the valid range of %0 and %1. |
|
|
#LABEL# is not within valid year range of %0 and %1. |
|
|
Cancel |
|
|
Close |
|
|
Help |
|
|
OK |
|
|
Save |
|
|
Sorry, this page isn't available |
|
|
Error Message |
|
|
Download |
|
|
Go to error |
|
|
Help Text: %0 |
|
|
Item %0 not found. |
|
|
#LABEL# is not between the valid range of %0 and %1. |
|
|
#LABEL# is not a multiple of %0. |
|
|
#LABEL# must match to the values %0 and %1. |
|
|
No |
|
|
Yes |
|
|
current |
|
|
More... |
|
|
Loading |
|
|
#LABEL# is greater than specified maximum %0. |
|
|
#LABEL# must be Numeric. |
|
|
#LABEL# does not match number format %0 (For example, %1). |
|
|
#LABEL# is less than specified minimum %0. |
|
|
#LABEL# is not between the valid range of %0 and %1. |
|
|
This page was already submitted and can not be re-submitted. |
|
|
#LABEL# must have some value. |
|
|
Popup List of Values: %0. |
|
|
Processing |
|
|
Load more |
|
|
Search |
|
|
%0, rich text editor |
|
|
%0d |
|
|
in %0d |
|
|
%0h |
|
|
in %0h |
|
|
%0m |
|
|
in %0m |
|
|
%0mo |
|
|
in %0mo |
|
|
%0s |
|
|
in %0s |
|
|
%0w |
|
|
in %0w |
|
|
%0y |
|
|
in %0y |
|
|
Success Message |
|
|
Next |
|
|
Previous |
|
|
Toolbar |
|
|
Expand / Collapse Navigation |
|
|
Expand / Collapse Side Column |
|
|
Theme number is invalid or theme is not a current UI theme. |
|
|
Start of page |
|
|
Value Required |
|
|
Please wait until the page is fully loaded and try again. |
|
|
Chart series error %0 for %1. |
|
|
1 error has occurred. |
|
|
%0 errors have occurred. |
|
|
Invalid Login Credentials . |
|
|
Chart |
|
|
Label for Expand / Collapse Navigation |
|
|
Label for Expand / Collapse Side Column |
|
|
Invalid set of rows requested, the source data of the report has been modified. |
|
|
Next |
|
|
Next Set |
|
|
Previous |
|
|
Previous Set |
|
|
Chart |
|
|
report total |
|
|
reset pagination |
|
|
Show All |
|
|
%0 days ago |
|
|
%0 days from now |
|
|
%0 hours ago |
|
|
%0 hours from now |
|
|
%0 minutes ago |
|
|
%0 minutes from now |
|
|
%0 months ago |
|
|
%0 months from now |
|
|
Now |
|
|
%0 seconds ago |
|
|
%0 seconds from now |
|
|
%0 weeks ago |
|
|
%0 weeks from now |
|
|
%0 years ago |
|
|
%0 years from now |
|
|
Total |
|
|
After upgrading, ensure the series attribute Label Column is mapped to a Date / Timestamp column. |
|
|
Unable to create interactive grid page. %0 |
|
|
You can personalize the appearance of this application by changing the Theme Style. Please select a Theme Style from the list below and click on Apply Changes. |
|
|
Region Display |
|
|
Use Application Default Style |
|
|
Appearance |
|
|
The column index referenced in the aggregate %0 does not exist. |
|
|
The column break needs to be in the beggining of the columns array. |
|
|
The column group index referenced in %0 does not exist. |
|
|
The column index referenced in the highlight %0 does not exist. |
|
|
The parent group index referenced in %0 does not exist. |
|
|
Calendar |
|
|
Close |
|
|
Ok |
|
|
Authentication failed. |
|
|
OAuth access token not available or expired. |
|
|
Server responded with unsupported OAuth token type. |
|
|
Minimum row requested: %0, rows found but not displayed: %1 |
|
|
Sort by this column. |
|
|
This form contains unsaved changes. Press Ok to proceed without saving your changes. |
|
|
row(s) %0 - %1 of more than %2 |
|
|
row(s)%0 - %1 of %2 |
|
|
%0 - %1 of %2 |
Table 20-4 lists the interactive report messages that require translation.
Table 20-4 Interactive Report Messages Requiring Translation
| Message Name | English Text |
|---|---|
|
|
Column %0 |
|
|
3D |
|
|
Actions |
|
|
Actions Menu |
|
|
Add |
|
|
Add Function |
|
|
Add Group By Column |
|
|
Add Pivot Column |
|
|
Add Row Column |
|
|
Add Subscription |
|
|
Average |
|
|
Count |
|
|
Maximum |
|
|
Median |
|
|
Minimum |
|
|
Mode |
|
|
Sum |
|
|
Aggregate |
|
|
Aggregates are displayed after each control break and at the end of the report. |
|
|
Aggregation |
|
|
All |
|
|
All Columns |
|
|
All Rows |
|
|
Alternative |
|
|
Alternative Default: %0 |
|
|
and |
|
|
Apply |
|
|
As of %0 |
|
|
Ascending |
|
|
Average %0 |
|
|
between |
|
|
Background Color |
|
|
blue |
|
|
Bottom |
|
|
Calendar |
|
|
Cancel |
|
|
Category |
|
|
Cell |
|
|
Chart |
|
|
Initializing... |
|
|
Chart label must be specified |
|
|
The maximum row count for a chart query limits the number of rows in the base query, not the number of rows displayed. Your base query exceeds the maximum row count of %0. Please apply a filter to reduce the number of records in your base query. |
|
|
Chart Type |
|
|
Check All |
|
|
Choose report download format |
|
|
clear |
|
|
Column |
|
|
Filter... |
|
|
Column Heading |
|
|
Column Heading Menu |
|
|
Column Information |
|
|
Column %0 |
|
|
Columns |
|
|
contains |
|
|
does not contain |
|
|
in |
|
|
is in the last |
|
|
is in the next |
|
|
is not null |
|
|
is null |
|
|
is not in the last |
|
|
is not in the next |
|
|
like |
|
|
not in |
|
|
not like |
|
|
matches regular expression |
|
|
Computation |
|
|
Computation Expression |
|
|
Create a computation using column aliases. |
|
|
(B+C)*100 |
|
|
INITCAP(B)||', '||INITCAP(C) |
|
|
CASE WHEN A = 10 THEN B + C ELSE B END |
|
|
Compute |
|
|
Control Break |
|
|
Control Break Columns |
|
|
Control Breaks |
|
|
Count Distinct |
|
|
Count Distinct |
|
|
Count %0 |
|
|
Daily |
|
|
Data |
|
|
Report data as of %0 minutes ago. |
|
|
Date |
|
|
Day |
|
|
Default |
|
|
Default Report Type |
|
|
Delete |
|
|
Delete Checked |
|
|
Would you like to delete these report settings? |
|
|
Would you like to perform this delete action? |
|
|
Delete Default Report |
|
|
Delete Report |
|
|
Descending |
|
|
Description |
|
|
Single Row View |
|
|
Direction |
|
|
Disable |
|
|
Disabled |
|
|
Display |
|
|
Display in Report |
|
|
Displayed |
|
|
Displayed Columns |
|
|
- Do not aggregate - |
|
|
Do Not Display |
|
|
Down |
|
|
Download |
|
|
Duplicate pivot column. Pivot column list must be unique. |
|
|
Edit |
|
|
Edit Alternative Default |
|
|
Edit Chart Settings |
|
|
Edit Chart |
|
|
Edit Filter |
|
|
Edit Group By |
|
|
Edit Highlight |
|
|
Edit Pivot |
|
|
|
|
|
Email Address |
|
|
Bcc |
|
|
Body |
|
|
Cc |
|
|
Frequency |
|
|
Email has not been configured for this application. Please contact your administrator. |
|
|
Email Address must be specified. |
|
|
See attached. |
|
|
Subject |
|
|
Email Subject must be specified. |
|
|
To |
|
|
Enable |
|
|
Enable/Disable |
|
|
Enabled |
|
|
Error |
|
|
Examples |
|
|
Examples: |
|
|
Exclude Null Values |
|
|
Expand/Collapse |
|
|
Expression |
|
|
Filter |
|
|
Filter Expression |
|
|
The filter expression is too long. |
|
|
Filter Type |
|
|
Filters |
|
|
Select columns to search. |
|
|
Flashback |
|
|
A flashback query enables you to view the data as it existed at a previous point in time. |
|
|
Unable to perform flashback request. |
|
|
Format |
|
|
Format Mask |
|
|
Function |
|
|
Function %0 |
|
|
Functions |
|
|
Functions / Operators |
|
|
Go |
|
|
green |
|
|
Group By |
|
|
Group by column must be specified |
|
|
Group By Column |
|
|
The maximum row count for a Group By query limits the number of rows in the base query, not the number of rows displayed. Your base query exceeds the maximum row count of %0. Please apply a filter to reduce the number of records in your base query. |
|
|
Group By Sort |
|
|
Group By Sort Order |
|
|
Horizontal Column |
|
|
Help |
|
|
An Interactive Report displays a predetermined set of columns. The report may be further customized with an initial filter clause, a default sort order, control breaks, highlighting, computations, aggregates and a chart. Each Interactive Report can then be further customized and the results can be viewed, or downloaded, and the report definition can be stored for later use. <p/> An Interactive Report can be customized in three ways: the search bar, actions menu and column heading menu. |
|
|
The actions menu is used to customize the display of your Interactive Report. |
|
|
Aggregates are mathematical computations performed against a column. Aggregates are displayed after each control break and at the end of the report within the column they are defined. <p/> <ul><li><b>Aggregation</b> allows you to select a previously defined aggregation to edit.</li> <li><b>Function</b> is the function to be performed (e.g. SUM, MIN).</li> <li><b>Column</b> is used to select the column to apply the mathematical function to. Only numeric columns will be displayed.</li></ul> |
|
|
You can include one chart per Interactive Report. Once defined, you can switch between the chart and report views using links below the search bar. <p/> <ul><li><b>Chart Type</b> identifies the chart type to include. Select from horizontal bar, vertical bar, pie or line.</li> <li><b>Label</b> allows you to select the column to be used as the label.</li> <li><b>Axis Title for Label</b> is the title that will display on the axis associated with the column selected for Label. This is not available for pie chart.</li> <li><b>Value</b> allows you to select the column to be used as the value. If your function is a COUNT, a Value does not need to be selected.</li> <li><b>Axis Title for Value</b> is the title that will display on the axis associated with the column selected for Value. This is not available for pie chart.</li> <li><b>Function</b> is an optional function to be performed on the column selected for Value.</li></ul> |
|
|
Clicking on any column heading exposes a column heading menu. <p/> <ul><li><b>Sort Ascending icon</b> sorts the report by the column in ascending order.</li> <li><b>Sort Descending icon</b> sorts the report by the column in descending order.</li> <li><b>Hide Column</b> hides the column.</li> <li><b>Break Column</b> creates a break group on the column. This pulls the column out of the report as a master record.</li> <li><b>Column Information</b> displays help text about the column, if available.</li> <li><b>Text Area</b> is used to enter case insensitive search criteria (no need for wild cards). Entering a value will reduce the list of values at the bottom of the menu. You can then select a value from the bottom and the selected value will be created as a filter using '=' (e.g. column = 'ABC'). Alternatively, you can click the flashlight icon and the entered value will be created as a filter with the 'LIKE' modifier (e.g. column LIKE '%ABC%').<li><b>List of Unique Values</b> contains the first 500 unique values that meet your filters. If the column is a date, a list of date ranges is displayed instead. If you select a value, a filter will be created using '=' (e.g. column = 'ABC').</li></ul> |
|
|
Computations allow you to add computed columns to your report. These can be mathematical computations (e.g. NBR_HOURS/24) or standard Oracle functions applied to existing columns (some have been displayed for example, others, like TO_DATE, can also be used). <p/> <ul><li><b>Computation</b> allows you to select a previously defined computation to edit.</li> <li><b>Column Heading</b> is the column heading for the new column.</li> <li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li> <li><b>Format Mask</b> is an Oracle format mask to be applied against the column (e.g. S9999).</li> <li><b>Computation</b> is the computation to be performed. Within the computation, columns are referenced using the aliases displayed.</li> </ul> <p/> Below computation, the columns in your query are displayed with their associated alias. Clicking on the column name or alias will write them into the Computation. Next to Columns is a Keypad. These are simply shortcuts of commonly used keys. On the far right are Functions. <p/> An example computation to display Total Compensation is: <p/> <pre>CASE WHEN A = 'SALES' THEN B + C ELSE B END</pre> (where A is ORGANIZATION, B is SALARY and C is COMMISSION) |
|
|
Used to create a break group on one or several columns. This pulls the columns out of the Interactive Report and displays them as a master record. |
|
|
To view the details of a single row at a time, click the single row view icon on the row you want to view. If available, the single row view will always be the first column. Depending on the customization of the Interactive Report, the single row view may be the standard view or a custom page that may allow update. |
|
|
Allows the current result set to be downloaded. The download formats will differ depending upon your installation and report definition but may include CSV, XLS, PDF, or RTF. |
|
|
Used to add or modify the where clause on the query. You first select a column (it does not need to be one that is displayed), select from a list of standard Oracle operators (=, !=, not in, between), and enter an expression to compare against. The expression is case sensitive and you can use % as a wildcard (for example, STATE_NAME like A%). |
|
|
Performs a flashback query to allow you to view the data as it existed at a previous point in time. The default amount of time that you can flashback is 3 hours (or 180 minutes) but the actual amount will differ per database. |
|
|
<p>Format enable you to customize the display of the report. Format contains the following submenu:</p> <ul><li>Sort</li> <li>Control Break</li> <li>Highlight</li> <li>Compute</li> <li>Aggregate</li> <li>Chart</li> <li>Group By</li> <li>Pivot</li> </ul> |
|
|
You can define one Group By view per saved report. Once defined, you can switch between the group by and report views using view icons on the Search bar. To create a Group By view, you select: <p></p><ul> <li>the columns on which to group</li> <li>the columns to aggregate along with the function to be performed (average, sum, count, etc.)</li> </ul> |
|
|
Highlighting allows you to define a filter. The rows that meet the filter are highlighted using the characteristics associated with the filter. <p/> <ul><li><b>Name</b> is used only for display.</li> <li><b>Sequence</b> identifies the sequence in which the rules will be evaluated.</li> <li><b>Enabled</b> identifies if the rule is enabled or disabled.</li> <li><b>Highlight Type</b> identifies whether the Row or Cell should be highlighted. If Cell is selected, the column referenced in the Highlight Condition is highlighted.</li> <li><b>Background Color</b> is the new color for the background of the highlighted area.</li> <li><b>Text Color</b> is the new color for the text in the highlighted area.</li> <li><b>Highlight Condition</b> defines your filter condition.</li></ul> |
|
|
You can define one Pivot view per saved report. Once defined, you can switch between the pivot and report views using view icons on the Search bar. To create a Pivot view, you select: <p></p> <ul> <li>the columns on which to pivot</li> <li>the columns to display as rows</li> <li>the columns to aggregate along with the function to be performed (average, sum, count, etc.)</li> </ul> |
|
|
If you have customized your Interactive Report, the report settings will be displayed below the Search Bar and above the report. If you have saved customized reports, they will be shown as tabs. You can access your alternate views by clicking the tabs. Below the tabs are the report settings for the current report. This area can be collapsed and expanded using the icon on the left. <p/> For each report setting, you can: <ul><li><b>Edit</b> by clicking the name.</li> <li><b>Disable/Enable</b> by unchecking or checking the Enable/Disable check box. This is used to temporarily turn off and on the setting.</li> <li><b>Remove</b> by click the Remove icon. This permanently removes the setting.</li></ul> <p/> If you have created a chart, you can toggle between the report and chart using the Report View and Chart View links shown on the right. If you are viewing the chart, you can also use the Edit Chart link to edit the chart settings. |
|
|
Resets the report back to the default settings, removing any customizations that you have made. |
|
|
Sets the number of records to display per page. |
|
|
Saves the customized report for future use. You provide a name and optional description and can make the report accessible to the public (that is, all users who can access the primary default report). You can save four types of interactive reports:
If you save customized reports, a Reports selector displays in the Search bar to the left of the Rows selector (if this feature is enabled). |
|
|
At the top of each report page is a search region. The region provides the following features: <p/> <ul><li><b>Select columns icon</b> allows you to identify which column to search (or all).</li> <li><b>Text area</b> allows for case insensitive search criteria (no need for wild cards).</li> <li><b>Rows</b> selects the number of records to display per page.</li> <li><b>[Go] button</b> executes the search.</li> <li><b>Actions Menu icon</b> displays the actions menu (discussed next).</li></ul> <p/> Please note that all features may not be available for each report. |
|
|
<li><b>Actions Menu</b> enables you to customize a report. See the sections that follow.</li> |
|
|
<li><b>Select columns icon</b> enables you to identify which column to search (or all).</li> |
|
|
<li><b>Reports</b> displays alternate default and saved private or public reports.</li> |
|
|
<li><b>Rows</b> sets the number of records to display per page.</li> |
|
|
<li><b>Text area</b> enables you to enter case insensitive search criteria (wild card characters are implied).</li> <li><b>Go button</b> executes the search. Hitting the enter key will also execute the search when the cursor is in the search text area.</li> |
|
|
<li><b>View Icons</b> switches between the icon, report, detail, chart, group by, and pivot views of the report if they are defined.</li> |
|
|
Used to modify the columns displayed. The columns on the right are displayed. The columns on the left are hidden. You can reorder the displayed columns using the arrows on the far right. Computed columns are prefixed with <b>**</b>. |
|
|
Used to change the column(s) to sort on and whether to sort ascending or descending. You can also specify how to handle nulls (use the default setting, always display them last or always display them first). The resulting sorting is displayed to the right of column headings in the report. |
|
|
When you add a subscription, you provide an email address (or multiple email addresses, separated by commas), email subject, frequency, and start and end dates. The resulting emails include an HTML version of the interactive report containing the current data using the report setting that were present when the subscription was added. |
|
|
Hide Column |
|
|
Highlight |
|
|
Highlight Condition |
|
|
Highlight Type |
|
|
Highlight When |
|
|
Highlights |
|
|
1 inactive setting |
|
|
%0 inactive settings |
|
|
Interactive Report Help |
|
|
Invalid |
|
|
Invalid computation expression. %0 |
|
|
The end date must be greater than the start date. |
|
|
The end date must be greater than the start date. |
|
|
Invalid filter expression. %0 |
|
|
Invalid filter query |
|
|
1 invalid setting |
|
|
%0 invalid settings |
|
|
%0 is in the last %1 |
|
|
%0 is in the next %1 |
|
|
%0 is not in the last %1 |
|
|
%0 is not in the next %1 |
|
|
Keypad |
|
|
Label |
|
|
Axis Title for Label |
|
|
Label Prefix |
|
|
Last Day |
|
|
Last Hour |
|
|
Last Month |
|
|
Last Week |
|
|
Last %0 Days |
|
|
Last %0 Hours |
|
|
Last %0 Years |
|
|
Last Year |
|
|
Line |
|
|
Map it |
|
|
The query is estimated to exceed the maximum allowed resources. Please modify your report settings and try again. |
|
|
This query returns more then %0 rows, please filter your data to ensure complete results. |
|
|
Maximum %0 |
|
|
Median %0 |
|
|
%0 minutes ago |
|
|
Minimum %0 |
|
|
Month |
|
|
Monthly |
|
|
More Data |
|
|
Move |
|
|
Move All |
|
|
Region Static ID must be specified as the page contains multiple interactive reports. |
|
|
Name |
|
|
New Aggregation |
|
|
- New Category - |
|
|
New Category |
|
|
New Computation |
|
|
> |
|
|
Next Day |
|
|
Next Hour |
|
|
Next Month |
|
|
Next Week |
|
|
Next %0 Days |
|
|
Next %0 Hours |
|
|
Next %0 Years |
|
|
Next Year |
|
|
No |
|
|
No aggregation defined. |
|
|
No column information available. |
|
|
No computation defined. |
|
|
- No End Date - |
|
|
- None - |
|
|
Not a valid email address. |
|
|
Null Sorting |
|
|
Nulls Always First |
|
|
Nulls Always Last |
|
|
Flashback time must be numeric. |
|
|
Sequence must be numeric. |
|
|
Operator |
|
|
orange |
|
|
Other |
|
|
Percent of Total Count %0 (%) |
|
|
Percent of Total Sum %0 (%) |
|
|
Percent of Total Count |
|
|
Percent of Total Sum |
|
|
Pie |
|
|
Add Pivot Column |
|
|
Aggregate must be specified. |
|
|
You cannot aggregate on a column selected to as row column. |
|
|
Pivot Column %0 |
|
|
Pivot column must be specified. |
|
|
Pivot Columns |
|
|
The maximum row count for a Pivot query limits the number of rows in the base query, not the number of rows displayed. Your base query exceeds the maximum row count of %0. Please apply a filter to reduce the number of records in your base query. |
|
|
Select different row column. The HTML expression or link in the row column contains column defined as pivot or aggregate column. |
|
|
Pivot Sort |
|
|
< |
|
|
Primary |
|
|
Primary Report |
|
|
Private |
|
|
Public |
|
|
red |
|
|
Region Static ID %0 does not exist. |
|
|
Remove |
|
|
Remove Aggregate |
|
|
Remove All |
|
|
Remove Chart |
|
|
Remove Control Break |
|
|
Remove Filter |
|
|
Remove Flashback |
|
|
Remove Group By |
|
|
Remove Highlight |
|
|
Remove Pivot |
|
|
Remove Report |
|
|
Rename Default Report |
|
|
Rename Report |
|
|
Report |
|
|
Saved Interactive report with alias %0 does not exist. |
|
|
The number of display columns in the report reached the limit. Please click Select Columns under Actions menu to minimize the report display column list. |
|
|
Report does not exist. |
|
|
Saved Interactive Report ID %0 does not exist. |
|
|
Report Settings |
|
|
< Report View |
|
|
Reports |
|
|
Reset |
|
|
Restore report to the default settings. |
|
|
Row |
|
|
Row column must be different from the pivot column. |
|
|
Row Column %0 |
|
|
Row column must be specified. |
|
|
Row Columns |
|
|
Row Filter |
|
|
Row %0 of %1 |
|
|
Row Order |
|
|
Row text contains |
|
|
Rows |
|
|
Rows Per Page |
|
|
The number of display columns in the report reached the limit. Please click Select Columns under Actions menu to minimize the report display column list. |
|
|
Save |
|
|
Save as Default |
|
|
The current report settings are used as the default for all users. |
|
|
Save Default Report |
|
|
Save Report |
|
|
Save Report * |
|
|
Saved Report |
|
|
Saved Report = "%0" |
|
|
Search |
|
|
Search Bar |
|
|
Search: %0 |
|
|
Search Report |
|
|
- Select Category - |
|
|
- Select Column - |
|
|
Select Columns |
|
|
Computed columns are prefixed with **. |
|
|
- Select Function - |
|
|
- Select Group By Column - |
|
|
- Select Pivot Column - |
|
|
Select Row |
|
|
- Select Row Column - |
|
|
- Select Sort Column - |
|
|
Select Value |
|
|
Selected Columns |
|
|
Send |
|
|
Sequence |
|
|
Sort |
|
|
Sort Ascending |
|
|
Sort Column |
|
|
Sort Descending |
|
|
Sort Order |
|
|
space |
|
|
Status |
|
|
Subscription |
|
|
Ending |
|
|
Starting From |
|
|
Sum %0 |
|
|
Region = %0, Report = %1, View = %2, Displayed Rows Start = %3, Displayed Rows End = %4, Total Rows = %5 |
|
|
Text Color |
|
|
days |
|
|
hours |
|
|
minutes |
|
|
months |
|
|
weeks |
|
|
years |
|
|
Toggle |
|
|
Top |
|
|
Unauthorized |
|
|
Ungrouped Column |
|
|
Column Heading must be unique. |
|
|
Highlight Name must be unique. |
|
|
unsupported data type |
|
|
Up |
|
|
Please enter a valid color. |
|
|
Please enter a valid format mask. |
|
|
Value |
|
|
Axis Title for Value |
|
|
Value Required |
|
|
Vertical Column |
|
|
View Chart |
|
|
View Detail |
|
|
View Group By |
|
|
View Icons |
|
|
View Pivot |
|
|
View Report |
|
|
Week |
|
|
Weekly |
|
|
Working Report |
|
|
%0 days |
|
|
%0 hours |
|
|
%0 minutes |
|
|
%0 months |
|
|
%0 weeks |
|
|
%0 years |
|
|
Year |
|
|
yellow |
|
|
Yes |
|
|
As Default Report Settings |
|
|
As Named Report |
|
|
Only displayed for developers |
|
|
Expression 2 |
|
|
Invalid set of rows requested, the source data of the report has been modified. |
|
|
Report |
|
|
Reporting Period |
|
|
Reset Pagination |
|
|
Primary Default |
|
|
%0 - %1 of %2 |