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
311	Woody Strode	1914-07-25	An athlete turned actor, St...	http://ia.media-imdb.com/im...
312	Jack Elam	1920-11-13	Colorful American character...	http://ia.media-imdb.com/im...
313	Keenan Wynn	1916-07-27	Character actor Keenan Wynn...	http://ia.media-imdb.com/im...
314	Frank Wolff	1928-05-11	Frank Wolff started his car...
321	Sydney Greenstreet	1879-12-27	Sydney Greenstreet's father...	http://ia.media-imdb.com/im...
322	Peter Lorre	1904-06-26	As a youth Peter Lorre ran ...	http://ia.media-imdb.com/im...
323	S.Z. Sakall	1883-02-02	Hungarian-born S.Z. Sakall ...	http://ia.media-imdb.com/im...
324	Madeleine Lebeau	1923-06-10

Data

id	actor_id	movie_id	name
320	283	22	Gluttony Victim
321	284	22	Dr. O'Neill
322	285	22	Coroner (as Reginald E. Cat...
323	286	22	Workman
324	287	22	Cab Driver
325	288	22	George, Library Night Guard
326	289	22	Library Guard (as Roscoe Da...
327	290	22	Library Guard

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>