Learnings about Dataview Plugin and DQL ![[DataView_1.png]] ![[DataView_4.png]] ![[DataView_6.png]] ![[DataView_3.png]] ![[DataView_2.png]] > 1. Display all notes in a specific folder > 2. Show all notes tagged with a specific tag > 3. Show all notes modified on a specific date > 4. Display all notes containing a specific keyword or phrase > 5. Display all notes sorted by creation date or modification date > 6. Show all tasks marked as completed or not completed > 7. Display all notes that link to a specific note > 8. Show all notes with a certain word count range > 9. Display all notes with an attached file or image > 10. Show all tags used in the vault and their frequency of use > 11. Display all notes sorted by word count or character count > 12. Show all backlinks for a specific note > 13. Display all notes with a particular heading or subheading. > 14. Show all links to external URLs in the vault. > 15. Display statistics on the number of words, characters, and paragraphs in the vault. > 16. Show the most frequently used words in the vault. > 17. Display statistics on how many times each tag has been used in the vault. > 18. Show how many files are stored in the vault and their total size. > 19. Display a list of images used in the vault, sorted by size and format. > 20. Show any orphaned files (files that are not linked to any note) in the vault ## Example Queries: >[!Example] Queries > 1. ```table file.subfolder``` > 2. ```table #tag``` > 3. ```table modified:2022-01-01``` > 4. ```table search('keyword')``` > 5. ```table sort file.created``` > 6. ```table task.completed:false``` > 7. ```table linksto('note title')``` > 8. ```table wordcount>=100 and wordcount<=500``` > 9. ```table has:attachment``` > 10. ```list tags groupby count desc``` > 11. ```table sort wordcount desc``` > 12. ```backlinks('note title')``` > 13. ```table heading:'Heading Text' or subheading:'Subheading Text'``` > 14. ```list extlinks``` > 15. ```summarize words, chars, paragraphs``` > 16. ```list words groupby count desc``` > 17. ``list tags groupby count`` > 18. ```summarize size(path)``` or ```summarize count(path)``` > 19. ```list images sort size, ext``` > 20. ```orphans```