Search...
isEmpty( )
Refines a query or filter to match items whose specified property does not exist or does not have any value.
Description
The isEmpty()
function refines a WixDataQuery
or WixDataFilter
to only match items where the
value of the specified property is null
or undefined
or the property does
not exist.
If the property contains any value at all for a given item, including the empty string or an invalid value, that item will match the query.
Syntax
function isEmpty(propertyName: string): WixDataQuery
isEmpty Parameters
NAME
TYPE
DESCRIPTION
propertyName
string
The the property in which to check for a value.
Mixed in from:wix-data.WixDataFilter
Was this helpful?
Add an isEmpty filter to a query
Copy Code
1let newQuery = query.isEmpty("bio");
Create a query, add an isEmpty filter, and run it
Copy Code
1import wixData from 'wix-data';23// ...45wixData.query("myCollection")6 .isEmpty("bio")7 .find()8 .then((results) => {9 if(results.items.length > 0) {10 let items = results.items;11 let firstItem = items[0];12 let totalCount = results.totalCount;13 let pageSize = results.pageSize;14 let currentPage = results.currentPage;15 let totalPages = results.totalPages;16 let hasNext = results.hasNext();17 let hasPrev = results.hasPrev();18 let length = results.length;19 let query = results.query;20 } else {21 // handle case where no matching items found22 }23 })24 .catch((error) => {25 let errorMsg = error.message;26 let code = error.code;27 });
Create a query, add an isEmpty filter, and run it
Copy Code
1import wixData from 'wix-data';23// ...45wixData.query("myCollection")6 .isEmpty("bio")7 .gt("age", 25)8 .ascending("last_name", "first_name")9 .limit(10)10 .find()11 .then((results) => {12 if(results.items.length > 0) {13 let items = results.items;14 let firstItem = items[0];15 let totalCount = results.totalCount;16 let pageSize = results.pageSize;17 let currentPage = results.currentPage;18 let totalPages = results.totalPages;19 let hasNext = results.hasNext();20 let hasPrev = results.hasPrev();21 let length = results.length;22 let query = results.query;23 } else {24 // handle case where no matching items found25 }26 })27 .catch((error) => {28 let errorMsg = error.message;29 let code = error.code;30 });