You may want to display localized fields, such as Program Type, Project Type and Activity Type, in all forms and reports.
Without automatic ID lookup, when Web Central loads a view where the data source contains a translatable field, such as projecttype.project_type
or programtype.program_type
, the view displays the proper language field for project_type
or program_type
, based on the current user locale. However, when the data source contains a foreign key to a translatable primary key field (e.g. project.project_type
or program.program_type
), the view does not display the proper language field from the foreign table; it displays the exact value in project.project_type
or program.program_type
. For example, when you look at a report of the program table, you want to see a localized value in the program.program_type
field, the same as if you were looking at a report of the programtype
table.
You can solve this problem and display localized foreign key fields using the Automatic ID Lookup feature. While this is an optional feature that is by default turned off, localized foreign key values can be displayed by default. To do so:
displayType="translate"
.projecttype.project_type
).For reporting panels (grids, charts, cross-tables, column reports, export, paginated reports), if the panel contains a foreign key field to a table that has a primary key lookup field, and that primary key field is not visible, the panel:
Cross-table panels:
groupBy
fields.Chart panels:
Review these views for examples of this feature:
Copyright © 1984-2019, ARCHIBUS, Inc. All rights reserved. |