Skip to main content
RG_1041729910-Marble
10-Marble
Jul 19, 2023 1:49 PM UTC
Solved

Scheduling in CWC Thingworx Apps

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?

RG_10417299_0-1689774440464.png

RG_10417299_1-1689774456483.png

 

 

 

mstarnaud
mstarnaudAnswer
16-Pearl
Jul 24, 2023 8:10 PM UTC

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.

View in thread

3 replies

mstarnaud
mstarnaud16-PearlAnswer
16-Pearl
Jul 24, 2023 8:10 PM UTC

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.

Translate
    RG_1041729910-MarbleAuthor
    10-Marble
    Jul 26, 2023 1:10 PM UTC

    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)?


     

    Translate
    mstarnaud
    mstarnaud16-Pearl
    16-Pearl
    Jul 26, 2023 1:32 PM UTC

    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).

    Translate
      Terms & ConditionsAccessibility statement