Maximo List Archive

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.



seeking help automating deletion of child records

From: therron (2016-09-01 08:42)


Goal: If a Person record is set to INACTIVE, there are certain fields on the Person record that I want to make NULL (which I can handle, no problem). I also want to delete certain child records from PHONE and EMAIL. For example, I want to delete any PHONE entry where the type = 'WORKCELL'; also, I want to delete any EMAIL entries where the type = 'WORK'. This is important on newer versions of Maximo as two People cannot have the same Email address.

In the event that the human that changes the status to INACTIVE fails to clean all the data properly/thoroughly, I want to automate this. Is it possible to do with the built-in Maximo tools (no Java coding required)? I'm currently trying an Escalation with Actions, but I can't figure out how to make it delete. I'm hoping/assuming this can be done with an Automation Script (which I haven't tried yet). Anyone done something like that, and know if it'll work?

Travis Herron