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
(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.