Domains: SYNONYMS

Created
Nov 22, 2021 06:50 AM
Tags
configuration
SQL
Status
Completed
Created Date
 
SYNONYMS domains are special, reserved domains in the system. You cannot officially add or delete synonym domains. You can add new synonym values that are presented to the user. These work similar fashion like ALN domains. However, they let you add more values to be shown to user which corresponds to the built in internal values. Creating Synonym domains and adding internal values are not possible via UI. However, database queries can be made to insert those.
Adding a new SYNONYM domain
Synonym domains cannot be created in Database Configuration. They can be created in database directly using SQL.
The following query will create synonym domain with domainid as TESTSYNONYM, type as UPPER and length as 10.
insert into maxdomain
(domainid, description, domaintype, maxtype, length, scale, maxdomainid, internal)
values ('TESTSYNONYM', 'Testing Synonyms', 'SYNONYM', 'UPPER',10, 0, nextval for MAXDOMAINSEQ, 1)
This can now be viewed in Maximo. However, since it does not have any internal values yet. Maximo wont let you add any values in it.
Adding a new internal values in a SYNONYM domain
Again internal values can only be added using db query. The following query will add an internal value of ABC and value of ABC.
notion image
Now new values can be added in this domain using Maximo
Adding value in SYNONYM domain
This can be done using Maximo UI.
Open the domain and click New Row. Enter values and done.
notion image
 
ℹ️
Domains can conditionally show values. Please refer to Domains: Conditionally displaying domain values