Levelup

🕵️‍♀️ Task

Order the records in the movies table by the year column in ascending order.

movies

id (integer)
title (string)
year (integer)
duration (integer)
description (text)
image (string)
director_id (integer)

directors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

actors

id (integer)
name (string)
dob (date)
bio (text)
image (string)

characters

id (integer)
actor_id (integer)
movie_id (integer)
name (string)

📖Method

The .order method lets you sort your collection of records by one or more columns. .order can accept a Hash, String, or Arel as an argument.

Most commonly, we pass a Hash argument where the keys are the columns you want to sort by, and the value are either :asc (for ascending order) or :desc (for descending order).

Data

id	title	year	duration	description	image	director_id

Data

id	name	dob	bio	image

Data

id	name	dob	bio	image
97	Liam Neeson	1952-06-07	Born on June 7, 1952 in Bal...	http://ia.media-imdb.com/im...
98	Ben Kingsley	1943-12-31	Ben Kingsley was born in En...	http://ia.media-imdb.com/im...
99	Ralph Fiennes	1962-12-22	Ralph Twisleton Wykeham Fie...	http://ia.media-imdb.com/im...
100	Caroline Goodall	1959-11-13	Born in Britain to Australi...	http://ia.media-imdb.com/im...
101	Jonathan Sagall		Born in 1962 Toronto, Canad...
102	Embeth Davidtz	1965-08-11	Embeth Davidtz moved to Sou...	http://ia.media-imdb.com/im...
103	Malgorzata Gebel	1955-11-30
104	Shmuel Levy

Data

id	actor_id	movie_id	name
105	99	8	Amon Goeth
106	100	8	Emilie Schindler
107	101	8	Poldek Pfefferberg (as Jona...
108	102	8	Helen Hirsch
109	103	8	Wiktoria Klonowska (as Malg...
110	104	8	Wilek Chilowicz (as Shmulik...
111	105	8	Marcel Goldberg
112	106	8	Ingrid (as Beatrice Macola)

Examples

Order the records from the customers table by the name column, descending

Customer.all.order({ :name => :desc})
=> #<Customer::ActiveRecord_Relation:0x00007fa4341e1ee8>

Order the records from the products table by the release_date column, descending

Product.all.order({ :release_date => :asc })
=> #<Product::ActiveRecord_Relation:0x00007fa4341e1ee8>