# Questions on Active Record SQL type Finders & Dynamic Finder

**URL:** <https://www.ruby-forum.com/t/questions-on-active-record-sql-type-finders-dynamic-finder/149312>\
**Category:** Rails\
**Created:** [September 23, 2008, 2:28pm UTC](https://www.ruby-forum.com/t/questions-on-active-record-sql-type-finders-dynamic-finder/149312 "2008-09-23T14:28:26Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![webreservoir](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/w/e480ec/32.png) [@webreservoir](https://www.ruby-forum.com/u/webreservoir)\
**Post date:** [September 23, 2008, 2:28pm UTC](https://www.ruby-forum.com/t/questions-on-active-record-sql-type-finders-dynamic-finder/149312/1 "2008-09-23T14:28:26Z")

</div>

Hi,

I understand there are total 11 types of key Options for finding a  
record.

The all 11 valid keys for the options hash are :conditions,  
:include, :order, :select, :group, :joins, :from, :limit, :offset,  
:readonly, and :lock.

We also have Dynamic Finders for the same. e.g. … find\_by etc…

I would like to know, how many types of dynamic finders, Active Record  
provides, to match all those 11 key options above.

Where can i read more details regarding dynamic finders…?

Thanks