Rlabkey (version 2.1.121)

getSchema: Returns an object representing a Labkey schema

Description

Creates and returns an object representing a Labkey schema, containing child objects representing Labkey queries

Usage

getSchema(session, schemaIndex)

Arguments

session

the session key returned from getSession

schemaIndex

the name of the schema that contains the table on which you want to base a query, or the number of that schema as displayed by print(session)

Value

• an object representing the schema. The named elements of a schema are the queries within that schema.

Details

Creates and returns an object representing a Labkey schema, containing child objects representing Labkey queries. This compound object is created by calling labkey.getQueries on the requested schema and labkey.getQueryDetails on each returned query. The information returned in the schema objects is essentially the same as the schema and query objects shown in the Schema Browser on LabKey Server.

References

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

See Also

getSession

Examples

## the basics of using session, schema, and query objects

# library(Rlabkey)

s<- getSession(baseUrl="http://localhost:8080/labkey", folderPath="/apisamples")

sch<- getSchema(s, "lists")

sch$AllTypes$Category          # can walk down the populataed schema tree from schema node or query node
sch$AllTypes$Category$caption
sch$AllTypes$Category$type

lucols <- getLookups(s, sch$AllTypes$Category)  # can add fields from related queries

cols <- c(names(sch$AllTypes[2:6]), names(lucols)[2:4])

getRows(s, sch$AllTypes, colSelect=cols)