Troubleshooting
Problem
The default for the Mail To lookup returns all email addresses from the Maximo persons table that are not null. This action includes those marked as inactive. It is possible to filter the returned list to exclude inactive personnel by modifying the REPORTPARAMETER relationship.
Resolving The Problem
To change the filter, go to Database Configuration. Search for REPORTPARAMETER. Click on the Relationships tab. Expand the EMAIL entry. Change the Where clause from:
emailaddress is NOT NULL
to read:
emailaddress is NOT NULL and personid in (select personid from maxuser
where status in (select value from synonymdomain where domainid =
'MAXUSERSTATUS' and maxvalue = 'ACTIVE'))
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21622406