.find()

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