# Record count

**URL:** <https://www.ruby-forum.com/t/record-count/130299>\
**Category:** Rails\
**Created:** [February 27, 2008, 5:49am UTC](https://www.ruby-forum.com/t/record-count/130299 "2008-02-27T05:49:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [February 27, 2008, 5:49am UTC](https://www.ruby-forum.com/t/record-count/130299/1 "2008-02-27T05:49:12Z")

</div>

I have in controller

@search\_sd\_ticket\_result = ServiceDeskTicket.find\_where(:all ) do |sd|  
sd.number.downcase =~  
“%”+@sd\_ticket\_number.downcase+"%" if !@sd\_ticket\_number==nil  
sd.service\_desk\_status\_id==  
@sd\_ticket\_status\_id  
sd.service\_desk\_priority\_id==  
@sd\_ticket\_priority\_id  
sd.primary\_assignee==  
@sd\_ticket\_primary\_assignee  
sd.created\_on \<=\>  
(@sd\_ticket\_start\_date…@sd\_ticket\_end\_date) if  
!@sd\_ticket\_start\_date==nil and !@sd\_ticket\_end\_date==nil  
end

NOW HOW TO GET THE COUNT OF RECORDS ONLY NOT THE COMPLETE DATA USING  
ABOVE

Please help  
Sijo

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [February 27, 2008, 5:54am UTC](https://www.ruby-forum.com/t/record-count/130299/2 "2008-02-27T05:54:58Z")

</div>

Your code is confusing and I dont know what records you want count in  
the meaning of “THE COUNT OF RECORDS ONLY NOT THE COMPLETE DATA USING  
ABOVE”

> NOW HOW TO GET THE COUNT OF RECORDS ONLY NOT THE COMPLETE DATA USING  
> ABOVE

~R.A~

---

<div class="post-metadata">

**Author:** ![sijo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/da6949/32.png) [@sijo](https://www.ruby-forum.com/u/sijo)\
**Post date:** [February 27, 2008, 6:17am UTC](https://www.ruby-forum.com/t/record-count/130299/3 "2008-02-27T06:17:43Z")

</div>

Hi  
@search\_sd\_ticket\_result = ServiceDeskTicket.find\_where(:all ) do |sd|

```
     sd.service_desk_status_id==@sd_ticket_status_id
     sd.service_desk_priority_id==@sd_ticket_priority_id

                             end

```

THIS IS WORKING HERE IN @search\_sd\_ticket\_result I GET THE RECORDS  
MATCHING.BUT WHAT I NEED IS NOT TO FETCH RECORDS BUT ONLY GET THE COUNT  
OF RECORDS …SO HOW CAN I ALTERATE THE ABOVE CODE TO GET THE COUNT OF  
RECORDS

Sijo