Welcome, Guest Login

Support Center

Define a Data Source Filter Action

Last Updated: Oct 05, 2018 10:02PM EDT

This action apply a filter to a data source.

For Live Feed this Action filters the feed based on the value passed via a Query Parameter of the feed.

For On Device SQL DB this Action defines the condition of a WHERE clause of a SQL statement.

For Live feeds, the field corresponds to a URL query parameter. Learn how to Filter data from a Cloud Collection or a Feed.

In order to use a query parameter, first you have to have set up the data source to user query parameters. Review: Using a Query Parameter in a feed

For On Device SQL DB the field is limited to one of the defined columns in the table. Learn how to Filter on Device SQL DB

How to use more than one parameter?
The data source filters accumulate until the data source refreshes. So you can call the 'Define a Data source filter' action several times with different parameters and then when the data source is refreshed ALL of those parameters will be sent to the server using a 'Refresh Data Source' action for example.

Fields

Data Source

The data source used to identify the filter to be defined. Learn how to Filter data.

Column/Parameter

The column or parameter that will be used for filtering.

For Live feeds (XML, RSS, ..), the field corresponds to a query parameter.
Tutorial to Filter data from a Feed or Cloud Collection.
To learn how to add query parameters to a feed, review: Using a Query Parameter in a feed.

For On Device SQL Databases the field is limited to one of the defined columns in the table.
Learn how to Filter on Device SQL DB

How to use more than one parameter?
The data source filters accumulate until the data source refreshes. So you can call the 'Define a Data source filter' action several times with different parameters and then when the data source is refreshed ALL of those parameters will be sent to the server using a 'Refresh Data Source' action for example.

Criteria/Value

For a Live Feed this is the value that will be used for the query parameter. For Live Feed that value is NOT in quotes
Filter data from a Feed or Cloud Collection.

For an on-device SQL database this is the completion of the WHERE clause syntax, for example ">= 23". For SQL DB that value has to be in double quotes. Filter on Device SQL DB

Live Feed versus On Device Local SQL DB syntax

Replaces All Filters on Same Column/Parameter

When checked, this filter replaces any existing filters on the same column or parameter. This option is only available for local (on-device SQL) data sources. Learn how to Filter on Device SQL DB

Help us improve! Rate this article:

Yes I found this article helpful

Ask a Question   

support@eachscape.com
http://assets3.desk.com/
false
eachscape
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete