Members/FullData Quey Filter Issue

[Brian_Lewis]

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

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”

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

[codequeen]

@Brian_Lewis

WDE0080

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

Error Codes - Velo API Reference - Wix.com

[Brian_Lewis]

@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?

[codequeen]

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

[CODE-NINJA]

[codequeen]

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

Yet I read the wrong error code!?

[Brian_Lewis]

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

[CODE-NINJA]

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”