Maximo Open Forum

 View Only

 Are there add new record correctly and completely in child table

  • Customizations
Abdelrahman Elwakeel's profile image
Abdelrahman Elwakeel posted 07-18-2022 12:21

Hi,

Are there add new record correctly and completely in child table (after with event/action ) use except jython - automation script or java, I tried use method add() and setValue() but there some other attributes not be add in child table. appear me Msg after I use it.

riskAssessSet=mbo.getThisMboSet()
riskAssessSet.setWhere("ASSETNUM='"+str(assetnum)+"'")
RiskAssess = riskAssessSet.moveFirst()
if RiskAssess is not None:
AssetSet=RiskAssess.getMboSet("PLUSGASSETOFRSK")
AssetMbo = AssetSet.moveFirst()
if( AssetMbo!= None):
if(not AssetMbo.isNull("STDACTGRPNUM")):
StandardActionGroup = AssetMbo.getString("STDACTGRPNUM")
desc = StandardActionGroup
else:
desc = "empty"
ReiskReviewSet=RiskAssess.getMboSet("PLUSGRISKREVACT")
ReiskReview = ReiskReviewSet.add()
if ReiskReview is not None:
    ReiskReview.setValue("STDACTNUM","SA1")

(code is  is not complete, focus only on add() and setValue() )

BMXAA4195E - A value is required for the Standard Action field on the PLUSGRISKREVACT object.

But If use manual select from table domain than add record correctly and completely! 

Are there use code automation script like above?

example I have new field "Standard Action" in Asset Application and my goal copy and add record in Review Actions in Risk Assessment application from Standard Action Application after select Asset in Risk Assessment application (Maximo add-on "HSE")

I hope to clarify the problem Do you have the idea?

Prashant Sharma's profile image
Prashant Sharma
Hello,

Are you calling mboset.save() after this?

ReiskReviewSet=RiskAssess.getMboSet("PLUSGRISKREVACT")
ReiskReview = ReiskReviewSet.add()
if ReiskReview is not None:
    ReiskReview.setValue("STDACTNUM","SA1")
ReiskReviewSet.save()


Also, try using MboConstant when setting value to override some validation/access restriction as - ReiskReview.setValue("STDACTNUM","SA1",11L)