QML - WTPArts non published to ERP system

[Marco_Tosin]

Hi all,

I have a need of a Query Builder to find which WTParts has not been published to ERP system.

I have already done a QML which lists all ESI transitions and the state of transitions (Pending, successful, failed), but because this query join WTParts and ESI Transition, obviously can’t list part not having a distribution target assigned.

Can someone point me in the right direction?

Thanks in advance.

Marco Tosin

[Marco_Tosin]

Hi all,

I have open a call with PTC TS to get my answer.

Attached you can find the report they sent to me.

This is the text of their email:

"Hello Mr. Tosin,

The PTC Case 11808623 was assigned to me.

I build myself a report, which you could use.
It is attached to the mail as a qml.

The report will list all WTParts related to an ESI Transaction (Parts which has been published have this relation).
If you want to display all non-published parts, just select in the criteria window “Transaction Number” equals null."