Can active record support: 'find' parent objects, but filtered based on the contents of it's associated child objects data

rubyonrails-talk
1

Hi,

Can active record handle the following? Or do I need to stick to “.find_by_sql” to do this:

select parent.id, parent.title, parent.description from parent, child where parent.id = child.parent_id AND child.memo like ‘%texttosearch%’

That is, I want to effectively ‘find’ parent objects, but filtered based on the contents of it’s associated child objects data. So the question is if it is possible what would the ruby code be to do this? i.e. results = Parent.find(:all, …

Thanks Greg