• Sign In
  1. Messages

Cross-Folder query problem in 12.2

LabKey Support Forum (Inactive)

View Message

view list print
Cross-Folder query problem in 12.2 slangley  2012-10-01 18:30
Status: Closed
 
According to the docs:

   https://www.labkey.org/wiki/home/Documentation/page.view?name=crossFolderQueries

This user-defined query that references a query or list defined in another folder should work:

  SELECT * FROM Project."HVTN Publications and Analyses/_data/".lists."Publications"

but instead it gives:

  Error on line 1:Table Project.HVTN Publications and Analyses/_data/.lists.Publications not found.
    Can't resolve column: Publications."*"

likewise, this query executed on the '_data' folder, itself, fails:

  SELECT Publications.pub_category FROM Project."HVTN Publications and Analyses/_data/".lists."Publications"

with:

  Error on line 1:Table Project.HVTN Publications and Analyses/_data/.lists.Publications not found.

Is this problem something that will be fixed when we apply this fix?

  https://www.labkey.org/issues/home/Developer/issues/details.view?issueId=15772

Thanks.

Scott
 
 
Matthew Bellew responded:  2012-10-01 23:09
I don't think that bug is related. I tried to make a simple repro, but didn't succeed. Can you send me a link that demonstrates this problem?
 
cnathe responded:  2012-10-02 05:32
Scott,
If you are making the query call from somewhere within the "HVTN Publications and Analyses" project, then the work Project, that starts the path to the query/table, takes the place of the actual project name that you are in. So I think you want something like this:

SELECT * FROM Project."_data/".lists."Publications"
SELECT Publications.pub_category FROM Project."_data/".lists."Publications"

-Cory
 
slangley responded:  2012-10-02 10:52
Thanks Cory. Yes, that works.

Scott