Wix Stores/Products 100-query-limit?

Ask the community
, ,
1

Is the query-limitation on Wix-Stores/Products = 100 ?

  1. Query-50 (standard-limited-query):

  1. Query-100 (increased query-limit to 100)

  1. Query-101 (increased query-limit to 101) !!!


What’s going on ?
No 1000-limit ?

2

Hi there …

All Wix databases are limited to max. 100.

3

@ahmadnasriya
Thanks Ahmad. Now it’s clear.

4

@russian-dima You’re welcome :wink:

5

Here is the function to bypass limit, works with 100 too, unless, you have more that 2000 elements, it will not time out

async function retrieveAllItems() {
2  let results = await wixData.query("myCollection")
3      .limit(1000)
4      .find();
5  let allItems = results.items;
6  while (results.hasNext()) {
7      results = await results.next();
8      allItems = allItems.concat(results.items);
9  }
10  return allItems;
11}
1 Like