I have a rather large list of File IDs and I want to get the file name & path associated to it. Is there an easy way to do this with the report generator? My SQL skills are non-existant.
Even better would be a way to do it in a search card, but I could find a way to do that.
Thanks!
Hi Greg
Enter the IDs in Following Query and Check
--------------------------------------------------------------------------------------------------------------------------------------
select
Documents.Filename
,Project.Name AS FolderName
,Projects.Path
,Documents.DocumentID
FROM Documents INNER JOIN
DocumentsInProjects ON Documents.DocumentID = DocumentsInProjects.DocumentID INNER JOIN
Projects ON DocumentsInProjects.ProjectID = Projects.ProjectID
Where (Documents.DocumentID in (
--Enter IDs Here
'21'
,'22'
,'23'
))
------------------------------------------------------------------------------------------------------------------------
Regards
Ravi T