Maximo Wire - The IBM Maximo Help & Discussion Forum
May 24, 2012, 09:19:18 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome to Maximo Wire, the IBM Maximo help forum. Feel free to register and ask any Maximo related questions you like.
 
  Home Help Search Login Register  
*
Pages: [1]   Go Down
  Print  
Author Topic: Adding Domian to the Attribute in maximo 6.2  (Read 760 times)
0 Members and 1 Guest are viewing this topic.
babhilash
Newbie
*

Karma: 2
Posts: 15



View Profile Email
« on: August 28, 2008, 02:49:58 pm »

I have created one new Domian of type ALN.
I am not able to find the newly created Domian in the lookup when i am tring it to bind with the attribute in database configuration.
Actually there are around 200 domainid totally but i am able to see only 50 of on choosing the lookup.

Does it require any more configuration
Logged
maurogrz
Global Moderator
Full Member
*****

Karma: 14
Posts: 111



View Profile Email
« Reply #1 on: August 28, 2008, 05:52:43 pm »

the select that belongs to the list of the valid domain for an attribute is this:
select count(*) from {oj l_maxdomain right outer join maxdomain on (l_maxdomain.ownerid=maxdomain.maxdomainid and l_maxdomain.langcode='YOURLANGCODE')} where domaintype in (select value from synonymdomain where domainid='DOMTYPE' and maxvalue in ('ALN'))

try to execute the select and have a look to the data returned....


Logged
Kumar
Newbie
*

Karma: 1
Posts: 6


View Profile
« Reply #2 on: September 25, 2008, 10:56:13 am »

The datatype and the data length should be the same for the field and the domain which you are assigning to the field.

The domain lookup shows only the domains which matches the datatype and data length of the field.

Hope this helps. Smiley
Logged
Pages: [1]   Go Up
  Print  
 
Jump to:  

Recent

TinyPortal v1.0 beta 4 © Bloc
Powered by MySQL Powered by PHP Powered by SMF 1.1.15 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!