wixData.query() .contains/.startsWith throws an error

Ask the community
,
1

I have a page that connects data to a repeater. I followed this example to get everything hooked up. https://www.wix.com/corvid/forum/community-discussion/connecting-repeater-to-database-in-condition-if . It works just fine. Now, I want to filter the query with either .startsWith or .contains. But, it never works - it just throws an error no matter what I do.

I followed this example to make sure my syntax is correct: https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html#startsWith

$w.onReady(async function () {
    $w('#repeater1').data = await getData() ;
});

async function getData() {
    return wixData.query("PaidPlans/Plans")
        .startsWith("name", "ironman")
        .find()
        .then((results) => {
           return results.items;
        })
}

Here’s the error I get:

970×56 4.94 KB

Again, if I remove the .startsWith line everything works fine. If I change .startsWith to .contains I get the same error.

And here’s the column in the collection

518×826 42.7 KB

What am I missing?

2

As you are using the Wix Paid Plans app, then you have to make sure that you are following the limits for the Wix Paid Plans collection fields as shown here.
https://support.wix.com/en/article/corvid-wix-paid-plans-plans-collection-fields

Name (name)

Description : The name of the paid plan.
Type : Text
Can connect to data : Yes
Can use in dynamic page URL : No
Can be sorted : No
Can be filtered : No
Read-only : Yes

3

Oh noooooooo! Darn! Ok, thanks for providing that insight. I’ll have to do things a different way then.