Maximo Open Forum

 View Only

  • 1.  Making a field required based on Y/N across two table

    Posted 08-07-2025 19:01
    Edited by Christopher Winston 09-16-2025 13:46

    Hi, struggling to get this to work. Request is to have a Y/N question on a workorder that makes a field required on a custom table if the answer is yes(1) and the worktype is CM.  Have tried the guide to create cond expression, then use attribute restrictions but get an error that there is no relationship between the tables. However I see the relationship. My expression is WORKORDER.WORKTYPE<>'CM' AND :WORKORDER.TRI_CMFAILMODET='1'

    Have also tried an automation script, however that is not working at all.

    Any help is appreciated.

    ##Was able to get an auto script to do this - thanks for the suggestions.


    #MaximoApplicationSuite

    ------------------------------
    Rod Sprouse
    Targa Resources
    ------------------------------



  • 2.  RE: Making a field required based on Y/N across two table

    Posted 08-08-2025 10:41

    When you load your custom table in Database Configuration and go to the Relationships tab, do you see a relationship with a Name of WORKORDER? The Child Object field for that relationship should also be set to WORKORDER. On your custom table, I assume there are WONUM and SITEID attributes, so the Where Clause should be wonum = :wonum and siteid = :siteid, where Maximo will replace :wonum and :siteid with those bits of data from the current record in your custom table.

    In your expression, your reference to WORKORDER.WORKTYPE is unbound -- it is missing the leading colon : that tells Maximo to use data from the current record. Corrected, that condition will be :WORKORDER.WORKTYPE <> 'CM'.

    I hope that helps.



    ------------------------------
    Blessings,
    Jason Uppenborn
    Cohesive
    ------------------------------

    Original Message


  • 3.  RE: Making a field required based on Y/N across two table

    Posted 08-10-2025 07:31

    Please refer: Configure Conditional Properties to make a field required  where you provide conditional properties against a signature option and a conditional expression and if it is true, use the property 'inputmode' and provide its value as 'true'

    also, when the condition is false, then provide value of this property to false



    ------------------------------
    Shahid Saeed Khan
    Oman Airports Management Company
    ------------------------------

    Original Message


Related Content