# 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   |