Movies

Click here to view the related video lessons

• How to Use the Movies Collection

This note collects all notes where the in property says Movies.

My Top Movie Shelf

Multi

5.7+

TABLE WITHOUT ID
	file.link as Movie,
	"![|100](" + image + ")" as Poster,
	rating as Rating
WHERE
	contains(in,this.file.link) and
	rating >= 5.7 and
	!contains(file.name, "Template")
SORT rating desc, year asc

5.4 - 5.6

TABLE WITHOUT ID
	file.link as Movie,
	"![|75](" + image + ")" as Poster,
	rating as Rating
WHERE
	contains(in,this.file.link) and
	rating < 5.7 and
	rating > 5.3 and
	!contains(file.name, "Template")
SORT rating desc, year asc

5.1 - 5.3

TABLE WITHOUT ID
	file.link as Movie,
	"![|50](" + image + ")" as Poster,
	rating as Rating
WHERE
	contains(in,this.file.link) and
	rating < 5.4 and
	rating > 5 and
	!contains(file.name, "Template")
SORT rating desc, year asc

5's

TABLE WITHOUT ID
	file.link as Movie,
	"![|40](" + image + ")" as Poster,
	rating as Rating
WHERE
	contains(in,this.file.link) and
	rating = 5 and
	!contains(file.name, "Template")
SORT rating desc, year asc

Movies sorted by Ratings

# Movies sorted by Ratings, with Covers & YearXP

TABLE WITHOUT ID
	year as Year,
	"![|60](" + image + ")" as Poster,
	file.link as Title,
	rating as Rating,
	yearXP as YearXP,
	yearXPL as YearXPL
WHERE
	contains(in,this.file.link) and
	!contains(file.name, "Template")
SORT rating desc, year desc

# Movies sorted by Ratings, with People and Genres

TABLE WITHOUT ID
	year as Year,
	"![|60](" + image + ")" as Poster,
	file.link as Title,
	rating as Rating,
	join(list(director, actors)) as People,
	join(list(showGenre)) as Genre
WHERE
	contains(in,this.file.link) and
	!contains(file.name, "Template")
SORT rating desc, year desc

Extra

These are “works in progress” but they should give you some ideas for your own movie groups and movie shelves.

Shows sorted by showGroup of "groundhog day"

TABLE WITHOUT ID
	year as Year,
	"![|60](" + image + ")" as Poster,
	file.link as Title,
	rating as Rating,
	join(list(director, actors)) as People
WHERE
	contains(showGroup,"groundhog day") 
SORT rating desc, year desc

Multi

# MAX Testosterone!

TABLE WITHOUT ID
	year as Year,
	"![|60](" + image + ")" as Poster,
	file.link as Title,
	rating as Rating,
	join(list(director, actors)) as People
WHERE
	contains(showGroup,"max testosterone") 
SORT rating desc, year desc

Adaptations Shows sorted by showGroup of adaptation

TABLE WITHOUT ID
	year as Year,
	"![|60](" + image + ")" as Poster,
	file.link as Title,
	rating as Rating,
	join(list(director, actors)) as People
WHERE
	contains(showGroup,"adaptation") 
SORT rating desc, year desc