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
Copy link