# Members/FullData Quey Filter Issue

**URL:** <https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029>\
**Category:** Ask the community\
**Tags:** question, code, cms, wix\
**Created:** [March 8, 2024, 10:59am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029 "2024-03-08T10:59:39Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Brian\_Lewis](https://avatars.discourse-cdn.com/v4/letter/b/8e8cbc/32.png) [@Brian\_Lewis](https://forum.wixstudio.com/u/Brian_Lewis)\
**Post date:** [March 8, 2024, 10:59am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/1 "2024-03-08T10:59:39Z")

</div>

**Question:**  
I have this piece of code that runs in a backend file.

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

export async function getData() {
    try {
        const getData = await wixData.query("Members/FullData").find();
        console.log("Member's Data: ", getData);
    } catch (error) {
        console.error(error);
    }
}

```

The above code is working well but the problem started when I added a filter to it. It throws an error. “WDE0080”

```javascript
export async function getData() {
    try {
        const getData = await wixData.query("Members/FullData").eq("status", "PENDING").find();
        console.log("Member's Data: ", getData);
    } catch (error) {
        console.error(error);
    }
}

```

**Product:**  
Wix Editor

---

<div class="post-metadata">

**Author:** ![codequeen](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/codequeen/32/88960_2.png) [@codequeen](https://forum.wixstudio.com/u/codequeen)\
**Post date:** [March 8, 2024, 4:05pm UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/2 "2024-03-08T16:05:18Z")

</div>

> [@Brian\_Lewis](#):
>
> WDE0080

You can look up what that error code means via the API docs

> **[Error Codes - Velo API Reference - Wix.com](https://www.wix.com/velo/reference/wix-data/error-codes)**
>
> Wix Data Error Codes When you use the Wix Data API, you may encounter errors. This list includes the error codes and messages returned by the API and more ...

---

<div class="post-metadata">

**Author:** ![Brian\_Lewis](https://avatars.discourse-cdn.com/v4/letter/b/8e8cbc/32.png) [@Brian\_Lewis](https://forum.wixstudio.com/u/Brian_Lewis)\
**Post date:** [March 11, 2024, 8:23am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/3 "2024-03-11T08:23:45Z")

</div>

@codequeen

Thanks for your assistance. I’ve already examined it, but I couldn’t identify any issues associated with the error code. Could you please check my code to see if there’s any apparent error?

---

<div class="post-metadata">

**Author:** ![codequeen](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/codequeen/32/88960_2.png) [@codequeen](https://forum.wixstudio.com/u/codequeen)\
**Post date:** [March 11, 2024, 11:55am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/4 "2024-03-11T11:55:45Z")

</div>

Well the error says it was expecting a minimum and a maximum limit of items.

When you look at the API for FullData collection it states the limit is up to 100 and trying to query more than 100 will result in error. In other words, if you do not define the limit with a number up to 100 then it will return an error.

Also, it is good to note that the collection you are attempting to query is Read only for Admin only. This means it will only work when an Admin is logged in.

(Which sort of makes one wonder why Wix wouldnt put that line of code in their code example 👀💁🏼‍♀️ They do include in other query examples because the limit is 1000 “in those”. But anyway!)

[https://www.wix.com/velo/reference/wix-members-backend/"fulldata"-collection-fields](https://www.wix.com/velo/reference/wix-members-backend/%22fulldata%22-collection-fields)

 ![IMG_7555](https://us1.discourse-cdn.com/wix/original/3X/3/2/320232b48adb72aead7d52b5c45dedaba45048f5.jpeg)

 ![IMG_7554](https://us1.discourse-cdn.com/wix/original/3X/a/5/a5910d83d3791961960da8ee7d57960c6171ab9e.png)

---

<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:** [March 12, 2024, 12:43am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/5 "2024-03-12T00:43:23Z")

</div>

![2024-03-12 01_41_03-Error Codes - Velo API Reference - Wix.com](https://us1.discourse-cdn.com/wix/original/3X/d/1/d182bfe0166ff564ffc126dc303ca6f0e4775abf.png)  
🤔 🤔 🤔 🤔

---

<div class="post-metadata">

**Author:** ![codequeen](https://sea1.discourse-cdn.com/wix/user_avatar/forum.wixstudio.com/codequeen/32/88960_2.png) [@codequeen](https://forum.wixstudio.com/u/codequeen)\
**Post date:** [March 12, 2024, 10:07am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/6 "2024-03-12T10:07:53Z")

</div>

Oh wow! But th collection name is correct on their code! It was definitely missing the limit.

Yet I read the wrong error code!? 👩‍💻😂

---

<div class="post-metadata">

**Author:** ![Brian\_Lewis](https://avatars.discourse-cdn.com/v4/letter/b/8e8cbc/32.png) [@Brian\_Lewis](https://forum.wixstudio.com/u/Brian_Lewis)\
**Post date:** [March 13, 2024, 9:36am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/7 "2024-03-13T09:36:52Z")

</div>

I got an answer. The status isn’t a filterable field.

![image](https://us1.discourse-cdn.com/wix/original/3X/5/3/53a68a42f4d8382286e737f147aed327262e1e82.png)

---

<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:** [March 13, 2024, 10:09am UTC](https://forum.wixstudio.com/t/members-fulldata-quey-filter-issue/57029/8 "2024-03-13T10:09:04Z")

</div>

This explains the following…

> [@Brian\_Lewis](#):
>
> The above code is working well but the problem started when I added a filter to it. It throws an error. “WDE0080”
