Maximo Open Forum

 View Only

 Need to send the Count of records in the where clause of escalation in the notification attached to it.

  • Customizations
Tanishk Rathi's profile image
Tanishk Rathi posted 04-15-2024 02:25

Hi All,

I want to send the count of all records in the where clause which we have in the escalation condition.

The count has to be shared through the communication template attached to it. 

Suppose I have an escalation created for one condition in that where clause will fetch the 100 records, Now I want to send only one notification from the escalation saying 100 records are there to be acted upon to the user. Currently the escalation sends one email for each record, i.e. the users are getting 100 emails.

Thanks, in advance! 


#maximo #escalation #notification #ibm #sql #suggestions 

Martin Fabra's profile image
Martin Fabra

Hi @Tanishk Rathi!

If you schedule a report, you send an only email with an attached report. In that report you can see the number of record. 

With this you can perhaps move forward or it will help you take it into account.


Regards!