---
title: .find()
slug: find
docTags: 
createdAt: 2021-09-14T16:37:07.000Z
---

### Description

This method, called on a @Table, returns a [Sequence](docId\:JG4itlQWafzLpArttFo67)  of results matching the filter.

- Operates on: [Sequence](docId\:JG4itlQWafzLpArttFo67)  
- Returns: [Sequence](docId\:JG4itlQWafzLpArttFo67) 

### Syntax

`db.table.find()`

- Returns a Sequence of all of the objects in the Table.

`db.table.find{expression}`

- Returns a Sequence of all of the objects in the Table that match `expression`

### Examples

`db.job.find{startDate >= '2025-01-01'}`

- Returns a Sequence of all [Job](docId:09AD2ikREIzwa-J0dFOBM)s with a start-date from Jan 1 2025 and on.

`db.opportunity.find{type:new stage:"closed won"}`

- Returns a Sequence of all Opportunity objects (if you have an `opportunity` Table), which are of Type "new" and Stage "Closed Won"

### Find and Aggregations in Dashboards

Often, `find()` is combined with other methods to calculate aggregations in Dashboards. For example:

- `db.job.find{startDate >= '2025-01-01}.mean{baseComp}`
  - Calculates the mean average base compensation for all jobs that started from 2025-01-01 on.
- `db.job.find{jobFilter}.groupBy{department}.sum{cost}`
  - Calculates the total cost of jobs matching the `jobFilter` filter, grouped by each department.