Hi,
I just tested this and it should work, just change it accordingly to filter a dataset
wixData.query("myCollection")
.eq("a", "b")
.eq("c", "d")
.eq("e", "f")
.or(
wixData.query("myCollection")
.eq("a", "b")
.eq("c", "d")
.isEmpty("e")
)
.find()
.then( (results) => {
//do cool stuff here
});
[UPDATED] For filtering dataset (tested)
export function button1_click(event) {
$w("#dataset1").setFilter( wixData.filter()
.eq("a", "b")
.eq("c", "d")
.eq("e", "f")
.or(
wixData.filter()
.eq("a", "b")
.eq("c", "d")
.isEmpty("e")
)
)
.then( () => {
console.log('Done');
});
}