TQL Quick Reference - mcndt/obsidian-toggl-integration GitHub Wiki
TQL Quick Reference
To create a Toggl report query, create a codeblock with the toggl
language:
```toggl
// your query here
```
Queries must always have a report type and a time range. Query expressions must always following the following order:
- Report type
- Time range
- (Optional) project filter
- (Optional) group by and/or sort
- (Optional) custom appearance
Report types:
LIST
SUMMARY
Time ranges:
TODAY
WEEK
(this week)MONTH
(this month)PAST {int} {DAYS|WEEKS|MONTHS)
FROM {YYYY-MM-DD} TO {YYYY-MM-DD|TODAY}
Filtering results:
{INCLUDE|EXCLUDE} PROJECTS "project 1"[, "project 2", ...]
{INCLUDE|EXCLUDE} CLIENTS "Client A"[, "Client B", ...]
(only in ^0.5.0)INCLUDE TAGS #tag1, #tag2
EXCLUDE TAGS #tag1, #tag2
Project and client names must be encapsulated by double quotes. Project IDs from the Toggl API can also be used (without double quotes).
Group by:
GROUP BY {DATE|PROJECT|CLIENT}
Sorting:
SORT {ASC|DESC}
Customization:
TITLE "custom title"