Operators

This entry provides detailed information on the API filter operators.

Contents of the Table

The following filter operators can be used to limit the data output.

Function	SQL Operator	API Operator	Example
Includes	IN	include	{"dimension":"flx_pixel_id","include":["1234","5678"]}
Excludes	NOT IN	exclude	{"dimension":"flx_pixel_id","exclude":["1234","5678"]}
Contains	LIKE	contains	{"dimension":"flx_site_domain","contains":["test"]}
Does Not Contain	NOT LIKE	doesNotContain	{"dimension":"flx_site_domain","doesNotcontain":["test"]}

Measures

Function	SQL Operator	API Operator	Example
Less Than	<=	max	{"measure":"flx_total_events","max":"100"}
More Than	>=	min	{"measure":"flx_total_events","min":"1000"}