Query Builder Report

[Marco_Tosin]

I'm building a Query Builder Report to find what WTparts has been modified by a process invoked by a list which comes from SAP.

To better clarify: we have 7 different views in Windchill (Design, Mfg, and other five views, one for each division).

Design View, Mfg View and Division View have three different LC.

In most cases it's Windchill that send LC state modified to SAP, but when a SAP user change LC state, using one of three specific state of Division view, SAP write a record in a file that Windchill process every night to align his Division view state.

Because this process also align more than 30 MFG attributes from SAP to Windchill, we iterate WTParts with modified attributes while only do a set state (without iteration) to the parts.

I was told to build the report using WTpart, Object History and Lifecycle History.

Which type of join may I have to use?

TIA

[LoriSood]

Marco,

I think you want to use the following type of joins:

[Marco_Tosin]

Hi Lori,

thanks for your suggestions.

I have post my request also on PTC/User and this is the link of what we discuss with Mike Lockwood.

http://portal.ptcuser.org/p/fo/st/thread=55413

If I can take advantage of this thread, I would like to say that help about Query Builder is a thing PTC do not give very well.

There are so many types of object in Windchill and there's practically no documentation about how to join all that types.

Another thing I don't understand is why in the Windchill standard installation there are so few report available, while, if you ask TS or KB, you can have it many other.

If this report are available in TS or KB, why it isn't already available in Windchill, and I have to lost my time in search of them?