22.7.3.2 Interactive Grid Messages Requiring Translation
Lists the interactive grid messages that require translation.
| Message Name | English Text |
|---|---|
|
|
Collapse control break |
|
|
Expand control break |
|
|
%0 rows deleted |
|
|
Duplicate identity |
|
|
First |
|
|
Grid Footer |
|
|
Last |
|
|
Load All |
|
|
Show More |
|
|
Next |
|
|
Page rows |
|
|
Page %0 |
|
|
%0 - %1 |
|
|
%0 - %1 of %2 |
|
|
Page Selection |
|
|
Pagination |
|
|
Previous |
|
|
Added |
|
|
Changed |
|
|
Deleted |
|
|
Row header |
|
|
Select All |
|
|
Page %0 |
|
|
Select Row |
|
|
%0 %1 selected |
|
|
%0 cells selected |
|
|
%0 rows selected |
|
|
Sort Ascending |
|
|
Sort Ascending %0 |
|
|
Sort Descending |
|
|
Sort Descending %0 |
|
|
Don't Sort |
|
|
State Icons |
|
|
Grid Status |
|
|
%0 %1 |
|
|
1 %0 |
|
|
Total %0 |
|
|
Interactive Grid %0 |
|
|
Actions |
|
|
Add |
|
|
Add Row |
|
|
Aggregate |
|
|
Aggregation |
|
|
All |
|
|
All Text Columns |
|
|
Alternative |
|
|
and |
|
|
Approx. Count Distinct |
|
|
Overall 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 |
|
|
Copy to Clipboard |
|
|
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 checkboxes 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 |
|
|
Cell Selection |
|
|
Selection |
|
|
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 |
|
|
Stretch Column |
|
|
Subscription |
|
|
Sum |
|
|
Overall Sum |
|
|
Interactive Grid. Report: %0, View: %1. |
|
|
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 |
|
|
%0 items selected |
|
|
Select Item |
|
|
Select %0 |
Parent topic: Translating Messages Used Internally by APEX