Dataset Query for 3000 Items

Ask the community
,
14

@imnimarketing

The below code will search a database column (“fieldKey”) for items that match the value you type into your input box.

Change the following variables : (DatabaseID, fieldKey, input1, dropdown1)

async function getUniqueListFromDatabase() {

const List1 = await wixData.query(“DatabaseID”)

        .contains("fieldKey", $w("#input1").value) 

        .limit(1000) 

        .ascending("fieldKey") 

        .find()

const List2 = await wixData.query(“DatabaseID”)

        .contains("fieldKey", $w("#input1").value) 

        .limit(1000) 

        .skip(1000) 

        .ascending("fieldKey") 

        .find()

const List3 = await wixData.query(“DatabaseID”)

        .contains("fieldKey", $w("#input1").value) 

        .limit(1000) 

        .skip(2000) 

        .ascending("fieldKey") 

        .find()

const List4 = await wixData.query(“DatabaseID”)

        .contains("fieldKey", $w("#input1").value) 

        .limit(1000) 

        .skip(3000) 

        .ascending("fieldKey") 

        .find()

const mergedLists = List1.items.concat(List2.items).concat(List3.items).concat(List4.items)

const uniqueItems = getUniqueTitles(mergedLists);

    $w("#dropdown1").options = buildOptions(uniqueItems);

function getUniqueTitles(items) {

const titlesOnly = items.map(item => item.fieldKey); // don’t forget to change this field key

return [… new Set(titlesOnly)];

    }

function buildOptions(uniqueList) {

return uniqueList.map(curr => {

return { label: curr, value: curr };

        }); 

    } 
}