Search...
eq( )
Refines a query or filter to match items whose specified property value equals the specified value.
Description
The eq()
function refines a WixDataQuery
or WixDataFilter
to only
match items where the value of the specified property equals the specified value
.
It only matches values of the same type. For example, a number value stored as a String type does not match the same number stored as a Number type.
Matching strings with eq()
is case sensitive, so "text"
is not equal to "Text"
.
If propertyName
points to a collection field of type Array, eq()
includes the item
as long as at least one Array element matches the specified value
.
Syntax
function eq(propertyName: string, value: *): WixDataQuery
eq Parameters
NAME
TYPE
DESCRIPTION
propertyName
string
The property whose value will be compared with value
.
value
*
The value to match against.
Was this helpful?
Add an equals filter to a query
Copy Code
1let newQuery = query.eq("status", "active");
Create a query, add an equals filter, and run it
Copy Code
1import wixData from 'wix-data';23// ...45wixData.query("myCollection")6 .eq("status", "active")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 equals filter, and run it
Copy Code
1import wixData from 'wix-data';23// ...45wixData.query("myCollection")6 .eq("status", "active")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 });