# Filtering and Searching

Above each column of the table there is a filter and search control. The display of data in the table is adjusted according to the set filters.

The display of numeric values can be limited to a maximum and a minimum value (two fields are available), while only one field is available for searching text values.

<figure><img src="https://content.gitbook.com/content/yVpJJpVl37JA6NYorbNR/blobs/AtA5lOhxhJT4Bz9p391M/obrazek.png" alt=""><figcaption><p>Filtering numbers</p></figcaption></figure>

The filtering can be started by pressing Enter or automatically after a set delay. This delay can be controlled in the configuration INI file by setting the variable *`ApplyFilterDelay`*.

{% hint style="info" %}
Filter "reset" can be done by emptying all hotnot filters + confirming with Enter key.
{% endhint %}

## Default filtering

The configuration can be set so that the data table is filtered by the column and value in the configuration at startup. These are the parameters *`InitiateFilterDbFieldName`* and *`InitiateFilterValue`*.

## Examples of filtering and searching

The images below contain examples of filtering numeric and text values.

<figure><img src="https://content.gitbook.com/content/yVpJJpVl37JA6NYorbNR/blobs/tL42D2WzgfdaqwzOv4KS/image.png" alt=""><figcaption><p>Unfiltered data table</p></figcaption></figure>

### Numerical values

<figure><img src="https://content.gitbook.com/content/yVpJJpVl37JA6NYorbNR/blobs/zL1uJo4MRzqT4KONUpEK/image.png" alt=""><figcaption><p>Display values in column Count =&#x3C; 4</p></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/yVpJJpVl37JA6NYorbNR/blobs/UIMY1JaQmfHLtMKWYQ8Q/image.png" alt=""><figcaption><p>Display values in column Count >= 10</p></figcaption></figure>

### Text values

<figure><img src="https://content.gitbook.com/content/yVpJJpVl37JA6NYorbNR/blobs/DUhCeYPGSitOUemOAzEY/image.png" alt=""><figcaption><p>Display of all sheets with a thickness of 0.8 mm</p></figcaption></figure>

## Other settings

Other settings for filtering are described in chapter[section-settings](https://help.holixa.com/holixa-erp-picker/common-information/application-configuration/configuration-file-parameters/section-settings "mention").