How to pass WO list to the Get Notification fetch in Work Manager(SYCLO)?

[sudhiranjan_lenka]

Dear Experts,

We have a requirement for one of our client to pass the Work Order numbers to the Get Notification fetch at the time of Transmit.

Basically we want to fetch the notifications to mobile which are linked to the downloaded Work Orders, so we plan to send the list of Work Order numbers which are downloaded through the Get Work Orders to the Get Notification fetch.

I look forward to hear back your expert advise to achieve the above requirement.

We are working on the Work Manager 6.2.

Thanks,

Sudhir.

[sudhiranjan_lenka · Accepted solution]

We stored the WOs in the SMP DB in a temporary table at the time of Work Order fetch with the help of JDBC code and we read the WOs from the SMP DB at the time of Notification fetch.

Thanks,

Sudhir.

[mark_pe]

Sudhir,

From your requirement:

Requirement 1: We have a requirement for one of our client to pass the Work Order numbers to the Get Notification fetch at the time of Transmit.

Answer: In Agentry: The Fetch process is divided in stages:

1. Client Exchange Steps (Checking your clients data and comparing what it has to the backend to check for updates).
2. Server Exchange Steps (Checking and updating your client with data from the backend).
3. Removal Steps (Checking what does not exist in your backend and removing it from your client).

There is also clearing of the table to make sure that what you are comparing to is going to be cleared. This step is simply a table that would download what you have on your client and compare this to the backend to see what change in the backend. This is step 0.

From the steps above (0, 1, 2 and 3), the opportunity to do it is under Client Exchange Step or Server Exchange Step. The values of your Workorder available in the client If (NOT LOCAL) can be submitted to the backend to be written on a new table so that during the Server Exchange steps, a custom read will now get this number to be part of your Notification fetch. Now if it is NOT LOCAL then you may have to make sure that the process of retrieving the new created number is fetch prior to sending the Server Exchange Step.

The steps above should answer the requirements:

"Basically we want to fetch the notifications to mobile which are linked to the downloaded Work Orders, so we plan to send the list of Work Order numbers which are downloaded through the Get Work Orders to the Get Notification fetch."

In a simple SQL project before this can be done with a simple write and read to custom tables.

Best Regards,

Mark

[sudhiranjan_lenka]

Thank you so much Mark for your response.

We could able to manage this.

We stored the WOs in the SMP DB in a temporary table at the time of Work Order fetch with the help of JDBC code and we read the WOs from the SMP DB at the time of Notification fetch.

Thanks,

Sudhir.