# How to filter by empty reference field?

**URL:** <https://forum.wixstudio.com/t/how-to-filter-by-empty-reference-field/28066>\
**Category:** Ask the community\
**Tags:** question, code\
**Created:** [July 16, 2020, 7:45pm UTC](https://forum.wixstudio.com/t/how-to-filter-by-empty-reference-field/28066 "2020-07-16T19:45:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrpowergage](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/mrpowergage/32/18397_2.png) [@mrpowergage](https://forum.wixstudio.com/u/mrpowergage)\
**Post date:** [July 16, 2020, 7:45pm UTC](https://forum.wixstudio.com/t/how-to-filter-by-empty-reference-field/28066/1 "2020-07-16T19:45:49Z")

</div>

Can you help? I’m trying to filter a dataset and only show items that have the empty reference field “Card”. I would have thought this would have done it, but it doesn’t, I get an uncaught promise.

```javascript
    $w('#dataset4Quotes').setFilter(wixData.filter()
        .hasSome("keywords", selectedQuoteKeywords)
        .isEmpty("Card")
        )

```

I tried adding in .include(“Card”) that didn’t work.

I’ve looked at the API for query and queryreferenced, and searched the forum but can’t see the solution I’m looking for.

Any help would be appreciated.

Thanks

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [July 16, 2020, 8:03pm UTC](https://forum.wixstudio.com/t/how-to-filter-by-empty-reference-field/28066/2 "2020-07-16T20:03:36Z")

</div>

Hello mrpowergage,

perhaps this works for you…

```javascript
import wixData from 'wix-data';

$w('#dataset4Quotes').setFilter( wixData.filter()
  .hasSome("keywords", selectedQuoteKeywords)
  .isEmpty("Card")
)
.then( () => {
  console.log("Dataset is now filtered");
  
} )
.catch( (err) => {
  console.log(err);
} );

```

Not tested!

---

<div class="post-metadata">

**Author:** ![mrpowergage](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/mrpowergage/32/18397_2.png) [@mrpowergage](https://forum.wixstudio.com/u/mrpowergage)\
**Post date:** [July 16, 2020, 8:12pm UTC](https://forum.wixstudio.com/t/how-to-filter-by-empty-reference-field/28066/3 "2020-07-16T20:12:20Z")

</div>

Thanks russian-dima,

It isn’t throwing an error anymore, but it’s not providing the results as expected either.

FYI if I remove .isEmpty( “Card” ) it works as expected

---

<div class="post-metadata">

**Author:** ![CODE-NINJA](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/code-ninja/32/110588_2.png) [@CODE-NINJA](https://forum.wixstudio.com/u/CODE-NINJA)\
**Post date:** [July 16, 2020, 8:32pm UTC](https://forum.wixstudio.com/t/how-to-filter-by-empty-reference-field/28066/4 "2020-07-16T20:32:06Z")

</div>

try this one, instead of —\> .isEmpty. Perhaps this works.

```javascript
.eq("Card", "")

```

---

<div class="post-metadata">

**Author:** ![miguelhongo90](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/miguelhongo90/32/20930_2.png) [@miguelhongo90](https://forum.wixstudio.com/u/miguelhongo90)\
**Post date:** [July 31, 2020, 11:20am UTC](https://forum.wixstudio.com/t/how-to-filter-by-empty-reference-field/28066/5 "2020-07-31T11:20:02Z")

</div>

not working…
