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
620	Jessica Kate Meyer			http://ia.media-imdb.com/im...
621	Julia Rayner			http://ia.media-imdb.com/im...
627	Roddy Skeaping
628	Ben Harlan
629	Mark Wahlberg	1971-06-05	American actor Mark Wahlber...	http://ia.media-imdb.com/im...
630	Ray Winstone	1957-02-19	Ray Winstone was born on Fe...	http://ia.media-imdb.com/im...
631	Vera Farmiga	1973-08-06	Vera Farmiga is a Ukrainian...	http://ia.media-imdb.com/im...
632	Anthony Anderson	1970-08-15		http://ia.media-imdb.com/im...

Data

id	actor_id	movie_id	name
625	562	44	Linda McFly
626	563	44	Sam Baines
627	564	44	Stella Baines
628	565	44	Mr. Strickland
629	566	44	Skinhead (as Jeffrey Jay Co...
630	567	44	3-D
631	568	44	Match
632	569	44	Marvin Berry

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>