Help with .Next() in items

Ask the community
, ,
1

Hi I am filtering through my store which has over 250 items and im looking in the description for what i have selected in my dropdown. Which does work, however the results from .find() are limited to 50 items. i need to either search all items in the products or a way to iterate through in blocks of 50. Can someone help.

export function button81_click(event) {
    wixData.query("Stores/Products")
        .find()
        .then((results) => {
            console.log('results', results) // limits to 50 items 
            const data = results.items.filter(f =>
                f.description.includes($w('#dwnMake').value) &&
                f.description.includes($w('#dwnModel').value) &&
                f.description.includes($w('#dwnYear').value)
            )
            console.log('data', data)
            $w("#repeater2").data = data
        });
}
2

Have a read of the Wix Data API and the Query function and you will find your answer
https://www.wix.com/corvid/reference/wix-data.WixDataQuery.html

How can I limit the number of items returned by a query?
By default, a query() is limited to returning 50 items. Add the limit() function to your query chain.

3

Thanks for this reply, i have just tried it and it doesnt exactly fit my need, im using it to call the store/products and that is limited to 100 frustratingly. Anything else i can try?

4

Yes you are limited to the amount you can increase the limit by when you are using the Wix Store app and the Product collection.

https://support.wix.com/en/article/corvid-wix-stores-product-collection-fields
You can query up to 100 items from the Product collection. Trying to query more than 100 items by raising the wix-data limit will result in an error.

If you want to use it, then you will have to work with the limitations of using that Wix app or look at making up your own shop area yourself.
https://support.wix.com/en/article/customizing-the-load-more-button-in-wix-stores-product-gallery
https://support.wix.com/en/article/request-navigating-to-all-products-using-the-next-button-on-product-page-in-wix-stores
https://support.wix.com/en/article/request-page-numbers-or-navigation-arrows-in-a-product-gallery
https://support.wix.com/en/article/request-adding-a-back-button-to-your-product-page

Other options would be to look at using pagination if you are showing products in a repeater for example.
https://www.wix.com/corvid/reference/$w.Pagination.html
https://support.wix.com/en/article/adding-and-setting-up-a-pagination-bar
https://support.wix.com/en/article/corvid-tutorial-creating-previous-and-next-buttons-for-a-dynamic-item-page-with-code

Although please note that the last option might not be workable with the Wix Stores app itself.

5

Thanks, These do not work for me, my problem is mainly i want to search through all my products to find ones that match the inputs from drop down boxes. whats happening is its only searching through the first 100. There must be a way to cycle through the products until it has all of the data. the 100 products limit is rubbish!