Hello all,
I currently have a query created from views I made that is grabbing all the files from our PDM. I have a program I created that copies/caches these files to a local server and it creates a table of whats been cached. The 2 tables are compared to determine which files need to be cached/updated.
Now it seems that files that are
Here is my current query and I just need to add the state/status part to this query. I saw in the ‘Status’ table ID 27 the name is Vaulted. I’m not sure if that’s what I’m looking for I don’t see any name with private state anywhere.
SELECT d.Filename, r.RevNr, r.Date AS ModifiedDate, r.FileDate AS CreatedDate, p.Name, p.Path, r.FileSize, r.Root, d.DocumentID, p.ProjectID
FROM dbo.Documents AS d INNER JOIN
dbo.view_Revisions_MostRecentRevNr_withAddInfo AS r ON d.DocumentID = r.DocumentID INNER JOIN
dbo.DocumentsInProjects AS dp ON d.DocumentID = dp.DocumentID INNER JOIN
dbo.Projects AS p ON dp.ProjectID = p.ProjectID
WHERE (d.Filename LIKE '%pdf') AND (d.Deleted = 'False')
ORDER BY d.Filename, 'ModifiedDate'