I trying to discover what ways I can dynamically build a URL path to an object in the windchill database. We have external applications that I would like to be able to display the generated thumbnail representation that is stored in Windchill.
Doing some research, it appears the table FVITEM stores
It appears the table APPLICATIONDATA stores
It appears the table EPMDOCUMENT stores
I'm not sure how to relate (join) them all together yet. It looks like the pieces to be able to find the physical file, where it is stored is available so I could build a link to allow a user to view a thumbnail of the CAD Document.
My quesitons are:
You're pretty close to getting what you need. There is a little trick though. The FVITEM table does not store the filename in the vault. There is a UNIQUESEQUENCENUMBER column that you need to use to derive the file name. What you do is take the sequence number, convert it to hexidecimal, and then prefill it with 0's until it is 14 characters long. DISCLAIMER: I didn't figure this all out on my own. There was a great DB links user presentation at PTC Global a few years ago that devulged this information. If I can find the presentation, I'll give credit to the presenter.
UNIQUESEQUENCENNUMBER = 47772
Converted to hex: BA9C
Prefilled with 0's: 0000000000BA9C
So, you would look in the vault for the file: 0000000000BA9C
I made an app that I use to go from the vault file to the Windchill object, and the query looks like this:
FROM HolderToContent h, ApplicationData a, FvItem f
WHERE (f.uniqueSequenceNumber = 47772)
AND (f.idA2A2 = a.IDA3A5)
AND (a.idA2A2 = h.idA3B5)
I take the vault file name as input and convert it to decimal which then goes in the WHERE clause (f.uniqueSequenceNumber = <decimalValuefromHex>)
That should give you a pretty good start. We don't allows users to access files without using the UI, but I do understand your requirement You could also use the Windchill APIs to traverse all the objects/links.
Hope this helps.
I've been trying to find it, however I'm not sure that he actually had any slides. He was mostly just writing queries and showing related objects in the Windchill UI.
Thanks for the reply and information. I will run some tests on our data and see if I can pull this together. Having the presenter name, David Graham, will be useful.