Exceeding query limit when filtering

Ask the community
,
12

So you’re right, your " terminology isn’t up to scratch". But that’s OK, your learning…

What you’re trying to do is to filter/search a collection of [about] 1900 records, and you expect about just a few as the result of the query.

What you will need to do is to include in your filter the selected value (if there is one) of each of the dropdowns. So it would be something like this:

var query = wixData.query(collectionName);
if (FilterKey1) {
   query = query.eq(FilterKey1, FilterValue1);
}
if (FilterKey2) {
   query = query.eq(FilterKey2, FilterValue2);
}
if (FilterKey3) {
   query = query.eq(FilterKey3, FilterValue3);
}
query
        .limit(40)
        .find()
        .then(results => {
            const uniqueTitles = getUniqueTitles(results.items);
            $w("#" + dropdown).options = buildOptions(uniqueTitles);
            $w("#" + dropdown).enable();
        });

Disclaimer: the above code has not been test, it’s for illustration purposes. But that’ll give you the general idea on how to build your filter.

See Querying Your Collection for more information on building a query.