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?
Something like
datesFilter = datesFilter.hasSome("yachtCalender.date", "10/24/2020");
That's exactly my question, how can I search for that inside the "date" property?
Look at your data structure. The array contains objects not simple strings and you filter for specific string.