---
title: "Filtering rows"
manual: "Calien - XLS Exporter"
version: "5.1"
permalink: "https://docs.typo3.org/permalink/calien/xlsexport:configuration-where@5.1"
source: "Configuration/Filtering.rst"
rendered: "2026-11-19T10:49:27+00:00"
---

# Filtering rows {#configuration-where}

**Table of contents**

-   [Expression types](https://docs.typo3.org/permalink/calien/xlsexport:expression-types@5.1)
-   [Parameter types](https://docs.typo3.org/permalink/calien/xlsexport:parameter-types@5.1)

`where` is a numeric list of conditions that are combined with `AND` and passed to
`QueryBuilder::where()`. Each condition maps to one method of the
[ExpressionBuilder](https://docs.typo3.org/m/typo3/reference-coreapi/13.4/en-us/ApiOverview/Database/DoctrineDbal/QueryBuilder/Index.html#database-query-builder):

```typoscript
where {
    10 {
        fieldName = pid
        parameter = ###CURRENT_ID###
        expressionType = eq
        type = int
    }
}
```

-   **fieldName**

    -   *Type:* string
    -   *Required:* true

    The column the condition applies to.

-   **expressionType**

    -   *Type:* string
    -   *Required:* true

    The comparison operator, see [Expression types](https://docs.typo3.org/permalink/calien/xlsexport:configuration-expression-types@5.1).

-   **parameter**

    -   *Type:* string or list

    The value to compare against. A scalar for most operators, or a list for `in`. The special
    value `###CURRENT_ID###` is replaced with the uid of the page selected in the module.

-   **type**

    -   *Type:* string

    The parameter type keyword, see [Parameter types](https://docs.typo3.org/permalink/calien/xlsexport:configuration-parameter-types@5.1). Not needed for
    `isNull`/`isNotNull` or when `isColumn` is set.

-   **isColumn**

    -   *Type:* boolean

    Set to `1` to treat `parameter` as a column identifier (quoted with
    `quoteIdentifier()`) instead of a value. Use this to compare two columns, typically in a
    join condition.

## Expression types {#configuration-expression-types}

| `expressionType` | ExpressionBuilder method | Meaning |
| --- | --- | --- |
| `eq` | `eq()` | equal to |
| `neq` | `neq()` | not equal to |
| `lt` | `lt()` | less than |
| `lte` | `lte()` | less than or equal to |
| `gt` | `gt()` | greater than |
| `gte` | `gte()` | greater than or equal to |
| `in` | `in()` | value in a list (use an `int_array`/`string_array` `type`) |
| `inSet` | `inSet()` | value contained in a comma-separated column |
| `isNull` | `isNull()` | column is `NULL` |
| `isNotNull` | `isNotNull()` | column is not `NULL` |

## Parameter types {#configuration-parameter-types}

The `type` keyword selects the `\TYPO3\CMS\Core\Database\Connection` parameter type
used to bind the value:

| `type` | Connection constant |
| --- | --- |
| `int` | `Connection::PARAM_INT` |
| `string` | `Connection::PARAM_STR` |
| `bool` | `Connection::PARAM_BOOL` |
| `null` | `Connection::PARAM_NULL` |
| `lob` | `Connection::PARAM_LOB` |
| `int_array` | `Connection::PARAM_INT_ARRAY` (for `in` with integers) |
| `string_array` | `Connection::PARAM_STR_ARRAY` (for `in` with strings) |
