Maximo Open Forum

 View Only

 Custom attributes in ASSETUSERCUSDFLT object

  • Assets
  • Customizations
Haris Cengic's profile image
Haris Cengic posted 02-03-2023 09:38

Non persistant MBO object ASSETUSERCUSDFLT store the default values for user custodians for mass asset modify.

Dialog is located in Application ASSET,  click on Move/Modify Asset, Select tab Users and Custodians and finally Modify All.  

There are some classes related to this process as well and I will like to avoid any modification to them. 

I created 2 new custom fields to ASSETUSERCUSDFLT and add them to the dialog.

ASSETUSERCUSDFLT.DFLTISSUE_DATE and ASSETUSERCUSDFLT.DFLTDOC_NUM

However updates to the ASSETUSERCUST will happen only for out of box attributes. 

Attribute Name Description
DFLTPERSON Stores the default value of person for mass move of assets.
DFLTISUSER T/F is this person a user?
DFLTISCUSTODIAN T/F is this person a custodian?
CANDELETE T/F can the person record be deleted from the assets selected

What do you suggest? Which approach to take to include custom fields as well in mass modify of custodian data?  

Automation Script?  I may update this data for 1000 records at once.

Thanks 

Prashant Sharma's profile image
Prashant Sharma posted 02-04-2023 01:24
Behind-the-scene data is not going to be stored in Non-Persistent MBOs and these fields are only to assist users in filling value when Modify Information for Asset.

Once data will be updated from this dialog it will be stored in ASSETLOCUSERCUST which is a persistent table, so you need to add both these attributes - DFLTISSUE_DATE and DFLTDOC_NUM in this table, and then your code should update the value into these columns into ASSETLOCUSERCUST tables. This code can be done via Automation Script or Java class file.

For Mass update, you need to fire SQL Query to update already existing data for one time on this table or use can use MXLoader.

Related Content