on User attributes and get a count of the user's post filtered on Post
this generated query runs very well,
SELECT DISTINCT `users`.* FROM `users` LEFT OUTER JOIN `posts` ON
`posts`.`user_id` = `users`.`id` WHERE (`posts`.`title` LIKE '%pa%')
ORDER BY `users`.`last_name` ASC
and I can display all selected users info :
but how can I add a column with the number of filtered posts for each
thanks for your feedback [using Rails 3.2.3 )
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to email@example.com.
To unsubscribe from this group, send email to firstname.lastname@example.org.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.