Filter Supervisor lookup in Work Order by employee type

Technote (FAQ)


Question

Is there a way to filter the out of box Supervisor field and lookup by the person's employee type?

Answer

Yes, you need to create a table domain for the Person object and apply it to the Supervisor
Domain field.

Here are the steps to achieve this:
1. Go to Domains
2. At bottom right click Add new Domain >Add New Table Domain
3. Name the Domain such as SUPV
4. You don't need a validation where clause because this is an out of the box lookup
5. Add List where clause as employeetype =1 (my example was using
MAXDEMO and had a choice of 1 or 2)


If you have multiples you want to see it would be employeetype
in('type1','type2','type3')

6. Go to Database Configuration and bring up WORKORDER table.
7. On Attributes tab, find SUPERVISOR and add SUPV to Domain field.
Save.
8. on List tab, Apply Configuration Changes and Start DB config and
refresh until it completes.

To test:
1. Go to Work Order Tracking and insert a new WO.
2. Go to Supervisor field and click Select Value, only those Person
records which have the employee value(s) you specified in the Domain
List Where Clause appear.

Link to other similar Table domain examples:
1. Filtering an out of box lookup:
http://www-01.ibm.com/support/docview.wss?uid=swg21307834
2. Using a table domain to filter default lookups
http://www-01.ibm.com/support/docview.wss?uid=swg21296887

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Domains

Software version:

6.2.1, 6.2.2, 6.2.3, 6.2.4, 6.2.5, 6.2.6, 6.2.7, 6.2.8, 7.1.1, 7.5

Operating system(s):

Platform Independent

Reference #:

1617539

Modified date:

2014-10-13

Translate my page

Machine Translation

Content navigation