5 Replies Latest reply on Mar 10, 2016 5:06 PM by Tara Campese

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

    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,

      Tara