How to filter records when loading data with Odata Web connector

[Sonja_Bauernfeind]

In case you want to querry a subset of data from your OData data source based on the position of the data (just like a "Select...From...Where" type of query in SQL), you can use $filter in the query option to do so.

Here are some examples:

Greater than: /Products?$filter=Price gt 20
Greater than or equal: /Products?$filter=Price ge 10
Not equal: /Products?$filter=Price ne 10

Here is an example how you can configure Qlik Web Connector Odata connector to query it:

Resolution:

The OData connector in Qlik Web Connectors follows the standard OData URL conventions. Depending on the OData version used in your system, you can find more details about URL conventions from OData official home page: http://www.odata.org/documentation/.

Find the URL conventions documentation, and search for Query Options $filter.

 

Environment:

Qlik Web Connectors