Skip to main content
Get Started
Documentation

Custom Filters

Within the dashboards you can create and manage custom filters

Filters opens the Filter menu.
step-0.png

Click + to create a new Filter

step-1.png

The Edit Filter modal opens

Create the Filter. The Filter Name is used to identify the Filter within the query. Add the values and Save.
step-2.png
The names are used to identify the value from the dashboard interface.
step-3.png
When writing the query in SQL, you would use User against the column you want to filter. MySQL example:
select *
from payments
where [customer_id=User]
select *
from payments
where [customer_id=User]
This query would generate the following when John A. is selected:
select *
from payments
where customer_id in (1241)
select *
from payments
where customer_id in (1241)

When choosing multiple custom filters

step-4.png
The generated query would be:
select *
from payments
where customer_id in (1241, 9321)
select *
from payments
where customer_id in (1241, 9321)
Using Mongo driver, would be a query like:
{
  "find": "payments",
  "filter": {
    "customer_id": "[User]"
  }
}
{
  "find": "payments",
  "filter": {
    "customer_id": "[User]"
  }
}
This would generate a query like:
{ 
	"count": "payments",
	"query": { 
		"customer_id": { 
			"$in": [ 1241, 9321 ] 
		}
	}
}
{ 
	"count": "payments",
	"query": { 
		"customer_id": { 
			"$in": [ 1241, 9321 ] 
		}
	}
}