Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



Table domain for value list lookup

From: cbrandon63 (2011-11-22 15:22)

Hi all,
I need to create a lookup for user field MRLA2 (MR table - desktop requisitions) which I am calling "Buyer". I have created a person group and assigned all my buyers to this person group. I have further created a query on persons "WHERE personid in (select respparty from persongroupteam where persongroup = 1002) and status = 'ACTIVE'" that will list all the buyers.
I want to be able to create a value list using this query to populate the MRLA2 field with the personid but I want to display both the personid and the displayname in the value list.
(I have a similar requirement with the manufacturer field - want to lookup only companies with company type "M".)
Can someone define the exact steps to accomplish this in application designer?


From: Shannon Rotz (2011-11-22 22:28)

Instead of using the person group, I would suggest just using the Job Code
on the Person record. Mark all of the buyers as 'Buyer' and then do the
following:
1. Create a table domain where List Where Clause = jobcode = 'buyer'
and status = 'active' (also use this for the Validation Where Clause)
2. Attach the table domain to the MRLA2 field in DBConfig
3. In App Designer, put 'PERSON' for the lookup. This will result in
the standard list that is built-in for the person table. It has some extra
columns that you might not want, though - if so, you can export the
LOOKUP.XML and add your own lookup (just copy the PERSON lookup and remove
columns).

That should do it .


Shannon

From: MAXIMO@yahoogroups.com [mailto:MAXIMO@yahoogroups.com] On Behalf Of
cbrandon63
Sent: November-22-11 7:23 AM
To: MAXIMO@yahoogroups.com
Subject: [MAXIMO List] Table domain for value list lookup


Hi all,
I need to create a lookup for user field MRLA2 (MR table - desktop
requisitions) which I am calling "Buyer". I have created a person group and
assigned all my buyers to this person group. I have further created a query
on persons "WHERE personid in (select respparty from persongroupteam where
persongroup = 1002) and status = 'ACTIVE'" that will list all the buyers.
I want to be able to create a value list using this query to populate the
MRLA2 field with the personid but I want to display both the personid and
the displayname in the value list.
(I have a similar requirement with the manufacturer field - want to lookup
only companies with company type "M".)
Can someone define the exact steps to accomplish this in application
designer?