find( )

Returns the items that match the query.

Description

The find() function returns a Promise that resolves to the results found by the query and some information about the results. The Promise is rejected if find() is called with incorrect permissions or if any of the functions used to refine the query is invalid.

Calling the find() function triggers the beforeQuery() and afterQuery() hooks if they have been defined. If the query being run contains an include(), calling find() triggers beforeQuery() and afterQuery() hooks for the referenced collection as well.

Use the options parameter to run find() without checking for permissions or without its registered hooks.

If you build a query and don't refine it with any wixDataQuery functions, find() returns the entire collection.

Syntax

function find([options: WixDataOptions]): Promise<WixDataQueryResult>

find Parameters

NAME

TYPE

DESCRIPTION

options

Optional

WixDataOptions

An object with one or both of the following boolean properties: suppressAuth, suppressHooks.

Returns

Fulfilled - A Promise that resolves to the results of the query. Rejected - Error that caused the query to fail.

Return Type:

Promise<WixDataQueryResult>

Was this helpful?

Perform a find on a query

This example demonstrates how to run a find() on a query() that was previously built and stored in a variable.

Code Example

Copy Code

1query.find()
2  .then( (results) => {
3    if(results.items.length > 0) {
4      let items = results.items;
5      let firstItem = items[0];
6      let totalCount = results.totalCount;
7      let pageSize = results.pageSize;
8      let currentPage = results.currentPage;
9      let totalPages = results.totalPages;
10      let hasNext = results.hasNext();
11      let hasPrev = results.hasPrev();
12      let length = results.length;
13      let query = results.query;
14    } else {
15      // handle case where no matching items found
16    }
17  } )
18  .catch( (error) => {
19    let errorMsg = error.message;
20    let code = error.code;
21  } );
22

Create a query and run it

This example demonstrates how to build a query() and then run a find() on it.

Code Example

Copy Code

1import wixData from 'wix-data';
2
3// ...
4
5wixData.query("myCollection")
6  .find()
7  .then( (results) => {
8    if(results.items.length > 0) {
9      let items = results.items;
10      let firstItem = items[0];
11      let totalCount = results.totalCount;
12      let pageSize = results.pageSize;
13      let currentPage = results.currentPage;
14      let totalPages = results.totalPages;
15      let hasNext = results.hasNext();
16      let hasPrev = results.hasPrev();
17      let length = results.length;
18      let query = results.query;
19    } else {
20      // handle case where no matching items found
21    }
22  } )
23  .catch( (error) => {
24    let errorMsg = error.message;
25    let code = error.code;
26  } );
27

Create a query, add functions to the query, and run it

This example demonstrates how to build a query(), chain additional functions such as eq() and gt() to the query, and then run the query().

Code Example

Copy Code

1import wixData from 'wix-data';
2
3// ...
4
5wixData.query("myCollection")
6  .eq("status", "active")
7  .gt("age", 25)
8  .ascending("last_name", "first_name")
9  .find()
10  .then( (results) => {
11    if (results.items.length > 0) {
12      let items = results.items;
13      let firstItem = items[0];
14      let totalCount = results.totalCount;
15      let pageSize = results.pageSize;
16      let currentPage = results.currentPage;
17      let totalPages = results.totalPages;
18      let hasNext = results.hasNext();
19      let hasPrev = results.hasPrev();
20      let length = results.length;
21      let query = results.query;
22    } else {
23      // handle case where no matching items found
24    }
25  } )
26  .catch( (error) => {
27    let errorMsg = error.message;
28    let code = error.code;
29  } );
30

Create a query with options and run it

This example demonstrates how to build a query() and then run a find() that bypasses permission checks and registered hooks. Note that the options parameter can only be used in backend code.

Code Example

Copy Code

1import wixData from 'wix-data';
2
3// ...
4
5let options = {
6    "suppressAuth": true,
7    "suppressHooks": true
8};
9
10wixData.query("myCollection")
11  .find(options)
12  .then( (results) => {
13    if(results.items.length > 0) {
14      let items = results.items;
15      let firstItem = items[0];
16    } else {
17      // handle case where no matching items found
18    }    
19  } )
20  .catch( (error) => {
21    let errorMsg = error.message;
22    let code = error.code;
23  } );
24