~ [[Calendar]]
> [!calendar] [[Days]] | [[Records]] | **[[Reviews]]**
This view shows all notes in the Reviews folder that have "Review" or "Preview" in their name.
```dataview
TABLE WITHOUT ID
file.link as "Reviews",
type as "Parent Folder"
WHERE
contains(file.name, "review") OR
contains(file.name, "synthesis")
WHERE
type = "weekly-review" OR
type = "knowledge-synthesis"
SORT
regexreplace(file.name, ".*?(\\d{4}).*", "$1") desc,
regexreplace(file.name, ".*?Q(\\d+).*", "$1") desc
LIMIT 8
```
# All
This view includes all the notes within the Reviews folder, as long as they have a `YYYY` date in their name. It can also sort it somewhat intelligently, recognising quarterly reviews (Q1, Q2, etc) and even month names (Apr or April). The result is that the most recent dates will sort near the top.
```dataview
TABLE WITHOUT ID
file.link as "Reviews",
type as "Parent Folder"
WHERE type = "review"
SORT
regexreplace(file.name, ".*?(\\d{4}).*", "$1") desc,
choice(
regextest("\\d{4}-\\d{2}", file.name),
regexreplace(file.name, ".*?(\\d{4})-(\\d{2}).*", "$2"),
choice(
regextest("Q(\\d+)", file.name),
choice(
regexreplace(file.name, ".*Q(\\d+).*", "$1") = "1", "01",
choice(
regexreplace(file.name, ".*Q(\\d+).*", "$1") = "2", "04",
choice(
regexreplace(file.name, ".*Q(\\d+).*", "$1") = "3", "07",
choice(
regexreplace(file.name, ".*Q(\\d+).*", "$1") = "4", "10",
"00"
)
)
)
),
choice(
contains(file.name, "January") OR contains(file.name, "Jan"), "01",
choice(
contains(file.name, "February") OR contains(file.name, "Feb"), "02",
choice(
contains(file.name, "March") OR contains(file.name, "Mar"), "03",
choice(
contains(file.name, "April") OR contains(file.name, "Apr"), "04",
choice(
contains(file.name, "May"), "05",
choice(
contains(file.name, "June") OR contains(file.name, "Jun"), "06",
choice(
contains(file.name, "July") OR contains(file.name, "Jul"), "07",
choice(
contains(file.name, "August") OR contains(file.name, "Aug"), "08",
choice(
contains(file.name, "September") OR contains(file.name, "Sep"), "09",
choice(
contains(file.name, "October") OR contains(file.name, "Oct"), "10",
choice(
contains(file.name, "November") OR contains(file.name, "Nov"), "11",
choice(
contains(file.name, "December") OR contains(file.name, "Dec"), "12",
"00"
)
)
)
)
)
)
)
)
)
)
)
)
)
) desc,
choice(
regextest("\\d{4}-\\d{2}-\\d{2}", file.name),
regexreplace(file.name, ".*?(\\d{4})-(\\d{2})-(\\d{2}).*", "$3"),
"15"
) desc
LIMIT 66
```
---
Back to [[Calendar]]