Maximo Open Forum

 View Only

Related Content

  • 1.  Make audit enabled field null post save

    Posted 5 days ago
    Hi Team,
     
    I need some help to make audit enabled field blank/empty post saving the record and that blank/null value should not be set in audit field. 
     
    Before save :- audit enabled field will have value.
    After Save :- audit enabled field should be blank but field's null value should not be saved in audit field and should not make entry in audit table.
    Please let me know if any option avaiable to implement this.
    Thanks & Regards

    #Customizations
    #EverythingMaximo
    #HSE/OilandGas
    #MaximoApplicationSuite

    ------------------------------
    JustIn goodLuck
    ABS
    ------------------------------


  • 2.  RE: Make audit enabled field null post save

    Posted 2 hours ago

    Hi Justin,

    Based on my knowledge of audit fields, this is not possible with out of box configuration of audit enabled fields. Audit fields track any changes made to the field. 

    You may be able to do a hacky automation script. Create an automation script that would clear the UI after the commit that would not commit to the DB. I am not sure if that would work or not if there is not a commit to clear the field. I am not an automation script expert, just throwing out an idea.

    Thank you,



    ------------------------------
    Allan Henle
    Naviam
    ------------------------------

    Original Message


  • 3.  RE: Make audit enabled field null post save

    Posted 2 hours ago

    Justin,

    I do think an Automation Script is your best bet here. You could try writing a null (python None) to the field with a NOACTION modifier. Something like this:

    mbo.setValue('MYFIELDNAME', None, mbo.NOACTION)

    If that doesn't get you there you could always just run a SQL UPDATE statement from within the script. This is VERY much a workaround and bypasses Maximo logic, but it may be your best bet for this use case.



    ------------------------------
    Tim Ferrill
    Solutions Consultant
    Intelligent Technology Solutions
    tferrill@webuildits.com
    www.webuildits.com
    @tferrill/@webuildits
    ------------------------------

    Original Message