query: Makes a query

Description Usage Arguments Value Examples

Description

Executes a query on the server backend and returns data.

Usage

1
2
query(resource, limit = -1, skip = 0, conditions = NULL, sort,
  selectFields, distinct)

Arguments

resource

The resource to query.

limit

Limit the number of data rows to retrieve. If no specified, no limit applies.

skip

Skip the first N data rows to retrieve. If no specified, no skip=0 is assumed.

conditions

A set of conditions to constraint the query on the server side. Use the function buildCondition() to create the conditions.0

sort

Criteria to sort the data returned. (Not yet implemented)

selectFields

Select and filter the fields to retrieve (columns). (Not yet implemented)

distinct

Provides a distict criteria. (Not yet implemented)

Value

Returns a dataframe with the returned data.

Examples

1
2
3
4
5
6
7
cnx <- connect("http://jacaton-r.herokuapp.com", "demo", "1234") 
off <- resource(cnx, "oficinas") 

query(off)
query(off, conditions=buildCondition("nombre", "==", "Seville")  )
query(off, limit=2, skip=0)
query(off, limit=2, skip=2)

SevillaR/HivepodR documentation built on May 9, 2019, 1:23 p.m.