> For the complete documentation index, see [llms.txt](https://help.auxalia.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://help.auxalia.com/plant-tools/plantreporter/how-to-use/plantreporter/common-tasks/filtering.md).

# Filtering

This chapter describes how you filter the data of a report.

Filter the data in the Report Designer. There you can combine conditions with "And", "Or" and "Not". You can filter on every property of the query, even if it is not shown in the report.

### <mark style="color:blue;">Open the FilterString Editor</mark>

Open the Report Designer with **Edit report layout...**. After opening, the report itself is selected. In the **Properties** panel switch to the **Data** tab and click on **...** at **Filter String**.

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-b1d1687b6551d19f0b2ee0d50e9591b610e63edd%2FPR-Filtering-001.png?alt=media)

Alternatively you click on the little box at the upper left hand corner of the layout and then on **...** under **Filter String**.

### <mark style="color:blue;">Add Conditions</mark>

The FilterString Editor opens. When you move your mouse pointer to the right of **And**, a + sign appears. Click on it and select **Add Condition**. Then select the property, the operator and the value.

If you click on **And**, you can change it to **Or**, **Not And** or **Not Or**. At the bottom of the dialog you see the condition as text. You can also edit the condition there.

In this example the report shows only the valves with the spec CS150 or with the size 80:

```
[Inline Assets_Spec] = 'CS150' Or [Inline Assets_Size] = '80'
```

![](https://2994090777-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FZH2AGHzvPfBW7YdaaGc0%2Fuploads%2Fgit-blob-5d5ec5715dbe2c8f2a090561f2d976e2c8848ba7%2FPR-Filtering-002.png?alt=media)

A step by step example with **Not And** is described under [Create Version/Revision History](/plant-tools/plantreporter/how-to-use/plantreporter/use-cases/create-versionrevision-history.md).

Remark: Use the filter of the Report Designer and not the **Filter** column in the query of the report configuration.