# Dataview Cheatsheet
#lang/de #tool/obsidian #typ/Cheatsheet
**Web resources:**
- [Dataview Cheatsheet](https://github.com/seburbandev/obsidian-dataview-cheatsheet)
- [Dataview Docs](https://blacksmithgu.github.io/obsidian-dataview/)
- [Dataview JS Api](https://blacksmithgu.github.io/obsidian-dataview/api/intro/)
- [Dataview Example Vault](https://s-blu.github.io/obsidian_dataview_example_vault/)
-
## Object oriented notes
### [Metadata Menu](obsidian://show-plugin?id=metadata-menu) Queries
Get a list of all **tags** without the hashtag (`#`):
```
dv.pages().file.tags.distinct().map(str => str.replace(/#/g, ''))
```
Get a list of all files with a certain property in type (aka get a list of objects):
```
dv.pages('"objects/autoren"')
```
## Zeitliche Eingrenzung
```
WHERE file.day >= date(2024-10-14) and file.day < date(2024-11-01)
```
`file.day` nutzt den dateinamen oder das property `date`
## List inline properties
hier als Beispiel für Idee:
```
TABLE Idee as "Ideen"
WHERE contains(Idee, "")
SORT file.name desc
```
## List project support material
Tabelle mit `#meeting` und Link zur Datei. `file.day` nutzt den dateinamen oder das property `date` .
```
TABLE People, Summary
FROM #meeting AND [[Dataview Cheatsheet]]
SORT file.day
```
Liste von Notizen mit `#meeting` und link zur Datei
```
LIST
FROM #material AND [[Dataview Cheatsheet]]
SORT file.modified
```
## Random
Zufällige Notiz aus einem FROM Pool