issue with cross-folder query?

LabKey Support Forum (Inactive)
issue with cross-folder query? jeckels  2010-03-15 16:46
Status: Closed
 
Hi Ben,

In this case, the first identifier should be Project, not WNPRC. It resolves to the current folder's project, and is always called Project.

SELECT
e.PersonID
FROM Project."WNPRC_Units/Animal_Services/Compliance_Training/Private/EmployeeDB/".lists.Employees e

In 10.1, we introduced a new cross-project syntax that would also work for you. To use it, you'd write a query like this:

SELECT
e.PersonID
FROM "/WNPRC/WNPRC_Units/Animal_Services/Compliance_Training/Private/EmployeeDB/".lists.Employees e

Thanks,
Josh