Cross-Folder Queries

You can perform cross-folder queries by identifying the folder that contains the data of interest during specification of the dataset. The path of the dataset is composed of the following components, strung together with a period between each item:

• Project - This is literally the word Project, which resolves to the current folder's project.
• Path to the folder containing the dataset, surrounded by quotes. This path is relative to the home folder. So a dataset located in the Home->Study->demo subfolder would be referenced using "Study/demo/".
• Schema name - In the example below, this is study
• Dataset name - Surrounded by quotes if there are spaces in the name. In the example below, this is "Physical Exam"

The "Physical Exam" dataset shown in the Use the Source Editor topic can be referenced from a query in a nearby folder. To do so, you would replace the string used to identify the dataset ("Physical Exam" in the query used in this topic) with a fully-specified path. For this dataset, you would use:

Project."Study/demo/".study."Physical Exam"

Cross-Project Queries

You can perform cross-project queries using the full path for the project and folders that contain the dataset of interest. To indicate that a query is going across projects, use a full path, starting with a slash. The syntax is “/<FULL FOLDER PATH>”.<SCHEMA>.<QUERY>

• Full path to the folder containing the dataset, surrounded by quotes. This lets you access an arbitrary folder, not just a folder in the current project. So a dataset located in the Home->Study->demo subfolder would be referenced using "/Home/Study/demo/".
• Schema name - In the example below, this is study
• Dataset name - Surrounded by quotes if there are spaces in the name. In the example below, this is "Physical Exam"

The example shown above for cross-folder queries can be rewritten using cross-project syntax by including the entire path to the folder of interest, preceded by a slash.

“/Home/Study/demo”.study."Physical Exam"