Getting Table/Crossover domains work in a Multi Language environment.
Fredrik Safstrom 27000148HY Comment (1) Visits (5929)
The domain application in Maximo is used for creating different domains in Maximo and two of these domain types enable you to validate and bring over data from other tables. This blog entry does not teach you how to use the Table and Crossover domains, rather it tells you how to get these two domains to work when looking up data from a table with Multi Language in use.
Due to the way Maximo handles Multi language functionality, you run into problems if you try to list and bring back data from a column that is Multi Language enabled. To illustrate this problem, consider the following table domain,
The AssetAttribute table have the Description column enabled for Multi Language and therefor need the column name prefixed with the table name. It is a good practice to prefix all column names for a table that has Multi Language enabled.
This is due to the way Maximo handles Multi Language, it joins the main table (AssetAttribute) with the language table (L_AssetAttribute) in the search and if you do not prefix the main table name the SQL query does not work and nothing is displayed when logging in as a secondary language.
So if you create a new Table/Crossover domain in Maximo and have installed secondary languages, keep this in mind.