Page History

...

Filters are used to process and filter data, stored on the platform, to make it available anywhere via hashtags mechanism. It is a visual way to create SQL requests to data stored on the platform. 

There is also an ADVANCED USERS way to create filters dynamically and change data to be pulled on a fly from a UI. 

FILTERS' USAGE

...

This is how a set of Filters can look in you app:

Image Added

You can create Filters in APP DATA section for both Objects and Events (RED MARKORANGE MARK) , Add New Filter Filter (ORANGE MARKRED MARK).

Image Added

Image RemovedImage Added

You can make VISIBLE/INVISIBLE or HIDE/SHOW needed filters in your admin panels .↑

Image Removed

Each Filter shows:

1. Aggregate function chosen - SUM, AVG, MIN, MAX, COUNT
2. Number of records fitting the conditions
3. When it was last time refreshed

...

Create and Name a new Filter. Naing is very important, as you will refer to it's data using Hashtags:

Image RemovedImage Added

Set up Events/Objects Filter's Conditions:

Image RemovedImage Added

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

...

You need to use this hashtag to render filter's results in server side and pull it into second filter's conditions - #ServerSide:ObjectsFilter:NAME:Data@JoinData@join(",", "objects@id")#

 Where two variable are:  NAME - is how you call the FIRST filter,  ID is a common field used to JOIN "join" the results with.

NOTE - There is also a way to create filters dynamically and change data to be pulled on a fly from a UI that has ability to also combine AND/OR requests for data. It is recommended for advanced Mobsted users only. 

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.

PREVIEW YOUR FILTER RESULTS

...

This functionality is not yet available in a visual interface, like with Objects and visually shown (like in Objects/Events. However it is fully 100% up and running on a backend of Mobsted. Write to [email protected] and we will create any number of Filters needed for you - it is free of charge. 

...