Ruby on Rails - SQL Query count

Question

I need to count all the microposts of my image where the status is equal to new.

<% for column in @images %>
  <%= column.id %>
  <%= column.microposts.count() %>
<% end %>

I have tried this line but it doesn't work:

<%= column.microposts.count(" WHERE status='new' ") %>

Is there a way I can add a condition ?

xdazz · Accepted Answer · 2012-09-29 14:16:23Z

3

column.microposts.where(:status => 'new').count

answered Sep 29, 2012 at 14:16

xdazz

161k38 gold badges255 silver badges278 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

alex · Accepted Answer · 2012-09-29 14:18:55Z

0

column.microposts.find_all_by_status('new').count

answered Sep 29, 2012 at 14:18

alex

3,7523 gold badges23 silver badges22 bronze badges