Find_by_sql
Maybe you can just write the sql statement to get your results. I don’t
know your table relationships so I really can’t say if that would work
for you or not.
I had project ->tasks ->time and I was able to get a list of all hours
logged for a project for all tasks using find_by_sql.
Hope that helps!