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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.xenioo.com/database/database-api-access/url-filtering-syntax.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
