Sorting for multiple references/datasets?

Ask the community
,
1

SITE: https://bdarienjr.wixsite.com/tmt-realty

I have 2 datasets on my dynamic page for all rental properties; Rentals (#dynamicdataset) and Properties (#dataset1). I also have another dataset for Neighborhoods.

I have set up a sort for price, beds, baths, and neighborhoods. Neighborhoods is a reference field in the rentals and properties datasets.

The search function works for everything except neighborhoods. How do I account for sorting neighborhoods in my code??

2

So i have this example laying around from when i first learned it because its a quite hard thing to do.

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;
}

This example have the Colors collection which is referenced in the Items collection. by first finding what you want in the colors and then using this with .hasSome or all will allow you to search from the reference field in the Items collection and filter from that.

Hope that make sense, prefer leaving a little learning left for people.

3

@alexander-wix @amit-wix @wixanat @benjamin-bavel-wix @brett-haralson @bryanp @caros-wix @corvidcode @danielle-raiz-wix @erezco @gabriel-lipschutz-wi @gjaloveckas @giedrius-jaloveckas @deleteduser

4

@clsnlsen can you explain your code a little more and how it would be adapted for my code? I am self-taught and still have a lot to learn

5

Anyone have any insights that might be able to help me?