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