cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL extract of files

Highlighted

SQL extract of files

Hi,

I am trying to extract physical files from Pro/Intralink 3.4 M062 directly with SQL command and have some problems with family table scheme :

For example I find 2 physical files (FID) for the same PIVID. The joins goes by PDM_LOVCONTENTS, PDM_LOVFILE and PDM_FILE.

One FID size us null and the other seems to be OK. Those two FIDs are referenced by all the menbers of the Family Table, instances and generic (this, seems normal). I joined a picture of my problem.

Does someone knows the scheme so he could explain me a little how it works ? ANY suggestion is VERY welcome !!!

Thank you

Announcements
LiveWorx Call For Papers Happening Now!