Skip to content

Latest commit

 

History

History
33 lines (28 loc) · 724 Bytes

All_50_Year_Old_Novels.md

File metadata and controls

33 lines (28 loc) · 724 Bytes
banner banner_x banner_y
assets/banners/Books-Banner.png
0.5
0.5

All Novels Published Prior To 1973

This code displays all novels from the Books folder published prior to 1973 sorted by year.

```dataview
TABLE WITHOUT ID
  author AS "Author",
  link(file.link, title) as Title,
  published AS "Year"
FROM "Books"
WHERE contains(shelves, "novels") AND author != null AND title != null AND published < 1973
SORT published ASC
```

Output of above code:

TABLE WITHOUT ID
  author AS "Author",
  link(file.link, title) as Title,
  published AS "Year"
FROM "Books"
WHERE contains(shelves, "novels") AND author != null AND title != null AND published < 1973
SORT published ASC