Filter any backend and Object data

Updated 2 weeks ago by Mobsted Support L

Process and filter data, stored on the platform, to make it available anywhere via hashtags mechanism.

_______________

FILTERS' USAGE

Data sets that can be filtered

How to refer to filtered results

Where Filtered data can be referenced

Find filters in ConstructorBackend or ConstructorObjects:

How Filters are displayed in Mobsted PWA multichannel platform from the Events tab

______________

CREATE FILTER
  1. Go to Filters: Backend or ConstructorObjects
  2. Create new Filter: click ADD FILTER in the top left corner, then click Create New Filter.
Example of the creation of the Filter on Mobsted PWA platform

________________________

SET FILTERS' CONDITIONS
  1. Select the value to be compared. Possible options:
    • Action name of the Event
    • Key of the Event
    • Object property, such as: Phone, Email, Login date.
  2. Select the comparison criteria. Possible options:
    • Equal ( = ) - strict match.
    • Not equal ( <> )
    • Contains
    • Doesn't contain
    • Is Set - checks if the field specified is NOT empty
    • Is Not Set - checks if the field specified is empty
  3. Select the comparison value. Possible options:
    • String from the dropdown
    • Any text typed in manually
The view of the condition filter set up on Mobsted Multichannel PWA platform

____________________________

CREATE EVENT/OBJECT FILTER

Each Filter works with Events and Objects simultaneously. For example: if the filter counts how many clicks were made on the particular button in Events, the same filter will show how many people clicked the button in Objects section.

  1. Set up for Object filter that calculates the average age of people with mobsted.com email:
    The view of the filter set up on Mobsted Multichannel PWA platform

  1. Set up for Event filter that calculates the number of clicks on the button with the BackendName "updatePhone" within last 7 days:
    Example of the Filter set up for the Events within Mobsted PWA multichannel platform

MERGE TWO FILTERS

Filter can contain either AND or OR condition. In order to have OR + AND conditions use hashtags within new filter.

For example: we want to create the filter that will display everyone with email on Mobsted OR Outlook domain, and who has US phone number.

Venn diagram demonstrating the logic of the filter on Mobsted PWA platform

  1. First filter will contain the required Email condition, we will name it as Email.
    Simple filter created on Mobsted PWA platoform

  1. Second filter will contain the required Phone condition merged (AND operator) with the Email filter above.
    Filter with nested Filter in it created on Mobsted PWA platform

___________________________

USE AGGREGATE FUNCTIONS

Aggregation methods applicable for filter:

  • SUM
  • AVG
  • MIN
  • MAX
  • COUNT

Example of using aggregation on Mobsted multichannel PWA making platform

____________________

USE PERIOD SETTING

Set up a time period the filter will be applied on. Time period can be fixed between dates specified, or dynamic - older than 2 days / younger than 3 weeks. Can be used with OR or AND conditions, but not combined.

The example of setting up fixed on dynamic time period in Filters on Mobsted multichannel PWA making platform

_____________________________

PREVIEW YOUR FILTER RESULTS

Click on the filter to see all the data applicable to it. To see all the data click again on the filter to unselect it.

Example of how to preview Filter results in Filters on Mobsted multichannel PWA making platform

____________________________________________________

SHOW / HIDE THE SAME FILTER FROM OBJECTS / EVENTS

To hide / show the same filter in Objects and Backend section click ADD FILTER and select checkbox for the corresponding column.

Demonstrares how to hide and show filters for Events and Objects on Mobsted multichannel PWA platform

____________________________________

SHOW FILTER RESULTS ON APP SCREEN

It is possible to display filter results to app user by using Hashtags.

  1. Showing filter counts:
    We use Hashtags to refer to Object's filer "Age" and show the Count of fitting records.
    #ObjectsFilter:Age:Count#.

Note: for more detailed information on the set up, please, check Use automatic data filters article. You can also check how it is set up in Demo App in your acсount, screen - 8 Filters Count.

  1. Iterating through filter records:
    We use Hashtags functionality combined with loops to go through each record. How to set it up:
    1. Enable loop on the element you want to iterate
    2. Use your filter data as data source. In our case it is #ObjectsFilter:AgeEmail:Data#
    3. Name the loop. In our case it is AgeEmailLoop
    4. Reference the loop and call the properties of the Object that you want to display, in our case it is Name ( #Loop:AgeEmailLoop:objects@Name# ) and Age ( #Loop:AgeEmailLoop:objects@Age#).
      Mobile View:

Note: for more detailed information on the set up, please, check Apply loops to screen elements article. You can also check how it is set up in Demo App in your account, screen - 9 Filters Iterate.

MENTIONED ARTICLES


Was it useful?