Url Filtering Syntax

Url Filtering is a way of joining multiple filters in a Url request so that Xenioo Database API Interface can dynamically extract or delete documents from a given collection.

An Url filter is always composed by a field name, a comparison criteria, a value and, if necessary, a logical operator. As a general example, the following string represents a filter searching for all products with discount greater than 10:

discount[GRT]10

Using logical operators, multiple filters can be applied in both OR and AND. The following filter example will affect all documents with discount greater than 10 and product_code starting with TEST:

discount[GRT]10[AND]product_code[STA]TEST

The following table contains the full list of all the applicable criteria:

Criteria	Filter
[EQL]	Equal To
[NEQ]	Not Equal To
[GRT]	Greater Than
[GRE]	Greater or Equal To
[LET]	Lesser Than
[LEE]	Lesser or Equal To
[ISN]	Is Null
[HSV]	Has a value
[CON]	Contains
[NCO]	Does Not Contain
[STA]	Starts With
[NST]	Does Not Start With
[ENW]	Ends With
[NEW]	Does Not End With