Dataview table not working

What I’m trying to do

I am new to obsidian and having a go with some of the functions. I’m trying to set up a movie database and book one too. The code for the table (for both) seems to not be able to “see” the information to pull it across, only the name of the file and only if I use a tag. Clearly I’m doing something relatively simple wrong but can’t figure out what so any help would be much appreciated

For books, this is the template I used to create said information (movie is similar)

title: "{{title}}" 
author: "{{author}}" 
category: "{{category}}" 
publisher: "{{publisher}}" 
publishdate: "{{publishdate}}" 
pages: "{{totalPage}}" 
cover: "{{coverUrl}}" 
rating: 
date read:
status:

Then to try and create a table from that:

TABLE author as Author, ("![|100](" + cover + ")") as Cover, pages, category as genre, rating 
From "books"
Where contains(status, "complete")

error message: Dataview: No results to show for table query.

The sample text below based on your data works in local tests. Do the properties render properly in your vault?

---
title: Title
author: Writer
category: Cats
publisher: Pub
publishdate: 2025-09-08
pages: 345
cover: "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcQj6tfMWf5SlwfC3PzRCBkON-dFVxPeiePbCu8HDIZQTQ&s"
rating: 1
date read: 2026-08-13
status: complete
---

```dataview
TABLE 
author as Author, 
("![|100](" + cover + ")") as Cover,
pages, 
category as genre, 
rating 
From ""
Where contains(status, "complete")
LIMIT 50
```

Interesting…no, they don’t come up like that for me

Have now fixed it… it didn’t have the 3 dashes and therefore the properties weren’t showing properly. Now they are and the tables are working…thank you

1 Like

Pleasure. Thought it might be something like that as the code itself was perfect. Good to hear it is working.