Page Comparison

...

You can create a View that contains Files, Tables, Projects, or Submissions. A File View lists all Files or Tables within one or more Folders or Projects. A Project View lists all Projects you’ve added to the view. A Submission View lists all Submissions within one or multiple Evaluation Queues.

Creating Views

You can create Views from the web client to organize and group content within Synapse. Instructions for creating Views using the clients can be found in the Python docs and in the R docs.

Create a File View

To create a File View, select the Project in which where you would like to create the View. The Project you choose does not have to contain the items you are including in your View. Navigate to the Tables tab and select Add File View in the Tables Tools menu. You will select the files of interest by defining the scope, which is the Project(s) and Folders that contain your files. File Views can also contain Tables or Folders; you can choose which kinds of items you would like to include during this process.

...

The scope of a File View can have a maximum of 20,000 folders or sub-folders.

Create a Project View

To create a Project View, select the Project in which you would like to create the view. You will select the projects of interest by defining the scope as above. The only notable difference between creating a Project View and a File View is that for project views, there is a 1:1 relationship between the projects you select in your scope and the projects that are shown in the view. The scope of a Project View can have a maximum of 20,000 Projects.

Create a Submission View

To create a Submission View, select the Project in which you would like to create the view. The Project you choose does not have to contain the submissions or the evaluation queues that are included in the view. Navigate to the Tables tab and select Add Submission View in the Tables Tools menu. The submissions that are included in the View are defined by its scope, which is the list of Evaluation Queues containing the submissions. For more information, read about how to use Submission Views with Evaluation Queues. InfoNote: The The scope of a View can have a maximum of 20,000 evaluation queues.Instructions for creating Views using the clients can be found in the Python docs and in the R docs.

Updating the Scope or Content of a View

Views can be edited to change the scope or what types of content are displayed. Navigate to the View and then select Show Scope of View in the Tools menu. Click Edit Scope to view and change your View preferences. Note that it Once you click Save, Synapse may take a few moments for to rebuild the updated View to rebuild.

Query a View

A view can be queried like any other Table in Synapse. See Tables for more examples.

...

Views are in Simple Search mode by default. You can filter out for Projects or Files of interest by using the facet menu on the left. You can toggle between simple and advanced search using the Show advanced search/Show simple search link.

...

synapse query 'SELECT * FROM syn12345678'

Python

query = syn.tableQuery('SELECT * FROM syn12345678')

R

query <- synTableQuery('SELECT * FROM syn12345678')

...

Navigate to a Wiki and click the Wiki Tools menu. Select Edit Project Wiki. In the Wiki editing window, select the Insert tab and then Table: Query on a Synapse Table/View. To embed the entire View into the Wiki enter “SELECT SELECT * FROM syn12345678” syn12345678 in the resulting pop-up window.

To embed a subset of the file viewFile View, like the advanced search query in the previous example, enter SELECT * FROM syn12345678 WHERE Cell_Type = ‘PSC’.

...