AnsweredAssumed Answered

SQL querry help (system rev)

Question asked by Jeremy Feist on Jul 8, 2011
Latest reply on Jul 18, 2011 by Vlad Krylov

we have a similar issue as this thread https://forum.solidworks.com/message/185296#185296.

 

Ideally, I woud want to edit the sample querry in that comes with the EPDM install "File details of all files in a project" in 2 ways;

1) make it recursively go through sub-folders.

2) have it list the system rev, along with a couple of variables for each file

 

if it can't be recursive, then I would look at the "DocumentData of selected files" querry and get it to show the system rev and other variables.

 

I have attached a crp with just those 2 querries for reference, but I have zero experience in SQL, so any and all help would be much appreciated.

 

thanks,

 

edit - I noticed that I had attached the crp before saving it - now irt only has the 2 querries I am interested in.

Attachments

Outcomes