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 !!!
Upcoming October 2019 Regional User Groups