Question: How to show images (or is it broken)?

[merlinuwe]

I've read https://hypersphere.blog/sql-seal/links-and-images.html#links-and-images and tried this in my testVault

SELECT path, img(cover, path)
FROM files 
LIMIT 10

and get

Error: no such column: cover

The Console shows this:

The following gives a result:

SELECT path
FROM files 
LIMIT 10

SYSTEM INFO:
Obsidian version: v1.8.10
Installer version: v1.8.10
Operating system: Windows 10 Home 10.0.19045
Login status: not logged in
Language: de
Insider build toggle: off
Live preview: off
Base theme: light
Community theme: none
Snippets enabled: 3
Restricted mode: off
Plugins installed: 28
Plugins enabled: 1
1: SQLSeal v0.34.0

RECOMMENDATIONS:
Custom theme and snippets: for cosmetic issues, please first try updating your theme and disabling your snippets. If still not fixed, please try to make the issue happen in the Sandbox Vault or disable community theme and snippets.
Community plugins: for bugs, please first try updating all your plugins to latest. If still not fixed, please try to make the issue happen in the Sandbox Vault or disable community plugins.

After trying it again, there is no output in the console, but the query shows again "Error: no such column: cover"

[kulak-at]

@merlinuwe I think you're not getting the image because the table you are getting data from does not contain "cover" property. Can you share the full query here?

[merlinuwe]

I tried this as shown before:

SELECT path, img(cover, path)
FROM files 
LIMIT 10

Then this:

SELECT 
  path, 
  '![](' || path || ')' AS Bild
FROM files
WHERE path LIKE 'Privat/Kunst/Kunst Materialien Tinten/testbilder/%.jpg'
LIMIT 10

My vaults name is "Obsidian" and my images live in Obsidian/Privat/Kunst/Kunst Materialien Tinten/testbilder/%.jpg

Do you have an easy reproducable working example for me?