Export table work_order_change_ticket

[DCIM_Support]

This question was originally posted on DCIM Support by Olegas Domanskis on 2019-02-19

---

Hello

In the export database there is a table work_order_change_ticket, which if I understand right is supposed to contain work order to request tickets relations. But it seems that it is not updated for some reason. I've assigned different request tickets to the work order and that table contains both assignments. Even after I've deleted one of them. Via REST API I can see only one request ticket assigned to the work order. 

(CID:140218699)

[DCIM_Support]

This answer was originally posted on DCIM Support by Niels Kjeldsen on 2019-02-25

---

Hi

Just a quick thing to check is that the export actually did run after you updated the work orders. The export database is only update when the job runs.

If you still see a difference there might be a bug.

Best,

Niels

(CID:140707771)

[DCIM_Support]

This answer was originally posted on DCIM Support by Olegas Domanskis on 2019-02-25

---

Hello

I've executed ETL manually from the DCO web portal. Also It was executed by scheduler.  

The records are still there.

I've tried swoExportJob_v2.0.0 and "No transformation" transformations. 

(CID:140707779)

[DCIM_Support]

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.