Rlabkey (version 2.1.121)

getLookups: Get related data fields that are available to include in a query on a given query object

Description

Retrieve a related query object referenced by a lookup column in the current query

Usage

getLookups(session, lookupField)

Arguments

session

the session key returned from getSession

lookupField

an object representing a lookup field on LabKey Server, a named member of a query object.

Value

• A query object representing the related data set. The fields of a lookup query object are usually added to the colSelect parameter in getRows, If a lookup query object is used as the query parameter in getRows, the call will return all of the base query columns and all of the lookup query columns. A lookup query object is very similar to base query objects that are named elemenets of a schema object, A lookup query object, however, does not have a parent schema object, it is only returned by getLookups. Also, the field names in a lookup query object are compound names relative to the base query object used in getLookups.

Details

Lookup fields in LabKey Server are the equivalent of declared foreign keys

References

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

See Also

getSession, getRows getSchema

Examples

##  get fields from lookup tables and add to query

# library(Rlabkey)
s<- getSession(baseUrl="http://localhost:8080/labkey", folderPath="/apisamples")
 
scobj <- getSchema(s, "lists")

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

lucols2 <- getLookups(s, lucols[["Category/Group"]])  # keep going to other tables

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

getRows(s, scobj$AllTypes, colSelect=paste(cols, sep=","))