Skip to content

Query All The Things

Main Navigation Home Tables Examples Query Reference Render Reference

Appearance

Sidebar Navigation

About

🐣 Your First Query

🚀 Installation

Codeblock Configuration

Output Generation

Settings

Data Tables

Obsidian Notes

Obsidian Lists

Obsidian Tasks

PAGEPROPERTY

Reference - Calendar Table

Dataview Tables

Dataview Pages

Dataview Tasks

Dataview Lists

Legacy Tables

Obsidian Markdown Notes

Obsidian Markdown Lists

Obsidian Markdown Tasks

RETIRED - Obsidian Markdown Files

Writing Queries

AlaSQL Queries

SQL Statements

CASE

CHARINDEX

COALESCE

EXTRACTLINE

IF ... THEN ... ELSE

IN

JoinArray

LINEINDEX

pageProperty

REVERSE

UNION

SQL Functions

arrayfrom(value)

parseWikiLinkDisplayName(string)

parseWikiLinkLocation(string)

stringify(value)

updatePropertyFromList(value)

updatePropertyFromPrompt(value)

wikiLinkHasDisplayName(string)

Custom Functions

Using Templates

Default Helpers

Template

Handlebars Helpers

capitalize

codeBlockFooter

codeBlockHeader

flexibleTaskCheckbox

group

htmlTaskList

lowercase value

markdownTable

micromark

noteLink

obsidian

obsidianHtmlInternalLink

pad

Relational Operators

stringify value

taskCheckbox

taskCheckboxWithAppend

uppercase value

Examples / Tutorials

Active tasks grouped by day

Web based CSV loading

Using CSV loader functionality

Dataview Fields

generated-top-ten-notes

Listing recently updated files

index

index

Journal 1

Journal 2

projects

Project One

Project Two

project-list

Replace target path example

Using updatePropertyFromList

TTRPG Examples

monster-search-live

Monster Search

Handlebars

Capitalize Helper

codeBlockFooter Helper

codeBlockHeader Helper

flexibleTaskCheckbox Helper

Group Helper

htmlTaskList Helper

markdownTable Helper

micromark Helper

noteLink Helper

obsidian Helper

obsidianHtmlInternalLink Helper

pad Helper

Relational Operators Helper

taskCheckbox Helper

taskCheckboxWithAppend Helper

Contributing

Development

Documentation

On this page

Journal One

Pager

Previous pageindex

Next pageJournal 2