# Dataview Test Page
This page tests Dataview functionality for both local Obsidian and Obsidian Publish.
%% DATAVIEW_PUBLISHER: start
```dataview
LIST
FROM "spoken"
WHERE contains(string(date), "1977")
SORT date DESC
LIMIT 10
```
%%
%% DATAVIEW_PUBLISHER: end %%
## Test 1: Recent Lectures (Simple List)
```dataview
LIST
FROM "spoken"
WHERE contains(string(date), "1977")
SORT date DESC
LIMIT 10
```
## Test 2: Letters Table
```dataview
TABLE
title as "Title",
dateformat(date, "yyyy-MM-dd") as "Date",
recipient as "To"
FROM "letters"
WHERE type = "correspondence" AND recipient
SORT date DESC
LIMIT 10
```
## Test 3: Lecture Count by Year
```dataview
TABLE
length(rows) as "Total Lectures"
FROM "spoken"
WHERE file.name != "type" AND file.name != "place" AND file.name != "index"
GROUP BY dateformat(date, "yyyy") as Year
SORT Year DESC
LIMIT 10
```
## Test 4: Morning Walks
```dataview
TABLE
title as "Title",
date as "Date",
duration as "Duration"
FROM "spoken"
WHERE contains(file.name, "mw")
SORT date DESC
LIMIT 10
```
## Test 5: Letters to Specific Recipients
```dataview
TABLE
dateformat(date, "MMM dd, yyyy") as "Date",
recipient as "Recipient"
FROM "letters"
WHERE recipient = "Brahmananda" OR recipient = "Hayagriva" OR recipient = "Satsvarupa"
SORT date ASC
LIMIT 15
```
---
**Instructions:**
1. View this page in Obsidian Reading mode to see if queries work locally
2. Publish this page to your site
3. Visit the published version to verify online rendering
4. If queries show as code blocks online, check Dataview is enabled in Publish settings
If all tests pass, you can use these query patterns throughout your site!