Skip to content

Latest commit

 

History

History
336 lines (274 loc) · 6.1 KB

Beets_Albums.md

File metadata and controls

336 lines (274 loc) · 6.1 KB
Raw
banner banner_x banner_y
assets/banners/Dataview-Banner.png
1.0
1.0

All Beets Albums

This code displays all albums from the Beets folder sorted by artist.

```dataview
LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "A")
GROUP BY "**" + artist + "**"
```

Or, for artists whose name does not start with A-Z,

```dataview
LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      regexmatch("^(?![a-z]).+", lower(artist))
GROUP BY "**" + artist + "**"
```

Navigation

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

0-9+

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      regexmatch("^(?![a-z]).+", lower(artist))
GROUP BY "**" + artist + "**"

A

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "A")
GROUP BY "**" + artist + "**"

B

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "B")
GROUP BY "**" + artist + "**"

C

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "C")
GROUP BY "**" + artist + "**"

D

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "D")
GROUP BY "**" + artist + "**"

E

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "E")
GROUP BY "**" + artist + "**"

F

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "F")
GROUP BY "**" + artist + "**"

G

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "G")
GROUP BY "**" + artist + "**"

H

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "H")
GROUP BY "**" + artist + "**"

I

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "I")
GROUP BY "**" + artist + "**"

J

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "J")
GROUP BY "**" + artist + "**"

K

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "K")
GROUP BY "**" + artist + "**"

L

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "L")
GROUP BY "**" + artist + "**"

M

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "M")
GROUP BY "**" + artist + "**"

N

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "N")
GROUP BY "**" + artist + "**"

O

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "O")
GROUP BY "**" + artist + "**"

P

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "P")
GROUP BY "**" + artist + "**"

Q

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "Q")
GROUP BY "**" + artist + "**"

R

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "R")
GROUP BY "**" + artist + "**"

S

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "S")
GROUP BY "**" + artist + "**"

T

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "T")
GROUP BY "**" + artist + "**"

U

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "U")
GROUP BY "**" + artist + "**"

V

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "V")
GROUP BY "**" + artist + "**"

W

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "W")
GROUP BY "**" + artist + "**"

X

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "X")
GROUP BY "**" + artist + "**"

Y

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "Y")
GROUP BY "**" + artist + "**"

Z

LIST link(rows.file.link, rows.album)
FROM "Beets"
WHERE artist != null AND
      album != null AND
      startswith(upper(artist), "Z")
GROUP BY "**" + artist + "**"