...
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
Data sets that can be filtered | How to refer to filtered results | Where to reference Filtered data |
|
...
This is how a set of Filters can look in you app:
You can create Filters in APP DATA section for both Objects and Events (RED MARKORANGE MARK) , Add New Filter Filter (ORANGE MARKRED MARK).
You can make VISIBLE/INVISIBLE or HIDE/SHOW needed filters in your admin panels .↑
Each Filter shows:
- Aggregate function chosen - SUM, AVG, MIN, MAX, COUNT
- Number of records fitting the conditions
- When it was last time refreshed
...
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
...