top of page

The Data

The Items Collection

Picture
Title
Colors

The Colors Collection

Sample
Title
Items

Multiple-Reference Queries

queryReferenced - items referenced by Blue

async function queryReferenced() {

    let blue = (await wixData.query('Colors')

        .eq('title', 'Blue')

        .find()).items[0];

    let res = await wixData.queryReferenced('Colors',

        blue._id, 'Items');

    $w('#queryReferencedTextBox').value =

        JSON.stringify(res.items, undefined, ' ');

    $w('#tableQueryReferenced').rows = res.items;

}

Picture
Title

hasSome - items referenced by Blue or Green

async function queryHasSome() {
    let blue = (await wixData.query('Colors')
        .eq('title', 'Blue')
        .find()).items[0];
    let green = (await wixData.query('Colors')
        .eq('title', 'Green')
        .find()).items[0];
    let res = await wixData.query('Items')
        .hasSome('colors', [green._id, blue._id])
        .find();
    $w('#textBoxHasSome').value =

        JSON.stringify(res.items, undefined, '  ');
    $w('#tableHasSome').rows = res.items;
}

Picture
Title
bottom of page