WixData .contains() method unknown limitations?

Ask the community
, ,
2

There is a couple of ways to attack this. I checked in the API docs and the default is 50.

Here’s the blurb:
By default, limit is set to 50.
The maximum value that limit() can accept is 1000.
Note that for some Wix app collections, the maximum value limit() can accept is less than 1000. For example, the maximum limit for the Wix Stores/Product collection is 100.

Now you can try a count() to see how many rows you expect to get back based on your search criteria (.contains()).

Sample count code:

wixData.query("Blog/Posts")
    .contains("plainContent", stringInput)
    .count()
    .find()
    .then( (num) => { 
        console.log("Number of records that match the search result is: "+num.toString());
    })
    .catch( (error) => {
        console.log("Error detected trying to query [Blog/Posts]. Error is : "+error.message);
    });