@russian-dima This is the expected.
But it’s not happening to me. As a matter of fact, it works with some fields but not all. What would you say on this one? And yes I’m in Live.
" Comments" is text field type. The isEmpty works correctly. It counts exactly all cells that have data in them and if I add something/or delete something in Live, the change is depicted when refreshing the page. All good.
wixData.query(“LawDatabase”)
.isEmpty(“comments”)
.count()
.then( (num) => {
let numberOfItems = num;
console.log(“Comments field has “, num, “empty cells.”)
$w(”#text11”).text = num.toString()
} ) ;
“Language” is also text field type. THIS ONE DOES NOT WORK. If I delete a value, this does not reflect to total number. It’s still 445, not 444.
wixData.query(“LawDatabase”)
.isEmpty(“Language”)
.count()
.then( (num) => {
let numberOfItems = num;
console.log(“Language field has”, num, “empty cells.”)
$w(“#text25”).text = num.toString()
});