Question & Answer
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
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21617539