Expand all | Collapse all

IF MODIFIED attribute formula

  • 1.  IF MODIFIED attribute formula

    Posted Thu January 02, 2020 09:54 AM
    A PDF on Maximo formulas says:

    "...the formula grammar provides a way to check if the attribute has been
    modified:  IF(modified$priority,...) " [page 8]

    I tried to test this out in on the DESCRIPTION field in WOTRACK (Maximo

    IF(modified$ASSETNUM,"ASSETUM was modified.")

    Unfortunately, it doesn't seem to be working. If I create a blank WO, save, then choose an ASSETNUM, when I save, nothing happens.

    I also tried the exact example in the PDF on the PRIORITY field. That didn't work either.

    Does anyone know why the IF MODIFIED functionality for attribute formulas isn't working? Does it work for anyone else?



  • 2.  RE: IF MODIFIED attribute formula

    Posted 29 days ago

    I think the formula can not affect string type field e.g. ALN, LONGALN, and etc. Please try it in numeric type of fields like assetlockpriority in workorder. The following sample works fine in my environment.



  • 3.  RE: IF MODIFIED attribute formula

    Posted 28 days ago
    It seems that there is an issue with "modified" function. Try this instead of modified :

    IF(prev$assetnum<>assetnum,"ASSETNUM was modified.")

    You get the same result and it works.

    Serge Gagnon
    STI Maintenance
    Jonquiere QC