contains( )
Refines a query or filter to match items whose specified property value contains a specified string.
Description
The contains()
function refines a WixDataQuery
or WixDataFilter
to
only match items where the value of the specified property contains the
specified string
. Matching with contains()
is not case sensitive, so
"text"
does contain "Tex"
.
You can use contains()
with a property whose value is a String or a Reference.
For properties of type reference it is recommended that you use the eq()
function instead of contains()
. With properties that are References, contains()
matches by the ID of the referenced item as a String.
Syntax
function contains(propertyName: string, string: string): WixDataQuery
contains Parameters
NAME
TYPE
DESCRIPTION
The property whose value will be compared with the string.
The string to look for inside the specified property value.
Was this helpful?
1let newQuery = query.contains("description", "some words");
1import wixData from 'wix-data';23// ...45wixData.query("myCollection")6 .contains("description", "some words")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 });
1import wixData from 'wix-data';23// ...45wixData.query("myCollection")6 .contains("description", "some words")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 });