Retrieve a list of available queries for a specified LabKey schema
Fetch a list of queries available to the current user within in a specified folder context and specified schema
labkey.getQueries(baseUrl, folderPath, schemaName)
baseUrl |
a string specifying the address of the LabKey Server, including the context root |
folderPath |
a string specifying the hierarchy of folders to the current folder (container) for the operation, starting with the project folder |
schemaName |
a string specifying the schema name in which the query object is defined |
“Query” is the LabKey term for a data container that acts like a relational table within LabKey Server. Queries include lists, assay data results, user-defined queries, built-in SQL tables in individual modules, and tables or table-like objects in external schemas, For a specific queriable object, the data that is visible depends on the current user's permissions in a given folder. Function arguments identify the location of the server and the folder path.
The available queries are returned as a three-column data frame containing one row for each field for each query in the specified schema. The three columns are
queryNamethe name of the query object, repeated once for every field defined as output of the query. fieldName the name of a query output field captionthe caption of the named field as shown in the column header of a data grid, also known as a label
Peter Hussey, peter@labkey.com
http://www.omegahat.net/RCurl/,
https://www.labkey.org/project/home/begin.view
Retrieve data: labkey.selectRows, makeFilter, labkey.executeSql
Modify data: labkey.updateRows, labkey.insertRows, labkey.importRows, labkey.deleteRows
List available data: labkey.getSchemas, labkey.getQueryViews,
labkey.getQueryDetails, labkey.getDefaultViewDetails, labkey.getLookupDetails
## List of queries in a schema # library(Rlabkey) queriesDF <- labkey.getQueries( baseUrl="https://www.labkey.org", folderPath="/home", schemaName="lists" ) queriesDF
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.