Working with dataset filter .not() function

Ask the community
,
1

Hello everyone,
I have an array database field looks like that:

[
    {
        "date": "10/23/2020"
    },
        "date": "10/24/2020"
    },
        "date": "10/25/2020"
    }
]

I’m trying to implement dataset filter that will return all the items that does not include the string “10/24/2020” in this array field.
Tried to do that with not function but no luck.
here is my code for now :

let filter = wixData.filter();
let dateFilter = wixData.filter();
 
datesFilter = datesFilter.hasSome("yachtCalender", "10/24/2020");
filter = filter.not(datesFilter);

$w("#dynamicDataset").setFilter(filter);

Any ideas?

2

Look at your data structure. The array contains objects not simple strings and you filter for specific string.

3

That’s exactly my question, how can I search for that inside the “date” property?

4

Something like

datesFilter = datesFilter.hasSome("yachtCalender.date", "10/24/2020");
5

I don’t think that’s going to work for you. But I don’t have an answer to your question, I’ve never tried to run a query for an array of objects in a database (and I’m not even sure it’s supported).
However if you store it as JSON.stringify() you’ll be able to use:

datesFilter.contains("yachtCalender", "10/24/2020");