Filters in Connect

You can apply a static or dynamic filter to the data connected to a Connect App.

Before you begin creating a filter for your App, you will need to connect a widget in an app to a Data source, or create a Manual Data connection. Follow this link to learn about Managing your data.

‍

As an example, I have an App build that displays a menu of items and prices. I want to hide the item from the menu if the inventory count reaches zero.

In this example I will be creating a filter on the following data source.

Notice that the “Sherbet Cone” Quantity is 0.

Before applying this filter my menu will list the Sherbert Cone along with its price in a repeater widget.

Creating a Filter

Select the widget that you want to filter. Click on Filter Data listed below your data source on the properties panel on the right.

Choose a property that you want to use to filter the data.

In this example I am filtering on Quantity.

Choose an operation from the dropdown menu for how you want the filter to handle the property. You will see only the operators appropriate for the property’s data type can be chosen. In the example the data type is (Number) and the operation is (Numeric).

You can set the filter to either be applied Static or via a Query String:

Static Filter

Choosing Static will filter the data for the app, preview and published versions of the app. The only way to change the visible data is to adjust the filter from this menu or remove the filter.

Add in a value to filter then click Save Changes

You should now see the count of applied filters in the Filter Data button.

When This filter is applied it will only show items from the data source that have a quantity of more than 0. If I had an externally connected data source, when that source updates and now Vanilla cones are sold out, I would no longer see that item on the menu.

Query String

Choosing Query String allows you to dynamically adjust what data is visible in the preview and published app by adding a parameter based query to the end of the App feed url. If you want the visible data to change you can change the value in the query and see results in the app immediately.

Select the filter type.

Enter a parameter name in the Value field.

In the example below I set my parameter name as “count”.

Click Save Changes

You should now see the count of applied filters in the Filter Data button.

Query String parameters are applied to the feed (URL) of the App.

Click on the preview button in the top left corner of App Builder

If the Url in ends in html add a ? to the end of the url

http://kitchen.screenfeed.com/app/48305bkhf9qammvngwmfe1chgg.html?

If the url does not end in html add a & to the end of the url

http://kitchen.screenfeed.com/app/48305bkhf9qammvngwmfe1chgg.html

‍

Next add in your parameter name.

In my example I named my parameter count

http://kitchen.screenfeed.com/app/48305bkhf9qammvngwmfe1chgg.html?count

Now add a = and the value to the parameter.

In my example I wanted to anything greater than 0. So I will add a =0

http://kitchen.screenfeed.com/app/48305bkhf9qammvngwmfe1chgg.html?count=0

I now see any items that have a quantity greater than zero.

If I wanted to see only items with a quantity greater than 10. I would simply change the value from 0 to 10.

http://kitchen.screenfeed.com/app/48305bkhf9qammvngwmfe1chgg.html?count=10

This filter allows for more dynamic changes to your app. It could also be used to have one app serve multiple functions without having to create a second app altogether.

If you want to create a more complex filter, you can add more statements to your filter by clicking on the + And or + Or buttons. +And filters will be based on both statements in combination. Whereas +Or filters are based on either statements independently.