New Report showing all documents with a specific folder category

Firaz_Alyas

Hi,

 

I'm new here and would appreciate some help, I have tried looking for something similair to what I require but havent had much luck, hopefully someone here can help:-

 

Results:- im trying to find all documents including file paths:-

which have category contents  matching column 1 of a speadsheet (or if that is too complex then whatever would be easier)

Thanks,

Fraz

 

Appu_Nair

If this is related to livelink then a livelink path of

Enterprise:My Folder:My document or something to the tune of

\\myexternalfilestore\000\1234\5678\12345.dat

In livelink all documents have the subtype of 144

so select * from dtree where subtype=144 (all documents)

if you want to see where all of them live

select * from providerdata where providerid in
(select providerid from dversdata where docid in(select dataid from dtree where subtype=144))