Skip to main content

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

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

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:
2012-11-15

Translate my page

Content navigation