Hi All,
I'm trying to determine the best practice for inserting and updating current operation scheduling data like SetupHrs and RunMchHrs. On the Current Operations form, these fields are under the "Scheduling" and "Hours" sections. Current operations is based on the SLJobRoutes IDO which has a relationship from the jobroute table to the jrt_sch table where the scheduling columns are stored.
When I insert a new SLJobRoutes record via the additems endpoint in the REST API, it automatically creates the related jrt_sch record, but the properties are initialized without data (or as 0) regardless of what property values are set in the request body. It seems secondary tables on an IDO (like jrt_sch on the SLJobRoutes IDO) are read-only. In this case, is the best practice to create the current operation record via the SLJobRoutes IDO, then use the separate SLJrtSchs IDO to update the scheduling data?
Furthermore, even when updating via the SLJrtSchs IDO, certain fields will not update despite the response returning "Update succeeded". For example, both SetupHrs and RunMchHrs properties will not update, while other fields like SetupTicks and PcsPerMchHr update without issue.
Any help or direction is appreciated.
Thanks!
