- Lubos Strejcek
- Comments Off on Add SNM domain in maximo
- Tags: maximo, maximo domains, synonym, tip, useful
Add SNM domain in maximo
The creation of domains is very easy except the SYNONYM domain, so I made a little tutorial for me and you..
Path: Maximo menu -> System configuration -> Platofrm configuration -> Domains (its easy but hard to remember)
This typeof domain is a bit special so you are not able to make it by easiest way (Add a new Domain).. okay.. could be easier but..
At first there is table with basic fields of SNM domain:
|Internal Value||Specify the internal value for which you want a synonym.
For example, in the STATUS domain, if you want to create a synonym for WAPPR called WAPPR, you would specify the WAPPR internal value.
|Value||Specify the synonym value you want a user to see.
For example, WAPPR.
|Description||Type a description of the synonym to differentiate it from the existing value.|
In the Synonym Domain , the Internal Value is used by the system and must be unique. The Value and its description are what users see.
Check if domain name does not exists
select * from MAXDOMAIN where domainid='%DOMAINID%'
Create snm domain as record in mxdomain table
insert into MAXDOMAIN (domainid,description,domaintype,maxtype,length,scale,maxdomainid,internal) VALUES ('SNM_TEST', 'test synonym domain','SYNONYM','UPPER', 16, 0, NEXT VALUE FOR MAXDOMAINSEQ,0)
Create a value for snm domain in syndom table
INSERT INTO SYNONYMDOMAIN (DOMAINID, MAXVALUE, VALUE, DESCRIPTION, DEFAULTS, SYNONYMDOMAINID, VALUEID) VALUES ('SNM_TEST', 'OPEN','OPEN', 'Open', 1, NEXT VALUE FOR SYNONYMDOMAINSEQ, 'FAU_SYN_TEST|OPEN')
In this case we need a record with defined MAXVALUE , after that we are able to add any value with same MAXVALUE new by maximo web interface.