Skip to main content
Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
December 20, 2013
Question

QML - WTPArts non published to ERP system

  • December 20, 2013
  • 1 reply
  • 762 views

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

1 reply

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz IAuthor
21-Topaz I
January 27, 2014

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

Marco
Terms & ConditionsCookie settingsAccessibility statement