Hi All,
I've been searching around but haven't been able to find anything on reporting on Move's in Windchill.
Would anyone be able to help me with a couple of questions:
- What table is the move history of an object stored in in the Query Builder?
- What is the correct way to join this table to the EPM Document to get a move history as well as the times of the moves?
Any help would be greatly appreciated!
Many thanks,
I believe the table you're looking for is the "LOCATIONCHANGERECORD" table. The column IDA3A4 would join to the IDA2A2 of the object. In SQL it would look like this:
select r.*
from locationchangerecord r, epmdocument d, epmdocumentmaster m
where m.cadname = 'jamie_test1.drw'
and m.ida2a2 = d.ida3masterreference
and d.ida2a2 = r.ida3a4;
I don't to much (or anything for that matter) with QueryBuilder, so you'll have to convert it yourself. 
Also keep in mind the the objects aren't always EPMDocuments. The CLASSNAMEKEYA4 tell you which type of object it is you're working with.
~Jamie
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
