Skip to content
TheChatArchiveThe Chat Archive
gpt-4.1-mini-2025-04-14· OpenAIAi2 WildChat-4.8M (AI2)

Write me a Dataview Query for obsidian which shows a table of all notes with the tag…

  1. User

    Write me a Dataview Query for obsidian which shows a table of all notes with the tag jobs sorted by the date posted, for which the property applied is false

  2. Assistant

    Certainly! Here is a Dataview query for Obsidian that displays a table of all notes tagged with #jobs, sorted by the date posted property, and where the applied property is false:

    table dateposted as "Date Posted", applied
    from #jobs
    where applied = false
    sort dateposted asc
    

    Notes:

    • Replace dateposted with the exact name of the date property you use in your notes (e.g., date_posted, datePosted, etc.). Dataview is case-sensitive for field names.
    • The field applied should be a boolean (true/false) in your frontmatter or inline fields.
    • The sorting is ascending (asc), showing older posts first. Use desc for newest first.

    If your property names have spaces like date posted, you can quote them or use camelCase:

    table this["date posted"] as "Date Posted", applied
    from #jobs
    where applied = false
    sort this["date posted"] asc
    

    Let me know if you want it customized differently!