...
A view can be queried like any other Table in Synapse. See Search Tables for more examples.
| Info |
|---|
Note: Currently, a View is updated only after a query is run against it. If your query results appear to be stale, you will need to run your query again to see the expected updates. |
Using Simple Search
Views are in Simple Search mode by default. You can filter 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.
...
Using Advanced Search
In advanced search, you can use a SQL-like query to search for items in that view. In the example below, we’re selecting for all files that have a Cell Type of “PSC”.
...
Using Programmatic Clients
Like Tables, Views can also be queried directly from the programmatic clients. For example, to query for all contents of syn12345678:
Command Line
| Code Block |
|---|
synapse query 'SELECT * FROM syn12345678'
|
Python
| Code Block | ||
|---|---|---|
| ||
query = syn.tableQuery('SELECT * FROM syn12345678')
|
R
...
| language | r |
|---|
...
and Views for more information.
Insert a View into a Wiki
...