AnsweredAssumed Answered

Creating a SQL List of all files in a folder that are in a specific state

Question asked by Tara Campese on Mar 8, 2016
Latest reply on Mar 10, 2016 by Tara Campese

I am trying to create a SQL List to populate a drop down list on a datacard. I need the SQL list to be populated with all files in a specific folder that are in a specified state. I know how to generate a SQL List for all sub-folders in a specific folder, but I have been unable to modify the script to find files and I am at a complete loss for how to filter by state.


Here is the script for the sub-folders list:

Select Distinct P.Name

  From Projects As P,ProjectTree As PT

    Where P.ProjectID=

    (Select PT.ChildProject where PT.ProjectID=

      (Select distinct ProjectID from dbo.Projects where Name like 'Corrective Action Reports'




Also, I can run a SQL-Query (attached) to get the information I need, but when I cut and paste the Query into the SQL List, I get an error (see attached screen shot).


Any help would be appreciated.


Thank you,