Tuesday 31 December 2019

How to make fields accept different set of values though having same table domain associated

In the illustration shown below custom fields Leader on two different applications “Assets” and “Locations”, have same custom domain associated. We had a requirement whereby these fields were expected to be populated based on validation applicable as per the field (for this illustration I will take Asset application should accept active person while Locations should accept inactive ones only). 




The domain is of type table domain and pulls records from PERSON object. And the fields pulled all records from the underlying table for selection.














Though it appears that the dynamic behavior won’t be feasible without code, it is not so.
The only trick required is making use of maximo bind variables as required.
Modify the list where clause (and validation where as well) of the domain as below and you are done

(:&APPNAME&='ASSET' and status='ACTIVE') or (:&APPNAME&='LOCATION' and status='INACTIVE')
















Verify that domain is working perfectly well for both the fields.