Displaying and sorting multiple queries together

Question

I would like to display data that combines information from multiple queries. For example:

@projects = @company.projects
@assignments = @company.assignments
@tasks = @company.tasks

How can I take these three queries and display a big table that shows projects, assignments, and tasks, all sorted together by created_at? The desired result will look like this:

7/11  Task created by company Xc for project Xp.
7/10  Project Xp created by User U.
7/09  Task created by company Yc for project Yp.
7/09  Assignment created by company Yc for project Yp.
7/08  Project Yp created by user U.

Heinrich Lee Yu · Accepted Answer · 2013-07-11 09:39:55Z

2

You can use a SQL UNION query for that if you want to do more complex stuff like getting the newest x entries only or for pagination.

If you know the data is very few, you can collect the results in an array and sort by created_at

@events = @projects.to_a + @assignments.to_a + @tasks.to_a
@events.sort_by! { |e| e.created_at }

answered Jul 11, 2013 at 9:39

Heinrich Lee Yu

1,48215 silver badges31 bronze badges

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

2 Comments

Magnuss Over a year ago

@events.sort_by!(&:created_at)

Heinrich Lee Yu Over a year ago

Yes, that shorthand is also good. But I believe the expanded form is easier to understand.

Collectives™ on Stack Overflow

Displaying and sorting multiple queries together

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related