# Cannot get .eq to work with Query

**URL:** <https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057>\
**Category:** Ask the community\
**Tags:** code, wix-stores, question\
**Created:** [October 12, 2022, 7:39pm UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057 "2022-10-12T19:39:17Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![mail12161](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mail12161](https://forum.wixstudio.com/u/mail12161)\
**Post date:** [October 12, 2022, 7:39pm UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057/1 "2022-10-12T19:39:17Z")

</div>

This code works ok

```javascript
  let results = await wixData.query('Stores/Orders')
	  .descending('_dateCreated')
      .limit(100)
      .find(options);

```

```
But this does not when I add .eq to filter the results?!

```

```javascript
  let results = await wixData.query('Stores/Orders')
	  .eq("currency", "GBP")
	  .descending('_dateCreated')
      .limit(100)
      .find(options);

```

Error in logs is:

“[“WDE0076: Validation error. {"message":"Unknown token currency → Map($eq → GBP)","details":{}}”]”

```
I am baffled for many hours... I am sure there is a simple solution ...any ideas ? I have tried .eq with lots of fields but nothing works when I try and filter the Orders.

```

---

<div class="post-metadata">

**Author:** ![J.D](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/j.d/32/7312_2.png) [@J.D](https://forum.wixstudio.com/u/J.D)\
**Post date:** [October 12, 2022, 8:19pm UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057/2 "2022-10-12T20:19:54Z")

</div>

[wrong direction - deleted]

---

<div class="post-metadata">

**Author:** ![mail12161](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mail12161](https://forum.wixstudio.com/u/mail12161)\
**Post date:** [October 13, 2022, 9:13am UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057/3 "2022-10-13T09:13:47Z")

</div>

J.D. thank you as always but that did not work. Strangely this does work:

```javascript
  let results = await wixData.query('Stores/Orders')
	.eq("paymentStatus", "PAID")
	  .descending('_dateCreated')
      .limit(100)
      .find(options);

```

However I do not know how to get .eq to work with a field which contains JSON object e.g. to look up Orders by customer email which is a field within the buyerInfo JSON object. This does not work. Any ideas please?

```javascript
  let results = await wixData.query('Stores/Orders')
	.eq("buyerInfo.email", email)
	  .descending('_dateCreated')
      .limit(100)
      .find(options);

```

---

<div class="post-metadata">

**Author:** ![mail12161](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mail12161](https://forum.wixstudio.com/u/mail12161)\
**Post date:** [October 13, 2022, 9:16am UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057/4 "2022-10-13T09:16:06Z")

</div>

“[“WDE0076: Validation error. {"message":"Unknown token buyerInfo.email → Map($eq → email)","details":{}}”]”

---

<div class="post-metadata">

**Author:** ![mail12161](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@mail12161](https://forum.wixstudio.com/u/mail12161)\
**Post date:** [October 13, 2022, 1:01pm UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057/5 "2022-10-13T13:01:26Z")

</div>

I suspect that it is only possible to filter queries on certain fields? But this would mean searching the whole collection of orders (may be thousands) to possibly just inspect 2 orders a customer has placed (identified by their unique email) which means slower searching? At the moment i search all orders and then use an if statement on the result items to find the matching email field but that seems a long way? Filtering in the initial query would be faster better?? Thank you in advance.

---

<div class="post-metadata">

**Author:** ![J.D](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/j.d/32/7312_2.png) [@J.D](https://forum.wixstudio.com/u/J.D)\
**Post date:** [October 13, 2022, 4:27pm UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057/6 "2022-10-13T16:27:45Z")

</div>

Hi, since I don’t usually use the Wix Stores app (I use a third party’s transactions/orders), I wouldn’t like to mislead you with my answer.  
On first glance the query looks fine to me. Maybe post a sample of your order item.  
And maybe someone else will be able to help.

---

<div class="post-metadata">

**Author:** ![ahmad23688](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/ahmad23688/32/11607_2.png) [@ahmad23688](https://forum.wixstudio.com/u/ahmad23688)\
**Post date:** [September 13, 2023, 4:46pm UTC](https://forum.wixstudio.com/t/cannot-get-eq-to-work-with-query/34057/7 "2023-09-13T16:46:35Z")

</div>

Even though the documentation says that you can filter using contains on plainContent (["Posts" Collection Fields - Velo API Reference - Wix.com](https://www.wix.com/velo/reference/wix-forum-backend/%22posts%22-collection-fields?_gl=1*17dje8x*_ga*NDI1ODI1MjcuMTY3MzQ0MTQ3OA)…)

I got this error:  
Error: WDE0076: Validation error. Unsupported filter operator $contains for plainContent