Technote (troubleshooting)
Problem(Abstract)
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'))
Rate this page:
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.