RetroSearch Browse

Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from http://cran.rstudio.com/web/packages/rlang/../ODataQuery/vignettes/querying.html below:

Querying

There are three ways to query data using this package.

Directly write OData query

The most direct way is to directly write your query in OData.

Fast
Can express any query
You need to sanitize your inputs
Can be hard to read if mixing with user code

people_entity$filter("Concurrency gt 500")
#> ODataQuery: https://services.odata.org/V4/TripPinServiceRW/People?$filter=(Concurrency%20gt%20500)
people_entity$filter("Friends/any(f: f/FirstName eq 'John')")
#> ODataQuery: https://services.odata.org/V4/TripPinServiceRW/People?$filter=(Friends/any(f:%20f/FirstName%20eq%20'John'))

Using and_query, or_query and not_query

Automatically sanitized
Easy to read
Not every query can be written this way

people_entity$filter(Concurrency.gt = 500)
#> ODataQuery: https://services.odata.org/V4/TripPinServiceRW/People?$filter=(Concurrency%20gt%20500)
people_entity$filter(or_query(Concurrency.lt = 500, Concurrency.gt = 1500))
#> ODataQuery: https://services.odata.org/V4/TripPinServiceRW/People?$filter=((Concurrency%20lt%20500%20or%20Concurrency%20gt%201500))

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4