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