topic Re: Scheduling in CWC Thingworx Apps in Mfg Solutions & Apps

Scheduling in CWC Thingworx Apps

RG_10417299 — Wed, 19 Jul 2023 13:49:15 GMT

1-> Can anyone explain me how to generate Work Orders? (I have succesfully genrated the production routes)
an example will be helpful
2-> What are the difference between Job Order and Work Order?

Re: Scheduling in CWC Thingworx Apps

mstarnaud — Mon, 24 Jul 2023 20:13:13 GMT

Hi RG

I'll answer #2 first, Job Order vs Work Order : they are the same thing. In the database we use the word "Joborder".

For question #1, creating Job Orders, there's a few methods in CWC : the endpoint, or using a 3rd party extension shown in this other post. Sadly, as of now, the Scheduling screen doesn't have a Create/Add button, we can only edit those that already exist.

Re: Scheduling in CWC Thingworx Apps

RG_10417299 — Wed, 26 Jul 2023 13:10:02 GMT

Hi,
I used that endpoint service and I got success code in it.
But when I look for it in Scheduling(CWC UI) or in DB (in jobOrder table) I couldn't found it.

Somehow in DB (processRunning Table ) I can find some JobOrder data that I have pushed .

Can you explain how to fetch them in JobOrder Table in DB or in Scheduling(UI in CWC)?

Re: Scheduling in CWC Thingworx Apps

mstarnaud — Wed, 26 Jul 2023 13:34:37 GMT

Hi RG

This process is automatic, you should not have to do any database change for this. But to answer your question, the records initially get imported in ProcessRunning which is a todo list, a Timer (PTC.FSU.CORE.Process.ProcessQueue_TM) should be running every minute to process them, and then they should transfer to the ProcessCompleted table. Can you make sure that the Timer is active and also that its subscriptions (there should be 4) are all enabled? If I'm not mistaken, records stay in ProcessRunning only if the Timer & subscriptions aren't running, if there's an error it retries moments later and then goes to ProcessCompleted.

Once the import is finished processing, it should reach the JobOrder and JobOrder_ap tables (both tables share the same Uid column/numbers). They should also be visible in the Scheduling screen if the filters allow it (mostly the start & end times).