Runtime usage of globalized data in reports
The report engine queries and displays values of localizable fields in the user language. Non-localizable fields are queried from the main storage tables. Localizable record data is displayed in the language of the user. You can run reports in the Report Manager, report sections in forms, and portal sections.
If the base language of the system remains the default US English, then the report engine queries, filters, and sorts values from the main tables and not from the language tables, for all base language users or US English users.
For base language users, the report engine queries, filters, and sorts localizable values from the language tables in the base language. For secondary language users, the report engine queries, filters, and sorts localizable values from the language tables.
If the user updates an editable report, the same rules are applied to the form changes at run time. Validation of required fields is applied on secondary values.
The report engine treats values that are inputted into the user filter at run time to be in the preferred language of the user. The report engine uses these values to filter from language tables for base or secondary language users.
If the Localize flag is enabled for a system filter value in the System Filter Columns section of the report, the report engine uses that value to filter the results, based on the language of the user at run time. If you create a report in a language other than US English, you can use the Localize flag to specify that the report runs only for users of your language. If you want the report to be run in multiple languages, you do not use the Localize flag, and the value of the system filter must be an internal value.
Example 1: Base language is US English
The base language of the system is US English. The triPeople report filters the triStatusCL field to be equal to Retired in US English and Retiré in French. The report engine compares the system filter with the records that are selected in the report, as in the following table.
| System filter value | Localize flag selected? | User language at run time | What does the report engine do at run time? |
|---|---|---|---|
| Retired (in US English) | No | Any user language | Considers system filter value as internal value, and filters results based on the matching value from the main table (T_ table). |
| Retired (in US English) | Yes | US English | Considers system filter value as in the language of the user at run time. Because the base language is US English, the system filter value is considered as internal value, and filters results based on the matching value from the main table (T_ table). |
| Retired (in US English) | Yes | Not US English | Considers system filter value as in the language of the user at run time, and filters results based on the matching value from the language table (L_ table), where LANGUAGE_ID column matches the language of the user at run time. Note: This is
not likely to return any results for non-US English users unless there
are "Retired" values in the language table for their respective language.
|
| Retiré (in French) | No | Any user language | Considers system filter value as internal value, and filters results based on the matching value from the main table (T_ table). Note: This is not likely to return any results
for any users unless there are "Retiré" values in the main table (T_
table).
|
| Retiré (in French) | Yes | US English | Considers system filter value as in the language of the user at run time. Because the base language is US English, the system filter value is considered as internal value, and filters results based on the matching value from the main table (T_ table) Note: This
is not likely to return any results for US English users unless there
are "Retiré" values in the main table (T_ table).
|
| Retiré (in French) | Yes | Not US English | Considers system filter value as in the language of the user at run time, and filters results based on the matching value from the language table (L_ table), where LANGUAGE_ID column matches the language of the user at run time. Note: This is
not likely to return any results for non-French users unless there
are "Retiré" values in the language table for their respective language.
|
Example 2: Base language is non-US English
The base language of the system is non-US English. The triPeople report filters the triStatusCL field to be equal to Retired in US English and Retiré in French. The report engine compares the system filter with the records that are selected in the report, as in the following table.
| System filter value | Localize flag selected? | User language at run time | What does the report engine do at run time? |
|---|---|---|---|
| Retired (in US English) | No | Any user language | Considers system filter value as internal value, and filters results based on the matching value from the main table (T_ table). |
| Retired (in US English) | Yes | US English | Considers system filter value as in the language of the user at run time, and filters results based on the matching value from the language table (L_ table), where LANGUAGE_ID column is US English language. Because the base language is not US English, the US English users are considered as any other language users in the system, so the report engine is filtering the values from the language table. |
| Retired (in US English) | Yes | Not US English | Considers system filter value as in the language of the user at run time, and filters results based on the matching value from the language table (L_ table), where LANGUAGE_ID column matches the language of the user at run time. Note: This is
not likely to return any results for non-US English users unless there
are "Retired" values in the language table for their respective language.
|
| Retiré (in French) | No | Any user language | Considers system filter value as internal value, and filters results based on the matching value from the main table (T_ table). Note: This is not likely to return any results
for any users unless there are "Retiré" values in the main table (T_
table).
|
| Retiré (in French) | Yes | US English | Considers system filter value as in the language of the user at run time, and filters results based on the matching value from the language table (L_ table), where LANGUAGE_ID column is US English language. Because the base language is not US English, the US English users are considered as any other language users in the system, so the report engine is filtering the values from the language table. Note: This is not likely to return
any results for US English users unless there are “Retiré”
values in the language table for US English users.
|
| Retiré (in French) | Yes | Not US English | Considers system filter value as in the language of the user at run time, and filters results based on the matching value from the language table (L_ table), where LANGUAGE_ID column matches the language of the user at run time. Note: This is
not likely to return any results for non-French users unless there
are "Retiré" values in the language table for their respective language.
|