Maximo

Maximo

Come for answers, stay for best practices. All we're missing is you.

 View Only
  • 1.  Update workorder/activity using POST REST call

    Posted 03/31/23 09:05 AM

    Hi,

    How to update WORKORDER.WONUM, WOACTIVITY.WONUM using workorderid(WORKORDER,WOACTIVITY) or _rowstamp value in a single REST POST call.
    I am using x-method-override : BULK for my operations.

    Thanks,
    Karthik Krishnamurthy



    ------------------------------
    karthik krishnamurthy
    ------------------------------

    #MaximoIntegrationandScripting
    #Maximo


  • 2.  RE: Update workorder/activity using POST REST call

    Posted 04/03/23 02:48 PM

    HI Karthik,

    Errr..... can you help me understand the use case for manipulating the WONUM value?  Have you removed the AUTONUM feature and are you setting it according to some business rule?  For the better part of almost three decades now, most customers will accept the AUTONUM feature.  Many will also include a prefix value to ensure separation of SITE based WONUM.  Other than that, please help me understand a) what you are trying to do technically, and b) why you would want to spend the effort doing so.   Have I understood your request correctly?

    Also, I would never use rowstamp to fetch or update a record.  That value is changed each time you touch the record, making it unreliable.



    ------------------------------
    Bradley K. Downing , MBA
    Senior Brand Technical Specialist
    IBM
    Bakersfield CA
    ------------------------------



  • 3.  RE: Update workorder/activity using POST REST call

    Posted 04/03/23 03:38 PM

    Adding to Bradley's message.

    There is no supported way to modify the WONUM no matter the method. This is part of the unique key that is then used on many child tables for referencing the work order. For example, since you mentioned WOACTIVITY the PARENT field corresponds to the WONUM of the parent work order. If you tried to update the WONUM you would need that update to cascade across all child objects. That's why we don't support modifying this record.

    If this reference is coming from another system and for some reason that reference changes over time, store it in another field. 



    ------------------------------
    Steven Shull
    ------------------------------