Wixdata.query for an element within an array in collection

Ask the community
, ,
2

You can use this function to query member data:

wixData.query("Members/PrivateMembersData")
    .eq('location' yourVariable) //try and use your session here
    .limit(50) /*there is a max but cannot remember on top of my head --> normal collections are 1000 but member and stores are less */
    .find()
    .then( (results) => { 
        // handle the results  
    } );

You should also just query everything, filter the ones you want, then display in repeater all in code.

To display items from query in repeater, check this out – its great.

Code example:

import wixData from ‘wix-data’;

$w.onReady(async function () {
// Define how to set up each new repeater item
$w(‘#helloRepeater’).onItemReady( ($item, itemData, index) => {
$item(‘#languageText’).text = itemData.language;
$item(‘#helloText’).text = itemData.greeting;
$item(‘#indexText’).text = (index + 1).toString();

$item('#itemContainer').onMouseIn( () => {
  $item('#languageText').show();
});

$item('#itemContainer').onMouseOut( () => {
  $item('#languageText').hide();
});

} );

// Get data from a database collection
const {items: collectionData} = await wixData.query(‘Greetings’).find();
console.log(collectionData);

// Set the data to associate with the repeater
$w(‘#helloRepeater’).data = collectionData;
});