IBM Support

Filter Request Page Lookup for Mail To Field

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

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Report Admin","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1.1;7.5","Edition":"Edition Independent","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21622406