IBM Support

Filter Request Page Lookup for Mail To Field

Technote (troubleshooting)


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'))

Document information

More support for: Maximo Asset Management
Report Admin

Software version: 7.1.1, 7.5

Operating system(s): Platform Independent

Software edition: Edition Independent

Reference #: 1622406

Modified date: 10 March 2016

Translate this page: