# Filter für CustomFields?

**URL:** <https://forum.shopware.com/t/filter-fur-customfields/61794>\
**Category:** Programmierung\
**Created:** [16. September 2019 um 13:35 UTC](https://forum.shopware.com/t/filter-fur-customfields/61794 "2019-09-16T13:35:16Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Moorleiche](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@Moorleiche](https://forum.shopware.com/u/Moorleiche)\
**Post date:** [16. September 2019 um 13:35 UTC](https://forum.shopware.com/t/filter-fur-customfields/61794/1 "2019-09-16T13:35:16Z")

</div>

```
// Adding products to suggestions
$sql = <<>"$.moorl_suggested" IS NOT NULL;
SQL;

$productIds = $this->connection->executeQuery($sql)->fetchAll(\PDO::FETCH_COLUMN);

$criteria = new Criteria($productIds);
$criteria->addAssociation('cover');
$products = $this->productRepository->search($criteria, $event->getContext())->getElements();

```

Gibt es hierfür eine bessere Lösung?&nbsp;Finde aktuell hierzu keine passenden Filter.

---

<div class="post-metadata">

**Author:** ![Michael\_Telgmann](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/michael_telgmann/32/20289_2.png) [@Michael\_Telgmann](https://forum.shopware.com/u/Michael_Telgmann)\
**Post date:** [16. September 2019 um 14:24 UTC](https://forum.shopware.com/t/filter-fur-customfields/61794/2 "2019-09-16T14:24:21Z")

</div>

Hallo,

du kannst im DAL auch nach customFields filtern:

```
$criteria = new Criteria();
$criteria->addFilter(
    new EqualsFilter('customFields.my_custom_field', 'my value')
);

```

Wenn du einfach auf “NOT NULL” prüfen willst, geht das so:

```
new NotFilter(
    NotFilter::CONNECTION_AND,
    [
        new EqualsFilter('customFields.my_custom_field', null),
    ]
)

```

Viele Grüße aus Schöppingen

![cool](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/1X/86c57fbace799dd4eb1f1b8a2d3bdc1733f0aea1.png "cool")&nbsp;Michael Telgmann

---

<div class="post-metadata">

**Author:** ![Moorleiche](https://avatars.discourse-cdn.com/v4/letter/m/6f9a4e/32.png) [@Moorleiche](https://forum.shopware.com/u/Moorleiche)\
**Post date:** [16. September 2019 um 18:51 UTC](https://forum.shopware.com/t/filter-fur-customfields/61794/3 "2019-09-16T18:51:24Z")

</div>

[@Michael Telgmann]([http://forum.shopware.com/profile/17553/Michael](http://forum.shopware.com/profile/17553/Michael) Telgmann “Michael Telgmann”)‍

Vielen Dank für den Tipp! 🙂